客戶在測試藉由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 留言