dataguard 主備庫出現gap

zhanglincon發表於2009-05-21

問題描述:

dataguard 主備庫出現gap

15:03時刻,正在主庫rman上刪除已經被備庫applied的歸檔,此時備庫出現WAIT_FOR_GAP:
select * from v$archive_gap;

THREAD# LOW_SEQUENCE# HIGH_SEQUENCE#
---------- ------------- --------------
1 11014 11016
最後解決:
 
GAP現象
備庫:SQL> select process,status from v$managed_standby;
MRP0 WAIT_FOR_GAP
查詢GAP
備庫:SQL> select * from v$archive_gap;
THREAD# LOW_SEQUENCE# HIGH_SEQUENCE#
---------- ------------- --------------
1 11014 11016
查詢歸檔檔案
因為是thread#=1所以到主庫1上查詢: select name from v$archived_log where sequence# between 11014 and 11016;
/mnt/archivelog/ARC110142668101065.arc
/mnt/archivelog/ARC110141668101065.arc
/mnt/archivelog/ARC110151668101065.arc
/mnt/archivelog/ARC110161668101065.arc 後3個檔案,主庫上有,但是備庫上沒有
複製檔案
[oracle@standby2 ~]$ scp 10.128.68.1:/mnt/archivelog/ARC110141668101065.arc /u02/standby/archivelog/
然後用以下命令註冊。問題解決
ALTER DATABASE REGISTER PHYSICAL LOGFILE '';

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/8554499/viewspace-600633/,如需轉載,請註明出處,否則將追究法律責任。

相關文章