虽然ogg端不开启归档,也可以实现同步,但是风险比较大。因为ogg捕获(抽取)进程是从redo日志缓冲区或联机重做日志或归档日志中捕获改变,如果捕获进程跟不上日志的切换、或还没捕获到相关改变日志已经被覆盖,那么源端捕获进程就会报错如下错误,那只那重做:
2014-12-15 16:21:36 ERROR OGG-01028 Oracle GoldenGate Capture for Oracle, extscott.prm: Redo sequence 112 no longer available in online logs for thread 1 without archiving enabled, SQL <SELECT MAX(sequence#) FROM v$log WHERE thread# = :ora_thread>, error retrieving redo file name for sequence 112, archived = 1, use_alternate = 0.
2014-12-15 16:21:36 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, extscott.prm: PROCESS ABENDING.
当然,如果开启了归档,但是部分归档丢失了(同时也没有备份),也只能重做,报错如下:
2014-12-15 16:36:23 ERROR OGG-01028 Oracle GoldenGate Capture for Oracle, extscott.prm: Could not find archived log for sequence 79 thread 1 under default destinations SQL <SELECT name FROM v$archived_log WHERE sequence# = :ora_seq_no AND thread# = :ora_thread AND resetlogs_id = :ora_resetlog_id AND archived = 'YES' AND deleted = 'NO' AND name not like '+%' AND standby_dest = 'NO' >, error retrieving redo file name for sequence 79, archived = 1, use_alternate = 0.
2014-12-15 16:36:23 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, extscott.prm: PROCESS ABENDING.