OGG抽取进程ABENDED处理分析(OGG-00446,ORA-00308,OGG-01668)

1.故障概述:
该OGG进程共计同步3张表:
TEST.TABLE1
TEST.TABLE2
TEST.TABLE3
源端抽取进程ABENEND,导致数据同步中断.

2.故障处理过程:
重新启动抽取进程后，为保证同步数据完整一致,进行了数据初始化同步,同步过程如下:

2.1重启抽取进程alter extarct ETES1,begin now / start ETES1,确保投递进程正常
2.2暂停源端归档删除定时任务（确保归档空间充足）
2.3在生产库按SCN导出需同步的表数据
SQL> select to_char(current_scn) from v$database ;
TO_CHAR(CURRENT_SCN)
------------------------------------------------------------------
58324959540
nohup expdp \' / as sysdba\'  directory=EXPDP_DIR dumpfile=exp_testdb_%U.dmp logfile=exp_testdb.log tables=TEST.TABLE1,TEST.TABLE2,TEST.TABLE3 flashback_scn=58324959540 COMPRESSION=all parallel=4 exclude=statistics,audit cluster=no &
2.4表数据传至目标端并导入
nohup impdp \' / as sysdba\' directory=EXPDP_DIR           dumpfile=exp_testdb_%U.dmp logfile=imp_testdb.log parallel=4    cluster=no table_exists_action=replace &
2.5启动复制进程
start replicat RTES1, aftercsn 58324959540
2.6开启源端归档删除定时任务

3.故障分析:
查看能够查到最早时间段报错日志,显示是由于抽取进程异常重启后,抽取进程找不到归档文件

WARNING OGG-02810  A relative timestamp, such as NOW, was used as starting position for Extract on an Oracle Ac
tive Data Guard standby database.
ERROR   OGG-00446  Opening file +arch/arch_1_169988_949333117.dbf in DBLOGREADER mode: (308) ORA-00308: cannot 
open archived log '+arch/arch_1_169988_949333117.dbf'
ORA-17503: ksfdopn:2 Failed to open file +arch/arch_1_169988_949333117.dbf
ORA-15173: entry 'arch_1_169988_949333117.dbf' does not exist in directory '/'
Not able to establish initial position for sequence 169988, rba 617674768.

ERROR   OGG-01668  PROCESS ABENDING.

OGG在以下两种情况下,会获取归档文件
1)延迟抽取会触发从归档获取数据
2)大事务中断后重启会触发从归档获取数据

因此,由于抽取进程异常重启,导致当时的大事务中断,因归档定时删除任务删除了所需归档文件,故导致大事务重启后找不到归档文件.