Oracle restore rman backup using Netbackup 9.1 to difference server show RMAN-06172

客戶在測試藉由NBU,來完成異機資料庫還原的步驟,以下是還原的指令

RMAN> SET DBID=1234567890;
RUN {
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE'
  PARAMS 'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64, ENV=(NB_ORA_SID=PDB,NB_ORA_HOME=/u01/app/oracle/product/19.0.0/dbhome_1,ORA_CLIENT=pdb1a,)';
SEND 'NB_ORA_SERV=pbak01,NB_ORA_POLICY=pdb1a-oracle';
RESTORE spfile from 'c-1234567890-20220912-01';
RELEASE CHANNEL ch00;
}

執行過程中發生了RMAN-06172的錯誤

executing command: SET DBID

connected to target database: (not mounted)
using target database control file instead of recovery catalog
allocated channel: ch00
channel ch00: SID=1551 device type=SBT_TAPE
channel ch00: Veritas NetBackup for Oracle - Release 9.1.0.1 (2021082417)

sent command to channel: ch00
Starting restore at 16-SEP-22
channel ch00: no AUTOBACKUP in 7 davs found
released channel: ch00
RMAN-00571: =============================================================
RMAN=00569: ================ ERROR MESSAGE STACK FOLLOWS ================
RMAN-00571: =============================================================
RMAN-03002: failure of restore command at 09/16/2022 10:10:12
RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece

Recovery Manager complete.

Solution:

Add the No.Restrictions file on Master Netbackup

# touch /usr/openv/netbackup/db/altnames/No.Restrictions

張貼留言

0 留言