ITPub博客
首页 博客 专栏 学院 社区 IT新媒体评选
发博

首页 > Linux操作系统 > Linux操作系统 > [ID 965876.1]

[ID 965876.1]

原创 Linux操作系统 作者：renjixinchina 时间：2013-01-11 18:02:09 0 删除 编辑

Applies to:

Oracle GoldenGate - Version 4.0.0 to 11.2.1.0.1 [Release 4.0.0 to 11.2]
Information in this document applies to any platform.
Tables with nologging option can cause Extract to abend with OGG-1965 and Extract will not restart.
ERROR OGG-01965 The redo record indicates data loss on object 

Fix

To turn on Oracle's supplemental logging at the database level, GoldenGate requires this command to be executed in SQLPLUS :

SQL > ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;


This change to add supplemental logging will not take effect until the current redo log is switched, so the following command must also be executed:

SQL > ALTER SYSTEM SWITCH LOGFILE;

 

Note: You must have the ALTER DATABASE and ALTER SYSTEM privileges to execute the above sql statements.


Alternatvely you can use



ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY, UNIQUE INDEX) COLUMNS;

 

To turn on supplemental logging at the table level, you can execute this command through GGSCI :

GGSCI> dblogin userid , password
GGSCI> add trandata . <-- for a single table


or

GGSCI > add trandata .* <-- for all tables in a schema. This could take a very long time if you have several hundred tables in the schema.



You can create scripts and execute them in parallel for faster enablement.

来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/15747463/viewspace-752538/ ，如需转载，请注明出处，否则将追究法律责任。

0
0
上一篇： GGS ERROR 190 No Minimum Supplemental Logging Is Enabled
下一篇： [转载]oracle手动锁表
请登录后发表评论 登录
全部评论
renjixinchina

注册时间：2011-01-30

  • 博文量
    373
  • 访问量
    2163133

最新文章

支持我们 作者招募 用户协议 FAQ Contact Us 编辑准则

北京盛拓优讯信息技术有限公司. 版权所有  京ICP备16024965号-8 北京公安局海淀分局网监中心备案编号：11010802021510 niuxiaotong@pcpop.com 17352615567 未成年人举报专区

广播电视节目制作经营许可证(京) 字第1234号 中国互联网协会会员

违法和不良信息举报电话:18101376593