goldengate针对目的端数据库启停的操作

最新推荐文章于 2021-05-07 18:26:49 发布

一卒

最新推荐文章于 2021-05-07 18:26:49 发布

阅读量1.1k

点赞数

CC 4.0 BY-SA版权

分类专栏： goldengate 文章标签：数据库 oracle goldengate

本文链接：https://blog.youkuaiyun.com/wxl1314920/article/details/17022091

goldengate 专栏收录该内容

1 篇文章

订阅专栏

本文详细介绍了使用GoldenGate进行目的端数据库数据文件换盘操作的过程，包括检查GoldenGate进程状态、停用GoldenGate服务、恢复目标数据库以及重新启动GoldenGate服务等步骤，并提供了关键检查点和操作细节。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

针对目的端数据库数据文件换盘操作，goldengate操作如下：

GGSCI (mktdb1) 1> info all

Program     Status      Group       Lag           Time Since Chkpt

MANAGER     RUNNING
EXTRACT     RUNNING     DPEMKHC     00:00:02      00:00:08
EXTRACT     RUNNING     EXTMKHC     00:00:00      00:00:06

GGSCI (mktdb1) 2> info EXTMKHC,showch

EXTRACT    EXTMKHC   Last Started 2012-08-31 11:04   Status RUNNING
Checkpoint Lag       00:00:00 (updated 00:00:09 ago)
Log Read Checkpoint Oracle Redo Logs
                     2012-08-31 11:44:13 Seqno 370326, RBA 143012352

Current Checkpoint Detail:

Read Checkpoint #1

Oracle Redo Log

Startup Checkpoint (starting position in the data source):
    Sequence #: 370276
    RBA: 4361744
    Timestamp: 2012-08-31 08:33:54.000000
    Redo File: /oracle/oradata/u2/archive/1_370276_579660705.dbf

Recovery Checkpoint (position of oldest unprocessed transaction in the data source):
    Sequence #: 370325
    RBA: 295927824
    Timestamp: 2012-08-31 11:33:53.000000
    Redo File: Not Avaliable

Current Checkpoint (position of last record read in the data source):
    Sequence #: 370326
    RBA: 143012352
    Timestamp: 2012-08-31 11:44:13.000000
    Redo File: /oracle/oradata1/u1/mktdb/log31.ora

BR Previous Recovery Checkpoint:
    Sequence #: 0
    RBA: 0
    Timestamp: 2012-08-25 00:04:27.049605
    Redo File:

BR Begin Recovery Checkpoint:
    Sequence #: 370261
    RBA: 49396240
    Timestamp: 2012-08-31 07:34:00.000000
    Redo File:

BR End Recovery Checkpoint:
    Sequence #: 370266
    RBA: 198313472
    Timestamp: 2012-08-31 08:08:23.000000
    Redo File:

Write Checkpoint #1

GGS Log Trail

Current Checkpoint (current write position):
    Sequence #: 1552
    RBA: 79045447
    Timestamp: 2012-08-31 11:44:15.321501
    Extract Trail: ./dirdat/hc

Header:
Version = 2
Record Source = A
Type = 4
# Input Checkpoints = 1
# Output Checkpoints = 1

File Information:
Block Size = 2048
Max Blocks = 100
Record Length = 2048
Current Offset = 0

Configuration:
Data Source = 3
Transaction Integrity = 1
Task Type = 0

Status:
Start Time = 2012-08-31 11:04:53
Last Update Time = 2012-08-31 11:44:15
Stop Status = A
Last Result = 400

GGSCI (mktdb1) 3>

查看Recovery Checkpoint 对应的 Sequence #: 370325，然后到归档目录看是否存在序列号为370325的归档，如果有，可以停goldengate，

停goldengate操作顺序如下：

源端：

GGSCI (mktdb1) 4> stop DPEMKHC
GGSCI (mktdb1) 4> stop EXTMKHC

目标端：
GGSCI (localhost.localdomain) 72> stop rep *
GGSCI (localhost.localdomain) 72> stop mgr

目标端数据库起来后，goldengate操作如下：

目标端：
GGSCI (localhost.localdomain) 72> start mgr

源端：
GGSCI (mktdb1) 4> start EXTMKHC
GGSCI (mktdb1) 4> start DPEMKHC

目标端：
GGSCI (localhost.localdomain) 72> start rep *

查看源及目标端进程状态是否正常，如有问题，根据相关问题进行解决。