Oracle歸檔檔案丟失導致OGG不用啟動
環境：AIX7.1
DB：ORACLE11.2.0.4
OGG：12.3.0.1.4
問題：因不能重複同步資料到目標庫，關閉歸檔，恢復資料後不能啟動OGG
#=========================================================#
Connecting to 153.12.72.110:22...
Connection established.
To escape to local shell, press 'Ctrl+Alt+]'.
1 unsuccessful login attempt since last login.
Last unsuccessful login: Fri Dec 6 18:38:24 BEIST 2019 on ssh from 89.12.74.46
Last login: Fri Dec 6 18:38:05 BEIST 2019 on ssh from 89.12.88.71
*******************************************************************************
* *
* *
* Welcome to AIX Version 7.1! *
* *
* *
* Please see the README file in /usr/lpp/bos for information pertinent to *
* this release of the AIX Operating System. *
* *
* *
*******************************************************************************
[YOU HAVE NEW MAIL]
#==============================停止OGG===============================
#======================停止順序：EX->PP->mgr=========================
nskxt1:/home/oracle$cd /ogg/ogg12c
nskxt1:/ogg/ogg12c$ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 12.3.0.1.4 OGGCORE_12.3.0.1.0_PLATFORMS_180415.0359_FBO
AIX 6, ppc, 64bit (optimized), Oracle 11g on Apr 19 2018 05:30:29
Operating system character set identified as US-ASCII.
Copyright (C) 1995, 2018, Oracle and/or its affiliates. All rights reserved.
GGSCI (nskxt1) 1> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EX_DZFP 00:00:00 00:00:00
EXTRACT RUNNING EX_PTFP 00:00:01 00:00:03
EXTRACT RUNNING EX_QTFP 00:00:01 00:00:09
EXTRACT RUNNING EX_ZYFP 00:00:00 00:00:00
EXTRACT RUNNING PP_DZFP 00:00:00 00:00:00
EXTRACT RUNNING PP_PTFP 00:00:00 00:00:03
EXTRACT RUNNING PP_QTFP 00:00:00 00:00:07
EXTRACT RUNNING PP_ZYFP 00:00:00 00:00:04
GGSCI (nskxt1) 3> stop ex_dzfp
Sending STOP request to EXTRACT EX_DZFP ...
Request processed.
GGSCI (nskxt1) 5> stop ex_ptfp
Sending STOP request to EXTRACT EX_PTFP ...
Request processed.
GGSCI (nskxt1) 6> stop ex_qtfp
Sending STOP request to EXTRACT EX_QTFP ...
Request processed.
GGSCI (nskxt1) 7> stop ex_zyfp
Sending STOP request to EXTRACT EX_ZYFP ...
Request processed.
GGSCI (nskxt1) 8> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT STOPPED EX_DZFP 00:00:01 00:00:49
EXTRACT STOPPED EX_PTFP 00:00:01 00:00:27
EXTRACT STOPPED EX_QTFP 00:00:01 00:00:16
EXTRACT STOPPED EX_ZYFP 00:00:02 00:00:03
EXTRACT RUNNING PP_DZFP 00:00:00 00:00:02
EXTRACT RUNNING PP_PTFP 00:00:00 00:00:05
EXTRACT RUNNING PP_QTFP 00:00:00 00:00:10
EXTRACT RUNNING PP_ZYFP 00:00:00 00:00:07
GGSCI (nskxt1) 12> stop PP_DZFP
Sending STOP request to EXTRACT PP_DZFP ...
Request processed.
GGSCI (nskxt1) 14> stop PP_PTFP
Sending STOP request to EXTRACT PP_PTFP ...
Request processed.
GGSCI (nskxt1) 15> stop PP_QTFP
Sending STOP request to EXTRACT PP_QTFP ...
Request processed.
GGSCI (nskxt1) 16> stop PP_ZYFP
Sending STOP request to EXTRACT PP_ZYFP ...
Request processed.
GGSCI (nskxt1) 17> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT STOPPED EX_DZFP 00:00:01 00:04:05
EXTRACT STOPPED EX_PTFP 00:00:01 00:03:43
EXTRACT STOPPED EX_QTFP 00:00:01 00:03:32
EXTRACT STOPPED EX_ZYFP 00:00:02 00:03:18
EXTRACT STOPPED PP_DZFP 00:00:00 00:00:52
EXTRACT STOPPED PP_PTFP 00:00:00 00:00:27
EXTRACT STOPPED PP_QTFP 00:00:00 00:00:16
EXTRACT STOPPED PP_ZYFP 00:00:00 00:00:05
GGSCI (nskxt1) 18> stop mgr
Manager process is required by other GGS processes.
Are you sure you want to stop it (y/n)?y
Sending STOP request to MANAGER ...
Request processed.
Manager stopped.
GGSCI (nskxt1) 19> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER STOPPED
EXTRACT STOPPED EX_DZFP 00:00:01 00:04:39
EXTRACT STOPPED EX_PTFP 00:00:01 00:04:17
EXTRACT STOPPED EX_QTFP 00:00:01 00:04:06
EXTRACT STOPPED EX_ZYFP 00:00:02 00:03:52
EXTRACT STOPPED PP_DZFP 00:00:00 00:01:26
EXTRACT STOPPED PP_PTFP 00:00:00 00:01:01
EXTRACT STOPPED PP_QTFP 00:00:00 00:00:50
EXTRACT STOPPED PP_ZYFP 00:00:00 00:00:39
GGSCI (nskxt1) 20>exit
#============================停止資料庫歸檔============================
# RAC節點都要關閉掉
# 在110中執行和在111中執行，都要執行
sqlplus / as sysdba
SQL>shutdown immediate;
# 在110中執行
SQL>startup mount;
SQL>alter database noarchivelog;
#===========================記錄停止歸檔時間===========================
nskxt2:/home/oracle$date
Fri Dec 6 19:10:01 BEIST 2019
SQL>alter database open;
SQL>alter system set cluster_database=true scope=spfile;
# 檢視歸檔狀態
SQL>archive log list;
#============================處理、恢復資料============================
略
#==========================啟動資料庫歸檔和資料庫======================
#================================啟動OGG===============================
#==========================順序：MGR->PP->EX===========================
GGSCI (nskxt1) 1> start mgr
GGSCI (nskxt1) 2> start PP_DZFP
Sending START request to MANAGER ...
EXTRACT PP_DZFP starting
GGSCI (nskxt1) 3> start PP_PTFP
Sending START request to MANAGER ...
EXTRACT PP_PTFP starting
GGSCI (nskxt1) 4> start PP_QTFP
Sending START request to MANAGER ...
EXTRACT PP_QTFP starting
GGSCI (nskxt1) 5> start PP_ZYFP
Sending START request to MANAGER ...
EXTRACT PP_ZYFP starting
GGSCI (nskxt1) 6> start EX_DZFP
Sending START request to MANAGER ...
EXTRACT EX_DZFP starting
GGSCI (nskxt1) 7> start EX_PTFP
Sending START request to MANAGER ...
EXTRACT EX_PTFP starting
GGSCI (nskxt1) 8> start EX_QTFP
Sending START request to MANAGER ...
EXTRACT EX_QTFP starting
GGSCI (nskxt1) 9> start EX_ZYFP
Sending START request to MANAGER ...
EXTRACT EX_ZYFP starting
GGSCI (nskxt1) 10> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT STOPPED EX_DZFP 00:00:01 00:04:05
EXTRACT STOPPED EX_PTFP 00:00:01 00:03:43
EXTRACT STOPPED EX_QTFP 00:00:01 00:03:32
EXTRACT STOPPED EX_ZYFP 00:00:02 00:03:18
EXTRACT RUNNING PP_DZFP 00:00:00 00:00:52
EXTRACT RUNNING PP_PTFP 00:00:00 00:00:27
EXTRACT RUNNING PP_QTFP 00:00:00 00:00:16
EXTRACT RUNNING PP_ZYFP 00:00:00 00:00:05
#如果直接啟動OGG不行，在試指定關閉歸檔時間來啟動
GGSCI (nskxt1) 11>alter extract EX_DZFP,tranlog,begin 2019-12-06 19:10:01
GGSCI (nskxt1) 12>alter extract EX_PTFP,tranlog,begin 2019-12-06 19:10:01
GGSCI (nskxt1) 13>alter extract EX_QTFP,tranlog,begin 2019-12-06 19:10:01
GGSCI (nskxt1) 14>alter extract EX_ZYFP,tranlog,begin 2019-12-06 19:10:01
#發現有部份程式不能啟動
GGSCI (nskxt1) 15> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT STOPPED EX_DZFP 00:00:01 00:04:05
EXTRACT STOPPED EX_PTFP 00:00:01 00:03:43
EXTRACT STOPPED EX_QTFP 00:00:01 00:03:32
EXTRACT STOPPED EX_ZYFP 00:00:02 00:03:18
EXTRACT RUNNING PP_DZFP 00:00:00 00:00:52
EXTRACT RUNNING PP_PTFP 00:00:00 00:00:27
EXTRACT RUNNING PP_QTFP 00:00:00 00:00:16
EXTRACT RUNNING PP_ZYFP 00:00:00 00:00:05
#=================執行啟動日誌檢視================
GGSCI (nskxt1) 16> view report EX_PTFP
....
2019-12-06 20:41:55 ERROR OGG-00446 Opening file +Fra/2_2519_1014763310.dbf inDBLOGREADER ..
ORA-17503:ksfdopn:2 Failed to open file +FRA/2_2519_1014763310.dbf
ORA-15173:entry '2_2519_1014763310.dbf' does not exist in directory '/'
....
#日誌中有以上錯誤資訊，進入ASM檢視2_2519_1014763310.dbf歸檔日誌是否存在。
GGSCI (nskxt1) 17>exit
nskxt1:/ogg/ogg12c$su - grid
grid's Password:
nskxt1:/home/grid$asmcmd
ASMCMD> ls
CRS/
DATA/
FRA/
OGG/
ASMCMD> cd fra
ASMCMD> ls
NSKXT/
ASMCMD> cd nskxt
ASMCMD> ls
ARCHIVELOG/
ONLINELOG/
ASMCMD> cd ARCHIVELOG
ASMCMD> ls
2019_11_30/
2019_12_01/
2019_12_02/
2019_12_03/
2019_12_04/
2019_12_05/
2019_12_06/
ASMCMD> cd 2019_12_06
ASMCMD> ls -l
...
ARCHIVELOG UNPROT COARSE DEC 06 21:00:00 Y thread_2_seq_2516.562.1026325513
ARCHIVELOG UNPROT COARSE DEC 06 21:00:00 Y thread_2_seq_2517.859.1026325771
ARCHIVELOG UNPROT COARSE DEC 06 21:00:00 Y thread_2_seq_2518.299.1026326019
ARCHIVELOG UNPROT COARSE DEC 06 21:00:00 Y thread_2_seq_2521.1565.1026329405
ARCHIVELOG UNPROT COARSE DEC 06 21:00:00 Y thread_2_seq_2522.1627.1026329407
ARCHIVELOG UNPROT COARSE DEC 06 21:00:00 Y thread_2_seq_2523.966.1026334027
ARCHIVELOG UNPROT COARSE DEC 06 22:00:00 Y thread_2_seq_2524.329.1026334807
...
#=======2518後直接到2521了，懷疑2519、2520歸檔日誌進入黑洞，試著使用thread_2_seq_2521.1565.1026329405的時間DEC 06 21:00:00來啟動OGG
ASMCMD> exit
nskxt1:/ogg/ogg12c$su - grid
GGSCI (nskxt1) 1>alter extract EX_DZFP,tranlog,begin 2019-12-06 21:00:00
GGSCI (nskxt1) 2>alter extract EX_PTFP,tranlog,begin 2019-12-06 21:00:00
GGSCI (nskxt1) 3>alter extract EX_QTFP,tranlog,begin 2019-12-06 21:00:00
GGSCI (nskxt1) 4>alter extract EX_ZYFP,tranlog,begin 2019-12-06 21:00:00
#=====只啟動捕獲程式，投遞程式直接start PP_DZFP...
#=====持續檢視info all，所有OGG程式正常
GGSCI (nskxt1) 10> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EX_DZFP 00:00:01 00:04:05
EXTRACT RUNNING EX_PTFP 00:00:01 00:03:43
EXTRACT RUNNING EX_QTFP 00:00:01 00:03:32
EXTRACT RUNNING EX_ZYFP 00:00:02 00:03:18
EXTRACT RUNNING PP_DZFP 00:00:00 00:00:52
EXTRACT RUNNING PP_PTFP 00:00:00 00:00:27
EXTRACT RUNNING PP_QTFP 00:00:00 00:00:16
EXTRACT RUNNING PP_ZYFP 00:00:00 00:00:05
GGSCI (nskxt1) 18> exit
#=====開啟應用應用程式
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/15727272/viewspace-2667475/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- Oracle+Ogg 歸檔丟失 重新導資料建立ogg同步步驟Oracle
- OGG整合抽取模式丟失歸檔處理模式
- sock鎖檔案導致的MySQL啟動失敗MySql
- ORACLE OGG引數修改引起佇列檔案異常導致抽取程式無法啟動Oracle佇列
- Oracle DataGuard歸檔日誌丟失處理方法Oracle
- u盤啟動修復Win10引導檔案丟失的方法Win10
- 【BBED】丟失歸檔檔案情況下的恢復
- Oracle dg歸檔同步失敗Oracle
- ORACLE for windows 審計檔案xml檔案過多導致資料庫啟動報錯ORA-09925OracleWindowsXML資料庫
- 咦？Oracle歸檔檔案存哪了？Oracle
- 19c RAC因profile.xml檔案丟失節點1啟動失敗XML
- Oracle資料庫分割槽表SPLIT操作導致歸檔瘋漲Oracle資料庫
- 檔案丟失不用怕：超實用的Mac資料恢復軟體！Mac資料恢復
- oracle歸檔Oracle
- dg丟失歸檔，使用rman增量備份恢復
- 【伺服器資料恢復】異常斷電導致虛擬機器檔案丟失不能啟動的資料恢復案例伺服器資料恢復虛擬機
- ORACLE DATAGUARD災備歸檔空間滿導致的ORA-00600 [2619]Oracle
- oracle 11g開啟歸檔模式及修改歸檔目錄Oracle模式
- Win10系統KB4549951導致個人檔案丟失BUG的解決辦法Win10
- 伺服器不能啟動，修復後部分檔案丟失怎麼解決伺服器
- oracle控制檔案的損壞或完全丟失的恢復辦法Oracle
- ORACLE NBU調取oracle rman指令碼備份歸檔不自動刪除歸檔Oracle指令碼
- 電腦檔案丟失資料恢復資料恢復
- Win10系統如何找回丟失的檔案“開啟方式”Win10
- Oracle undo 表空間資料檔案丟失強制啟動資料庫（沒有未提交的事務）Oracle資料庫
- win10桌面檔案丟失怎麼辦_win10開機桌面檔案丟失如何找回Win10
- 新建的表空間(或資料檔案)丟失以及控制檔案丟失，有新建表空間(或資料檔案)前的控制文
- 一次意外斷電導致mysql檔案損壞，啟動異常MySql
- Oracle使用備份檔案集恢復歸檔日誌Oracle
- Oracle RAC 11gR2開啟歸檔Oracle
- 丟失的隨身碟檔案如何恢復？
- oracle歸檔日誌Oracle
- Nginx轉發導致請求頭丟失Nginx
- 剪下的檔案還能恢復嗎，恢復剪貼丟失的檔案
- 如何輕鬆歸檔檔案？2種方法輕鬆建立歸檔檔案！
- 在Oracle中，如何定時刪除歸檔日誌檔案？Oracle
- 救援丟失的Docx和Xlsx檔案的最佳方法
- 歸檔oracle alert日誌Oracle