$$Oracle 11.2.0.4.0 Dataguard部署和日常维护(4)-Datauard Gap事件解决篇
5墨值下载
$$Oracle 11.2.0.4.0 Dataguard
部署和日常维护 (4)-Datauard Gap
事件解决篇
Oracle dataguard 主库删除备库需要的归档时,会导致 gap 事情的产生,或者备库由于网
络或物理故障原因,倒是备库远远落后于主库,都会产生 gap 事件,本例模拟 gap 事件的产生
以及处理.
1. 查看当前 dataguard 同步状态
primary
库查看
select THREAD#,GROUP#,SEQUENCE#,BYTES/1024/1024 as MB,ARCHIVED,STATUS from
v$log;
THREAD# GROUP# SEQUENCE# MB ARCHIVED STATUS
---------- ---------- ---------- ---------- ---------
------------------------------------------------
1 1 16 100 YES INACTIVE
1 2 17 100 YES INACTIVE
1 3 18 100 NO CURRENT #可以看到 primary 库当前
最新的联机日志文件序列号是 18
column NAME format a60
select NAME,sequence#,standby_dest,archived,applied from v$archived_log;
NAME SEQUENCE# STANDBY_D ARCHIVED APPLIED
------------------------------------------------------------ ----------
--------- --------- ---------------------------
/u01/app/oracle/arch/1_4_947274260.dbf 4 NO YES
NO
/u01/app/oracle/arch/1_5_947274260.dbf 5 NO YES
NO
/u01/app/oracle/arch/1_6_947274260.dbf 6 NO YES
NO
/u01/app/oracle/arch/1_7_947274260.dbf 7 NO YES
NO
/u01/app/oracle/arch/1_8_947274260.dbf 8 NO YES
NO
userdata2 8 YES YES YES
userdata2 9 YES YES YES
/u01/app/oracle/arch/1_9_947274260.dbf 9 NO YES
NO
/u01/app/oracle/arch/1_10_947274260.dbf 10 NO YES
NO
userdata2 10 YES YES YES
userdata2 11 YES YES YES
/u01/app/oracle/arch/1_11_947274260.dbf 11 NO YES
NO
userdata2 12 YES YES YES
/u01/app/oracle/arch/1_12_947274260.dbf 12 NO YES
NO
userdata2 13 YES YES YES
/u01/app/oracle/arch/1_13_947274260.dbf 13 NO YES
NO
userdata2 14 YES YES YES
/u01/app/oracle/arch/1_14_947274260.dbf 14 NO YES
NO
userdata2 15 YES YES YES
/u01/app/oracle/arch/1_15_947274260.dbf 15 NO YES
NO
userdata2 16 YES YES YES
/u01/app/oracle/arch/1_16_947274260.dbf 16 NO YES
NO
userdata2 17 YES YES NO
/u01/app/oracle/arch/1_17_947274260.dbf 17 NO YES
NO #primary 和 standby 数据库的 17 号日志都已经归档
standby
库查看
select THREAD#,GROUP#,SEQUENCE#,BYTES/1024/1024 as MB,ARCHIVED,STATUS from
v$log order by SEQUENCE#;
THREAD# GROUP# SEQUENCE# MB ARCHIVED STATUS
---------- ---------- ---------- ---------- ---------
------------------------------------------------
1 1 16 100 YES CLEARING
1 2 17 100 YES CLEARING
1 3 18 100 YES CURRENT
select process,status,thread#,sequence#,block#,blocks from
v$managed_standby;
PROCESS STATUS THREAD# SEQUENCE# BLOCK#
BLOCKS
--------------- ---------------------------- ---------- ----------
---------- ----------
ARCH CLOSING 1 17 174080
236
ARCH CLOSING 1 16 167936
135
ARCH CONNECTED 0 0 0
0
ARCH CLOSING 1 15 163840
391
RFS IDLE 0 0 0 0
RFS IDLE 1 18 42794
1
RFS IDLE 0 0 0 0
MRP0 APPLYING_LOG 1 18 42794
204800 #可以看到 standby 库当前正在从 primary 读取最新的 18 号日志文件
2. 模拟产生 gap 事件
2.1. 停掉备库的 dataguard 进程和数据库实例
alter database recover managed standby database cancel;
shutdown immediate;
$ lsnrctl stop
2.2. 主库切 5 个归档文件,并将新产生的 5 个归档文件剪切出归档目录
alter system archive log current;
alter system archive log current;
alter system archive log current;
alter system archive log current;
alter system archive log current;
select THREAD#,GROUP#,SEQUENCE#,BYTES/1024/1024 as MB,ARCHIVED,STATUS from
v$log;
THREAD# GROUP# SEQUENCE# MB ARCHIVED STATUS
---------- ---------- ---------- ---------- ---------
------------------------------------------------
1 1 22 100 YES INACTIVE
1 2 23 100 NO CURRENT
1 3 21 100 YES INACTIVE
select NAME,sequence#,archived,applied from v$archived_log where SEQUENCE# >
17;
#可以看到刚才手动切了 5 次,多了 5 个归档文件,序列号为 18~22,一会儿通过手动注册的方式解决
18~22 的 gap 事件
NAME SEQUENCE# ARCHIVED APPLIED
------------------------------------------------------------ ----------
--------- ---------------------------
/u01/app/oracle/arch/1_18_947274260.dbf 18 YES NO
/u01/app/oracle/arch/1_19_947274260.dbf 19 YES NO
/u01/app/oracle/arch/1_20_947274260.dbf 20 YES NO
of 9
5墨值下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
评论