某客户今天告诉我,一套核心库的备库的日志涨的很快,通过检查发现alert log不断的报错,如下所示:
代码如下 | 复制代码 |
Fri Dec 11 20:48:37 2015 Incomplete read from log member '/arch2/2_82548_864474703.dbf'. Trying next member. Incomplete read from log member '/arch2/2_82548_864474703.dbf'. Trying next member.Archived Log entry 101817 added for thread 2 sequence 82548 ID 0xedd14d2a dest 1: Incomplete read from log member '/arch2/2_82548_864474703.dbf'. Trying next member. Errors in file /oracle/app/oracle/diag/rdbms/crmadg/crmdb2/trace/crmdb2_ora_15304.trc (incident=711224): ORA-00353: log corruption near block 900532 change 14410909668198 time 12/11/2015 20:42:40 ORA-00334: archived log: '/arch2/2_82548_864474703.dbf' Errors in file /oracle/app/oracle/diag/rdbms/crmadg/crmdb2/trace/crmdb2_ora_15305.trc (incident=711216): ORA-00353: log corruption near block 900532 change 14410909668198 time 12/11/2015 20:42:40 ORA-00334: archived log: '/arch2/2_82548_864474703.dbf' Fri Dec 11 20:48:37 2015 Errors in file /oracle/app/oracle/diag/rdbms/crmadg/crmdb2/trace/crmdb2_ora_13484.trc (incident=711238): ORA-00353: log corruption near block 900532 change 14410909668198 time 12/11/2015 20:42:40 ORA-00334: archived log: '/arch2/2_82548_864474703.dbf' Fri Dec 11 20:49:13 2015 Sweep [inc][711238]: completed |
查看其中的trace可以看到如下的内容:
代码如下 | 复制代码 |
*** ACTION NAME:() 2015-12-10 21:58:10.036 kcrfrxini: Limitread is not enabled for standby db kcrfrxini: Limitread is not enabled for standby db kcrfrxini: Limitread is not enabled for standby db |
....
我google一把,发现居然毫无所获。。。从alert log最开始报错的时间点开始看,我怀疑跟最近部署的goldengate有关系。
后面我搜索关键字ORA-00353 log corruption ogg extract 发现mos 论坛上有人遇到类似的问题,发帖者提到使用了如下的参数:
代码如下 | 复制代码 |
TranLogOptions DBLOGREADER TranLogOptions BUFSIZE 4096000 TranLogOptions DBLOGREADERBUFSIZE 4096000 |
该兄弟的环境为oracle 11.2.0.3 rac,ogg 版本为11.2.0.1.5;
最后据说通过将参数buffersize 、DBLOGREADERBUFSIZE 调小来解决该问题,最后貌似并没有提到解决了,只是暂时未出现。
考虑到客户这里是Oracle 11.2.0.4环境,虽然是ASM环境,然而归档日志都存放到本地文件系统上。
再次检查goldengate extract参数:
代码如下 | 复制代码 |
ogg_eda@xxx:/ogg_eda$ ./ggsci Oracle GoldenGate Command Interpreter for Oracle Version 11.2.1.0.27 19591627 OGGCORE_11.2.1.0.0OGGBP_PLATFORMS_141006.1156 HP/UX, IA64, 64bit (optimized), Oracle 11g on Oct 6 2014 13:37:58 Copyright (C) 1995, 2014, Oracle and/or its affiliates. All rights reserved. GGSCI (xxx) 2> info all Program Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNING EXTRACT RUNNING DPEODS1 00:00:00 00:00:00 EXTRACT RUNNING DPEODS2 00:00:00 00:00:00 EXTRACT RUNNING DPEODS3 00:00:00 00:00:07 EXTRACT RUNNING DPEODS4 00:00:00 00:00:08 EXTRACT RUNNING EXTODS1 00:00:00 00:00:06 EXTRACT RUNNING EXTODS2 00:00:00 00:00:00 EXTRACT RUNNING EXTODS3 00:00:00 00:00:03 EXTRACT RUNNING EXTODS4 00:00:00 00:00:03 GGSCI (xxx) 3> view param EXTODS1 EXTRACT extods1 setenv (NLS_LANG = "AMERICAN_AMERICA.ZHS16GBK") SETENV (ORACLE_HOME = "/oracle/app/oracle/product/11.2.0") SETENV (ORACLE_SID = "xxx2") USERID ogg_eda, PASSWORD AACAAAAAAAAAAAIARCQIHGOIWCQJXITB ,ENCRYPTKEY default TRANLOGOPTIONS ALTARCHIVELOGDEST primary instance crmdb2 /arch2,ALTARCHIVELOGDEST primary instance crmdb1 /arch2 TRANLOGOPTIONS ARCHIVEDLOGONLY TRANLOGOPTIONS ALTARCHIVEDLOGFORMAT %t_%s_%r.dbf TranlogOptions DBLOGREADER REPORTCOUNT EVERY 1 MINUTES, RATE DISCARDFILE ./dirrpt/extods1.dsc,APPEND,MEGABYTES 1024 DBOPTIONS ALLOWUNUSEDCOLUMN WARNLONGTRANS 2h,CHECKINTERVAL 3m EXTTRAIL ./dirdat/ods/o1 FETCHOPTIONS NOUSESNAPSHOT 。。。。。 |
由于是抽取active dataguard且仅仅抽取archivelog,因此完全没有必要加入TranlogOptions DBLOGREADER参数。
这里我怀疑跟该参数有关,通过屏蔽该参数后,发现不在报错。看来这是GoldengGate的未知bug呀!
时间: 2024-11-03 12:00:25