.......
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页最后一段
阅读(3223) | 评论(0) | 转发(0) |