Oracle歸檔文件丟失導致OGG不用啟動

發布時間：2020-08-09 20:05:21 來源：ITPUB博客閱讀：371 作者：xyzsfy 欄目：關系型數據庫

環境：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.

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