goldengate 缺少归档日志abend处理

发布时间：2020-07-15 09:40:53 阅读：396 作者：春秋小记栏目：关系型数据库

GO开发者专用服务器限时活动，0元免费领，库存有限，领完即止！点击查看>>

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';

亿速云「云服务器」，即开即用、新一代英特尔至强铂金CPU、三副本存储NVMe SSD云盘，价格低至29元/月。点击查看>>

向AI问一下细节

goldengate 缺少归档日志abend处理

猜你喜欢

最新资讯

相关推荐

开发者交流群：

相关标签