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
- Extract Abends with OGG-01028 Non-Standard Redo Detected in 10g Compatible Format (文档 ID 1313864.1)
- Extract Abends with ERROR OGG-01733 Oracle GoldenGate Capture
- Extract Abends - OGG-00458 Cannot Find Metadata Property DDL_MD_COL_HASNOTNULLDEFAULT
- 【OGG-01414】extract abend CACHEMGR: tran id: 0 length memtran
- adpatch failed with error: "Missing file format id in file"
- How to Add/Drop/Resize Redo Log with Physical Standby in place. [ID 473442.1]
- How to Add/Drop/Resize Redo Log with Physical Standby in place. [ID 473442.1]
- Tips on non-standard evaluation in R
- Tips on non-standard evaluation in R
- How To Add/Increase The Size Of Redo Log Files In Rac Environment? (文档 ID 779306.1)
- OGG 补充日志 文档 ID 965876.1
- Goldengate OGG-00665 文档 ID 965876.1
- Incrementally Updated Backup In 10G and higher (文档 ID 303861.1)
- Incrementally Updated Backup In 10G and higher (文档 ID 303861.1)
- 10g Manual Database Creation in Oracle (Single Instance and RAC) (文档 ID 240052.1)
- How to disable the scheduler using SCHEDULER_DISABLED attribute in 10g (文档 ID 1491941.1)
- How to disable the scheduler using SCHEDULER_DISABLED attribute in 10g (文档 ID 1491941.1)
- ogg extract 参数配置
- Java多线程-线程池Executors
- 斗鱼大数据的玩法
- 开源-人脸识别认证-java封装
- %1$s %1$d Android string (java & Android 格式化字符串)
- qt之 绘制时钟
- Extract Abends with OGG-01028 Non-Standard Redo Detected in 10g Compatible Format (文档 ID 1313864.1)
- 异常值处理
- 使用keychain保存用户密码,token等
- 集合2
- 32位eclipse使用64位jdk问题
- java程序main方法的参数String[] args
- @Configuration两种起作用的方法
- 【Android】Error: Expected resource of type styleable [ResourceType]
- 5.4日学习日志