---

---

（1）      standby 取消recover

SQL> select * from v$archive_gap ;

SQL> alter database recover managed standby database cancel;

（2）      在主库v$archived_log查询gap中LOW_SEQUENCE#-1对应的scn（即：first_change#）

SQL>select THREAD#,SEQUENCE#,FIRST_CHANGE#,NEXT_CHANGE#from v$archived_log where SEQUENCE#=98;

  THREAD#    SEQUENCE#   FIRST_CHANGE#    NEXT_CHANGE#

  ---------- ---------- ------------- ------------

         1      481     542543    551725

（3）      在primary做基于该scn的增量备份

RMAN> run {

2> allocate channel c1 device type disk;

3> allocate channel c2 device type disk;

4> backup incremental from scn 542543 database format '/oradata/bak/ora_scn_%U.bak';    #incremental单词不要写错

5> release channel c1;

6> }

（4）      在primary创建新的standby controlfile

SQL> alter database create standby controlfile as '/oradata/bak/control.ctl';

（5）      将增量的备份集和创建好的standby controlfile 拷贝的备库

（6）      备库shutdown

SQL> shutdownimmediate

（7）      使用新的standby controlfile 启动备库到mount

SQL> startup mount;

（8）      Standby 做recover

RMAN> catalog start with '/oradata/bak/ora_scn_05ohoqvu_1_1';     ###放在standby的增量备份的备份集

RMAN> recover database noredo;

（9）      验证结果

Standby 执行接收并恢复日志操作

SQL> alterdatabase recover managed standby database disconnect from session;

SQL> select * fromv$archive_gap；

no rows selected

SQL> select THREAD#,max(SEQUENCE#) from v$archived_log group by THREAD#;

   THREAD# MAX(SEQUENCE#)

---------- --------------

         1           3729

 

Primary端验证结果

 

SQL> select THREAD# ,max(SEQUENCE#) from v$archived_log  group by THREAD#;

   THREAD# MAX(SEQUENCE#)

--------- --------------

1                                      3729

Primary进行日志切换，查看standby告警日志。