同事正常操作,并停止一个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