Chinaunix首页 | 论坛 | 博客
  • 博客访问: 294667
  • 博文数量: 60
  • 博客积分: 1437
  • 博客等级: 中尉
  • 技术积分: 632
  • 用 户 组: 普通用户
  • 注册时间: 2011-02-10 14:12
文章存档

2012年(7)

2011年(53)

分类: Oracle

2011-02-13 09:24:59

.......

GGSCI (ora10g) 9> add extract extscott, tranlog, begin now
EXTRACT added.
 
 
GGSCI (ora10g) 10> add exttrail /ggs/dirdat/lc, extract extscott
EXTTRAIL added.
 
 
GGSCI (ora10g) 11> edit params extscott
 
 
 
GGSCI (ora10g) 12> add extract pumplc, exttrailsource /ggs/dirdat/lc, begin now
EXTRACT added.
 
 
GGSCI (ora10g) 13> add rmttrail /ggs/dirdat/lc, extract pumplc
RMTTRAIL added.
 

GGSCI (ora10g) 14> edit params pumplc
 
 
 
GGSCI (ora10g) 15> edir paramd extscott
ERROR: Invalid command.
 
GGSCI (ora10g) 16> edit params extscott
 
 
 
GGSCI (ora10g) 17> info extract extscott
 
EXTRACT    EXTSCOTT  Initialized   2009-12-30 16:19   Status STOPPED
Checkpoint Lag       00:00:00 (updated 00:19:56 ago)
Log Read Checkpoint  Oracle Redo Logs
                     2009-12-30 16:19:42  Seqno 0, RBA 0
 
 
GGSCI (ora10g) 18> start extract extscott

报如下错误:

2009-12-30 16:46:58  GGS ERROR       500  Oracle GoldenGate Capture for Oracle, extscott.prm:  Found unsupported in-memory undo record in sequence 41, at RBA 21990416, with SCN 0.836275 (836275) ... Minimum supplemental logging must be enabled to prevent data loss.
2009-12-30 16:46:58  GGS ERROR       190  Oracle GoldenGate Capture for Oracle, extscott.prm:  PROCESS ABENDING.


解决过程:
1.在数据库一级设置supplemental logging
SQL>alter database add supplemental log data;

2.放弃之前捕获的文件:

alter extract extscott, begin now

3.data pump进程也需要启动:
start extract dumplc

GGSCI (ora10g) 7> send extract extscott, rollover --切换trail文件
 
Sending ROLLOVER request to EXTRACT EXTSCOTT ...
Request processed.
 
 
GGSCI (ora10g) 8> status * --检查源数据库上的extract进程状态
EXTRACT EXTSCOTT: RUNNING
EXTRACT PUMPLC: STOPPED
 
 
GGSCI (ora10g) 9> start extract pumplc --启动data pump进程
 
Sending START request to MANAGER ...
EXTRACT PUMPLC starting
 
 
GGSCI (ora10g) 10> status *
EXTRACT EXTSCOTT: RUNNING
EXTRACT PUMPLC: RUNNING
 
 
GGSCI (ora10g) 11>

总结
----
1.在配置GG之前,一定要修改数据库:alter database add supplemnetal log data;
2.配置GG的extract时候,如果使用data pump,则不要设置begin now,而是使用begin timestamp

Do not use NOW for a data pump Extract except to bypass data that
was captured to the trail prior to the ADD EXTRACT statement.


参考:Oracle® GoldenGate Reference Guide version 10.4 第24页最后一段










阅读(3187) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~