ogg版本:12.3.0.1
1.停掉主库的相关进程
GGSCI (rac01 as goldengate@slnngk1) 30> stop dpep
Sending STOP request to EXTRACT DPEP ...
Request processed.
GGSCI (rac01 as goldengate@slnngk1) 31> stop extep
Sending STOP request to EXTRACT EXTEP ...
Request processed.
GGSCI (rac01 as goldengate@slnngk1) 32> 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.
2.查看当前投递pump进程的信息
GGSCI (rac01 as goldengate@slnngk1) 33> info dpep
EXTRACT DPEP Last Started 2021-07-01 10:16 Status STOPPED
Checkpoint Lag 00:00:00 (updated 00:01:05 ago)
Log Read Checkpoint File /goldengate12c/dirdat/ep000000000
2021-07-01 10:38:04.000000 RBA 1168285
3.目录迁移
[root@rac01 /]# mv goldengate12c goldengate12c_bak
4.启动相关进程
进入到迁移后的目录启动相关的进程
GGSCI (rac01) 2> start mgr
Manager started.
GGSCI (rac01) 3> start dpep
Sending START request to MANAGER ...
EXTRACT DPEP starting
GGSCI (rac01) 4> start extep
Sending START request to MANAGER ...
EXTRACT EXTEP starting
GGSCI (rac01) 5> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT ABENDED DPEP 00:00:00 00:00:09
EXTRACT RUNNING EXTEP 00:00:06 00:00:00
这个时候dpep无法启动,原因如下:
2021-07-01 10:47:11 ERROR OGG-01091 Unable to open file "/goldengate12c/dirdat/ep000000000" (error 2, No such file or directory).
这个时候投递进程pump记录的还是原来的目录信息
5.修改投递进程的参数信息
ALTER EXTRACT dpep, EXTSEQNO 0, EXTRBA 1168285,EXTTRAILSOURCE ./dirdat/ep
GGSCI (rac01) 11> info dpep
EXTRACT DPEP Initialized 2021-07-01 10:50 Status STOPPED
Checkpoint Lag 00:00:00 (updated 00:00:06 ago)
Log Read Checkpoint File ./dirdat/ep000000000
First Record RBA 1168285
重新启动
GGSCI (rac01) 12> start dpep
--The End --