oracle报错ORA-00353: log corruption due to GoldenGate extract process问题

某客户今天告诉我,一套核心库的备库的日志涨的很快,通过检查发现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

oracle报错ORA-00353: log corruption due to GoldenGate extract process问题的相关文章

Oracle报错ORA-00604 ORA-00376 数据库redo undo丢失恢复例子

运维DBA反映数据库存储故障,导致redo undo两个表空间数据文件丢失,数据库无法open启动 某集团的ebs系统因磁盘空间不足把redo和undo存放到raid 0之上,而且该库无任何备份.最终悲剧发生了,raid 0异常导致redo undo全部丢失,数据库无法正常启动(我接手之时数据库已经resetlogs过,但是未成功) 1.Oracle报错ORA-00604 ORA-00376 Sun Jul 27 11:31:27 2014 SMON: enabling cache recove

项目从mysql迁移到oracle报错

问题描述 项目从mysql迁移到oracle报错 本来没有一点错误,迁移之后出现了很多,不知道哪位大神见过下面的问题: 17:23:54,967 ERROR BasicPropertyAccessor:118 - IllegalArgumentException in class: com.ebupt.dataWarehouse.entity.dataQualityMonitoring.MonTaskConEntity, setter method of property: TemporaryI

pl/sql developer-PL/SQL Developer 远程连接Oracle 报错无法解析指定的标识符

问题描述 PL/SQL Developer 远程连接Oracle 报错无法解析指定的标识符 环境: 虚拟机中安装CentOS 6.3 CentOS安装Oracle 11gr2 客户机Win7 问题介绍: 已经在CentOS 启动了实例,监听: 开放了1521端口:虚拟机跟客户机网络连通: 使用DBVisualizer可以连接成功目标实例: PL/SQL Dev连接就报错"ORA-12154: TNS:could not resolve the connect identifier specifi

c++-win32 C++应用程序放到Server08下连接oracle报错

问题描述 win32 C++应用程序放到Server08下连接oracle报错 程序是C++的,连接本地Oracle数据库,方法为 CoInitialize(NULL);ConnectionPtr conn; try{ conn.CreateInstance(_uuidof(Connection)); conn->Open("Provider=OraOLEDB.Oracle.1;Data Source=ORACLE;Persist Security Info=false;Password=

tomcat-jvm每隔一个小时就会报错,打印hs_err_pid*.log

问题描述 jvm每隔一个小时就会报错,打印hs_err_pid*.log 在阿里云服务器上安装jdk7+tomcat7环境,启动tomcat,不发布任何应用,jvm也会不停出错 每隔一个小时就生成一个hs_err_pid*.log 系统版本: Linux iZ23usxuuqdZ 2.6.32-431.23.3.el6.x86_64 #1 SMP Thu Jul 31 17:20:51 UTC 2014 x86_64 x86_64 x86_64 GNU/Linux jdk版本 java vers

hibernate连接oracle报错

问题描述 hibernate连接oracle报错 Exception in thread "main" java.lang.AbstractMethodError: Method oracle/jdbc/driver/OracleDatabaseMetaData.supportsNamedParameters()Z is abstract 解决方案 PB连接Oracle报错plsql 连接 oracle 报错:ora-12514 解决方案二: 你看看是不是你的驱动包的问题,该异常说的是

oracle 报错 ora-00905

问题描述 oracle 报错 ora-00905 report如下,求大神来看看 在行: 99 上开始执行命令时出错 - ALTER TABLE vet ADD CONSTRAINT vetpractice_vet_fk FOREIGN KEY (vetpractice_no, pet_no, owner_no) REFERENCES vetpractice (vetpractice_no, pet_no, owner_no) ON DELETE NO ACTION ON UPDATE NO A

sqlserver 转oracle 报错

问题描述 sqlserver 转oracle 报错 [Err] ORA-32031: illegal reference of a query name in WITH clause 解决方案 查询name的时候不合理的引用,, 解决方案二: Oracle 转换 SqlServer (转)

Oracle报错ORA-00600[2131]坏块 存储掉线恢复案例

运维DBA反映生产Oracle数据库存储掉线Oracle数据库故障无法启动报错:ORA-00600[2131] ORA-07445[kdxlin]等错误 1.启动报ORA-00600[2131]错误 Fri Nov 06 14:50:59 2015 ALTER DATABASE   MOUNT This instance was first to mount Fri Nov 06 14:50:59 2015 ALTER SYSTEM SET local_listener=' (ADDRESS=(