oracle ogg重启,ogg启动步骤

最新推荐文章于 2025-03-17 15:49:00 发布

转载最新推荐文章于 2025-03-17 15:49:00 发布 · 2.6k 阅读

文章标签：

本文详细记录了Oracle GoldenGate的重启和启动过程，包括管理进程、抽取进程和复制进程的操作步骤，以及查看进程状态的方法。通过 GGSCI 命令行工具，成功启动了MGR、EXTRACT EORA_1、EXTRACT PORA_1 和 REPLICAT RORA_1，并展示了相关信息，确保数据同步服务正常运行。

[oracle@node1 ~]$ ggsci

GGSCI (node1) 1> start mgr

Cannot load ICU resource bundle 'ggMessage', error code 2 - No such file or directory

Aborted

[oracle@node1 ~]$ cd /u01/app/ogg

[oracle@node1 ogg]$ ./ggsci

启动管理进程

GGSCI (node1) 1> start mgr

Manager started.

启动抽取进程

GGSCI (node1) 2> START EXTRACT EORA_1

Sending START request to MANAGER ...

EXTRACT EORA_1 starting

GGSCI (node1) 3> info EORA_1

EXTRACT EORA_1 Last Started 2013-11-24 13:55 Status RUNNING

Checkpoint Lag 44:21:15 (updated 00:00:05 ago)

Log Read Checkpoint Oracle Redo Logs

2013-11-22 17:34:04 Seqno 11, RBA 7563264

SCN 0.928345 (928345)

启动队列进程

GGSCI (node1) 4> start EXTRACT PORA_1

Sending START request to MANAGER ...

EXTRACT PORA_1 starting

GGSCI (node1) 5> info pora_1

EXTRACT PORA_1 Last Started 2013-11-24 13:55 Status RUNNING

Checkpoint Lag 00:00:00 (updated 44:20:38 ago)

Log Read Checkpoint File ./dirdat/aa000001

2013-11-22 16:58:54.000000 RBA 1547

目标库

GGSCI (node3) 2> start mgr

Manager started.

GGSCI (node3) 3> info rora_1

REPLICAT RORA_1 Last Started 2013-11-22 16:55 Status ABENDED

Checkpoint Lag 00:00:00 (updated 44:22:36 ago)

Log Read Checkpoint File ./dirdat/pa000001

2013-11-22 16:58:52.795670 RBA 1668

GGSCI (node3) 4> start REPLICAT RORA_1

Sending START request to MANAGER ...

REPLICAT RORA_1 starting

GGSCI (node3) 5> info rora_1

REPLICAT RORA_1 Last Started 2013-11-24 13:56 Status RUNNING

Checkpoint Lag 00:00:00 (updated 00:00:03 ago)

Log Read Checkpoint File ./dirdat/pa000002

2013-11-24 13:55:18.310253 RBA 1205

资源库

2013-11-24 13:53:23 INFO OGG-00983 Oracle GoldenGate Manager for Oracle, mgr.prm: Manager started (port 7809).

2013-11-24 13:55:18 INFO OGG-00992 Oracle GoldenGate Capture for Oracle, eora_1.prm: EXTRACT EORA_1 starting.

2013-11-24 13:55:36 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: EXTRACT PORA_1 starting.

2013-11-24 13:55:36 INFO OGG-00992 Oracle GoldenGate Capture for Oracle, pora_1.prm: EXTRACT PORA_1 starting.

目标库

2013-11-24 13:56:46 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: REPLICAT RORA_1 starting.

2013-11-24 13:56:47 INFO OGG-00995 Oracle GoldenGate Delivery for Oracle, rora_1.prm: REPLICAT RORA_1 starting.

2013-11-24 13:56:12 INFO OGG-00983 Oracle GoldenGate Manager for Oracle, mgr.prm: Manager started (port 7809).

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29108064/viewspace-777435/，如需转载，请注明出处，否则将追究法律责任。