Oracle归档文件丢失导致OGG不用启动

发布时间：2020-08-09 20:05:21 来源：ITPUB博客阅读：344 作者：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