Oracle restore archivelog from NetBackup

2021-11-24

18
0
Oracle
2022-02-10

記錄執行過程與注意項目

1. 登入 RMAN

$ rman target sys/password@tnsname catalog rman/rman@tnsname

2. 執行還原腳本

rman> run {
set archivelog destination to '/u01/app/archivelog';
allocate channel c1 type 'SBT_TAPE' parms 'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64';
SEND 'NB_ORA_SERV=nbusvr,NB_ORA_CLIENT=clientsrv,NB_ORA_POLICY=nbu_policy_name';
restore archivelog from logseq=1234 until logseq=2234;
release channel c1;
}

Note:

a. Restore archivelog sequence between number

command: restore archivelog from logseq=1234 until logseq=2234;
result: archivelog seq is 1234 ~ 2233

b. Restore archivelog command

# restore archivelog 兩種方式均可
restore archivelog from logseq=1234 until logseq=2234;
restore archivelog from sequence 1234 until sequence 2234;

c. Restore archivelog to different destination

set archivelog destination to '/u01/app/archivelog';

已轉向 blogger 記錄

https://slowlife-notes.blogspot.com

回首頁