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
- TSM備份時因歸檔日誌丟失而導致備份失敗
- 非歸檔丟失日誌檔案的恢復
- 電腦突然斷電導致檔案丟失怎麼辦？
- 磁碟損壞導致資料檔案丟失的恢復
- ORACLE OGG引數修改引起佇列檔案異常導致抽取程式無法啟動Oracle佇列
- rman 恢復---歸檔丟失and資料檔案損壞
- 歸檔模式下資料檔案丟失的恢復模式
- DG 主庫丟失歸檔
- oracle rac歸檔使用nfs 導致oracle hungOracleNFS
- 誤刪歸檔日誌除導致備份歸檔日誌失敗
- u盤啟動修復Win10引導檔案丟失的方法Win10
- Oracle DataGuard歸檔日誌丟失處理方法Oracle
- Oracle_dg歸檔丟失問題處理Oracle
- Oracle 10g DG 主庫丟失歸檔Oracle 10g
- 歸檔模式下丟失普通資料檔案並恢復模式
- 在歸檔模式下丟失日誌檔案的恢復模式
- ORA-25153: Temporary Tablespace is Empty 重建控制檔案導致丟失tempfile
- OGG-00685 goldengate 啟動報錯 (日誌沒有切換形成歸檔導致)Go
- 歸檔問題導致的資料庫無法啟動資料庫
- 如何解決路由器啟動配置檔案丟失路由器
- Oracle Password檔案丟失的恢復Oracle
- dataguard 由於主庫引數未配置歸檔刪除策略導致庫歸檔丟失ORA-16016
- 丟失已歸檔日誌檔案下恢復資料庫資料庫
- 非歸檔下日誌檔案丟失的處理辦法
- 歸檔模式下的日誌檔案丟失的解決方法模式
- 非歸檔無備份下控制檔案丟失的恢復
- 歸檔模式無備份丟失資料檔案後恢復模式
- 歸檔模式有備份丟失資料檔案後恢復模式
- oracle歸檔日誌滿了，導致無法啟動 ORA-03113Oracle
- 恢復案例：無歸檔，丟失全部控制檔案、日誌檔案恢復案例
- 開啟 控制檔案自動備份下，引數檔案、控制檔案全部丟失恢復
- 一次密碼檔案丟失導致的dataguard複製中斷密碼
- OGG-01028 和ORA-00308: 開啟歸檔檔案失敗
- /tmp檔案系統無許可權導致監聽listener啟動失敗
- 找回丟失的檔案