Extract Abends with OGG-01028 Non-Standard Redo Detected in 10g Compatible Format (文档 ID 1313864.1)

来源:互联网 发布:市场花园知乎 编辑:程序博客网 时间:2024/05/29 07:26
Extract Abends with OGG-01028 Non-Standard Redo Detected in 10g Compatible Format (文档 ID 1313864.1)   --------------------------------------------------------------------------------In this Document Symptoms  Cause  Solution  References --------------------------------------------------------------------------------Applies to: Oracle GoldenGate - Version 10.4.0.19 and laterInformation in this document applies to any platform.Checked for relevance 15-Oct-2012SymptomsOGG Extract abends : Non-Standard Redo Detected in 10g compatible FormatCauseCause 1This error occurs when  the extract's starting seqno# and rba are not on log write boundary. When positioning by time, extract will find the right log write boundary by itself.Cause 2Extract may fail with same error due to bug in AsyncReader logic. This issue occurs when the AsyncReader reaches an EOF condition and stops read operations before the REDO thread detects the EOF condition and instructs the AsyncReader thread to stop reading.Cause 3Extract is altered by extseqno and extrbaalter extract EACHINTP thread 1, extseqno 10552,extrba 26465408alter extract EACHINTP thread 2, extseqno 5431,extrba 1148456Cause 4Extract with DBLOGREADER can produce this error reading Oracle database versions that support DBLOGREADER APIs and is related to the premature logfile switching, hence "bad" data has been read by the DBLOGREADER api and passed to GoldenGate Extract, which has caused the Extract abend. A restart does not resolve this issue. Please refer to the reference manual for Oracle database versions that support DBLOGREADER APIs.  SolutionSolution 1Alter extract to position by timestamp and restartggsci> ALTER EXTRACT {extract group}, BEGIN {timestamp}ggsci> START {extract group}Solution 21. This issue is recoverable by restarting extract2. This issue can be avoided via 'tranlogoptions _NOREADAHEAD CURRENT'3. Upgrade to 11.2.1.0.0 or later Solution 3 Alter extract to position by timestamp and restartggsci> ALTER EXTRACT {extract group}, BEGIN {timestamp}ggsci> START {extract group}Solution 4 Include parameter You need to upgrade to v11.2.1.0.26 or later and specify this parameterTRANLOGOPTIONS _DISABLESTREAMLINEDDBLOGREADERAs of version 12 this option is permanently disabled.  

以上是mos上的转载,客户生产环境备份采用nbu定时备份删除归档日志。

有一天发现抽取abend,恢复归档日志后重启ogg报了这个错。我这边版本是11.2.1.0.33 ,按照官网的方式做了处理,进程成功running

0 0
原创粉丝点击