備庫使用RMAN獲得歸檔日志
原來在主備庫上發(fā)現(xiàn)日志應用存在異常時,都是通過拷貝的方式將歸檔日志從主庫傳到備庫,然后注冊應用
在備庫通過RMAN來獲取歸檔日志更加簡單
1.在主庫確認歸檔序號
select NAME,DEST_ID,THREAD#,SEQUENCE#,COMPLETION_TIME,REGISTRAR,APPLIED,DELETED from v$ARCHIVED_LOG where SEQUENCE# between 44561 and 44566 and THREAD#=1 and DEST_ID=1;
2.在備庫執(zhí)行獲取歸檔命令
rman target sys/oracle@primary auxiliary sys/oracle@standby
backup as copy archivelog sequence between 44561 and 44566 thread 1 auxiliary format '+DATA';
backup as copy archivelog sequence between 44159 and 44160 thread 2 auxiliary format '+DATA';
3.在備庫注冊歸檔,少量使用alter命令;多量使用catalog命令。
alter database register physical logfile '歸檔路徑';
catalog start with '+DATA/dghxa/archivelog/';

標簽: