问题描述:
dataguard 主备库出现gap
15:03时刻,正在主库rman上删除已经被备库applied的归档,此时备库出现WAIT_FOR_GAP:
select * from v$archive_gap;
THREAD# LOW_SEQUENCE# HIGH_SEQUENCE#
---------- ------------- --------------
1 11014 11016
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/
备库: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 '';
ALTER DATABASE REGISTER PHYSICAL LOGFILE '';
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/8554499/viewspace-600633/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/8554499/viewspace-600633/