确定增备scn范围,通过alert日志获取gap日志序列
/u01/oracle/diag/rdbms/<sid>/<sid>/trace/ alert日志
GAP - thread 1 sequence 76893-76992
利用磁带备份处理GAP
1.在主库上
select 'catalog device type '|| '''SBT_TAPE''' ||' backuppiece ''/'||HANDLE||''';' from (select distinct a.HANDLE from v$backup_piece_details a, v$backup_archivelog_details b where set_count = id2 and b.thread#=1 and b.SEQUENCE# >76892 and b.SEQUENCE#<76993);
2.在DG库上注册备份集
rman target /
configure CHANNEL device type 'SBT_TAPE' PARMS 'ENV=(NB_ORA_CLIENT=主库主机名)';
catalog device type 'SBT_TAPE' backuppiece '/al_XXXXXXXXXXXXXXXXX';
3.注册完了 第一个配置的参数清除下
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' CLEAR;
4.恢复日志
rman target /
run {
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE' parms 'ENV=(NB_ORA_CLIENT=主库主机名)';
ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE' parms 'ENV=(NB_ORA_CLIENT=主库主机名)';
restore archivelog from logseq 76893 until logseq 76992;
release channel ch00;
release channel ch01;
}