oracle dataguard archive gap后恢复
起因:源端数据库应用程序逻辑错误,导致重大量重试回滚,日产生归档300GB,异地备份在10Mbps的网速下,产生了archive gap; select current_scn from v$database; 1612480746 2 在主库生成基于备库scn的增量备份 --primary show all; run{ ALLOCATE CHANNEL d1 TYPE disk; set limit channel d1 kbytes=104857600; BACKUP INCREMENTAL FROM SCN 1612480746 DATABASE FORMAT 'J:%U_for_stb.bk' include current controlfile for standby; } 3 传送日志到备库 --standby catalog start with 'e:inc'; 4 应用control file,增量备份集 restore standby controlfile to 'e:control01.ctl' ; shutdown immediate; copy e:control01.ctl E:ORADATATCISCONTROL01.CTL copy e:control01.ctl E:ORADATATCISCONTROL02.CTL copy e:control01.ctl E:ORADATATCISCONTROL03.CTL
RMAN-03002: recover 命令 (在 07/08/2018 10:49:09 上) 失败 RMAN-06094: 数据文件5必须重新存储 启动原先的备库,select name from v$datafile alter system set standby_file_management=manual; alter database rename file 'E:ORADATATCISUBSS_INDX01.DBF' to 'd:oradatatcisubss_indx01.dbf'; alter database rename file 'E:ORADATATCISUBSS_INDX02.DBF' to 'd:oradatatcisubss_indx02.dbf'; 6 再次recover database noredo 又报错,第16号文件不存在 RMAN-03002: recover 命令 (在 07/08/2018 10:49:09 上) 失败 RMAN-06094: 数据文件16必须重新存储 以老的控制文件启动,发现第16号文件是之后添加的 --primary catalog start with 'e:inc'; restore datafile 16 ; recover database noredo; RMAN-03002: recover 命令 (在 07/07/2018 10:44:11 上) 失败 ORA-19693: 已包括备份片段 E:INCCDT7BHIL_1_1_FOR_STB.BK recover失败,很名显,这个16号文件是之后恢复的,其scn大于之前做的备份片集 9 清理无效的备份片,再次重复2之后的步骤,backup,restore controlfile,rename datafile,recover database ; 10 恢复完成后检查 SQL> select status,blocks,process,sequence# from v$managed_standby; STATUS BLOCKS PROCESS SEQUENCE# ------------ ---------- --------- ---------- CONNECTED 0 ARCH 0 CONNECTED 0 ARCH 0 CONNECTED 0 ARCH 0 CONNECTED 0 ARCH 0 IDLE 20480 RFS 45261 IDLE 20480 RFS 45262 IDLE 0 RFS 0 APPLYING_LOG 81560 MRP0 45248 检查归档,删除已应用的归档 select a.thread#,a.sequence#,a.applied,a.name from v$archived_log a,v$database d where a.activation# = d.activation# and a.applied='YES' order by 2; (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |