---

---

（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告警日誌。