OGG-00717

今天配置双向ogg时，启动extract捕获（抽取）进程进程，报错：

GGSCI (db1) 17> start extscott
[oracle@db1 ogg]$ tail -f ggserr.log 
2014-12-15 15:06:41  ERROR   OGG-00717  Oracle GoldenGate Capture for Oracle, extscott.prm:  Found unsupported in-memory undo record in sequence 111, at RBA 10270224, with SCN 0.2782904 (2782904) ... Minimum supplemental logging must be enabled to prevent data loss.
2014-12-15 15:06:41  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, extscott.prm:  PROCESS ABENDING.

知道怎么忘记开启辅助日志，开启辅助日志并开启强制写日志：

<pre name="code" class="sql"><pre name="code" class="sql">SQL> alter database add supplemental log data;
SQL> alter system switch logfile;
SQL> alterdatabase force logging;

</pre>

再次启动报同样的错，于是重启mgr：

GGSCI (db1) 17> stop mgr
GGSCI (db1) 18> start mgr

还是报同样的错，最后重新添加tranlog，重启成功：

GGSCI (db1) 20> dblogin userid ogg                                      
Password: 
Successfully logged into database.
GGSCI (db1) 21> add trandata scott.*
GGSCI (db1) 22> alter extract extscott,tranlog,begin now 
GGSCI (db1) 23> alter exttrail ./dirdat/bb,extract extscott,megabytes 10

所以，源端可以不开归档，但是必须开启辅助日志和强制写日志。