12C ogg之坑爹又坑队友报错OGG-00868 ORA-01291: missing logf

同事正常操作,并停止一个ogg进程,数据库是12c的。ogg当然也是12c的版本。一切都是一个正常的操作,但是出了坑爹的效应,差不多四个人,搞了近3个小时吧。下面我们看看详细的报错;
GGSCI (dwdb1) 1> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING
EXTRACT RUNNING EK_ZW1 00:00:03 00:00:05
EXTRACT STOPPED EXT_KAF1 00:00:04 00:20:06
EXTRACT RUNNING PMP_KAF1 00:00:00 00:00:03
EXTRACT RUNNING PM_ZW1 00:00:00 00:00:08
REPLICAT RUNNING REP_EWM1 00:00:00 00:00:02
REPLICAT RUNNING REP_HX4 00:00:04 00:00:00

我们report这个进程,得到的报错是
2019-08-13 21:24:07 ERROR OGG-00868 Error code 1291, error message: ORA-01291: missing logfile
(Missing Log File WAITING FOR REDO: FILE NA, THREAD 2, SEQUENCE 758882, SCN 0x00000034fb602604. Read Position SCN: 52.4243351251
(227581650643)).

2019-08-13 21:24:07 ERROR OGG-01668 PROCESS ABENDING.

初看是归档丢失了,确实是,该库是一套统计报表库。OLAP系统,每小时归档产生量超级多。所以有脚本定时删除,每5分钟删除一次。

常见的方法,肯定是恢复这个归档文件;
[oracle@dwdb1 ~]$ rman target /

Recovery Manager: Release 12.2.0.1.0 - Production on Tue Aug 13 22:27:09 2019

Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.

connected to target database: DWDB (DBID=2693284169)

RMAN> Restore archivelog from logseq 758882 until logseq 759082;

Starting restore at 13-AUG-19
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=3753 instance=dwdb1 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 08/13/2019 22:27:43
RMAN-20242: specification does not match any archived log in the repository

RMAN> list backup of archivelog sequence between 758882 and 758883;

specification does not match any backup in the repository

但是抱歉,一切都是徒劳,我们的库太大,而且没有专用的备份软件。所以,一直在裸奔状态。就是说要死大家一起死的那种,自己去想吧;

通过查询,得到了一个解决方案;
Oracle GoldenGate is reliant on the Oracle Redo Logs and Archive Logs when capturing transactions. Since I do a lot of testing on VMs (limited space) and in the cloud (limited space … don’t want to burn

  • 0
    点赞
  • 3
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值