Warning: file_put_contents(/datas/wwwroot/jiajiahui/core/caches/caches_template/2/default/show.php): failed to open stream: Permission denied in /datas/wwwroot/jiajiahui/core/libraries/classes/template_cache.class.php on line 55

Warning: chmod(): Operation not permitted in /datas/wwwroot/jiajiahui/core/libraries/classes/template_cache.class.php on line 56
goldengate 缺少归档日志abend处理 - 源码之家

goldengate 缺少归档日志abend处理

ogg抽取进程abend,检查发现备库的日志被删除掉了:

2018-10-11 11:14:52  ERROR   OGG-00446  Could not find archived log for sequence 20064 thread 2 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' >, error retrieving redo file name for sequence 20064, archived = 1, use_alternate = 0Not able to establish initia
l position for sequence 20064, rba 235066896.

2018-10-11 11:14:52  ERROR   OGG-01668  PROCESS ABENDING.

到主库拷贝日志:
ASMCMD> cp thread_2_seq_20064.489.989227143 /home/grid/thread_2_seq_20064.489.989227143
copying +arch/chunqiu/ARCHIVELOG/2018_10_11/thread_2_seq_20064.489.989227143 -> /home/grid/thread_2_seq_20064.489.989227143

scp 拷贝到远程的备库上,注册归档:
alter database register logfile '/home/oracle/thread_2_seq_20064.489.989227143';

重新启动抽取进程,正常。

测试日志参考:
1.注册少量的日志:
SQL> alter database register logfile '/home/oracle/thread_2_seq_20064.489.989227143';
2.注册大量的日志
rman> catalog start with '/home/oracle/archlog';