goldengate从库目录迁移

1.停掉从库的ogg相应的进程
GGSCI (ora11g) 46> stop repep

Sending STOP request to REPLICAT REPEP ...
Request processed.

GGSCI (ora11g) 47> 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 (ora11g) 48>

 

 

2.记录下seqno号和rba号
GGSCI (ora11g) 48> info repep

REPLICAT REPEP Last Started 2021-07-01 10:32 Status STOPPED
Checkpoint Lag 00:00:00 (updated 00:00:42 ago)
Log Read Checkpoint File /goldengate12c/dirdat/ep000000002
2021-07-01 11:09:03.037852 RBA 1553080

 

3.迁移目录
[root@ora11g /]# mv goldengate12c goldengate12c_bak

4.启动相关的进程
GGSCI (ora11g) 2> start mgr
Manager started.

GGSCI (ora11g) 3> start repep

Sending START request to MANAGER ...
REPLICAT REPEP starting
GGSCI (ora11g) 4> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING
REPLICAT ABENDED REPEP 00:00:00 00:02:19

复制进程无法启动,原因是找不到迁移后的文件,这个时候复制进程记录的还是原来的路径信息

2021-07-01 11:18:20 ERROR OGG-01091 Unable to open file "/goldengate12c/dirdat/ep000000002" (error 2, No such file or directory).

 

5.修改复制进程
alter repep, extseqno 2, extrba 1553080,exttrail ./dirdat/ep

 

6.重新启动
GGSCI (ora11g) 12> start repep

Sending START request to MANAGER ...
REPLICAT REPEP starting

GGSCI (ora11g) 13> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING
REPLICAT RUNNING REPEP 00:00:00 00:00:01

GGSCI (ora11g) 14> info repep

REPLICAT REPEP Last Started 2021-07-01 11:20 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:04 ago)
Process ID 13475
Log Read Checkpoint File /goldengate12c_bak/dirdat/ep000000002
2021-07-01 11:19:29.037930 RBA 1942239