在Oracle中,OGG的命令接口是哪个?
♣ 答案部分
对OGG进行交互的命令为GGSCI(GoldenGate Software Command Interface),GGSCI提供了十分丰富的命令来对OGG进行各种操作,如创建、修改、监控OGG进程等等,如下所示:
1[oracle@rhel6lhr gg11]$ ggsci 2Oracle GoldenGate Command Interpreter for Oracle 3Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBO 4Linux, x64, 64bit (optimized), Oracle 11g on Apr 23 2012 08:32:14 5Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved. 6GGSCI (rhel6lhr) 1> info all 7Program Status Group Lag at Chkpt Time Since Chkpt 8MANAGER RUNNING 9EXTRACT ABENDED EORA_HR2 00:00:00 17138:30:00 10EXTRACT ABENDED PORA_HR2 00:00:00 17138:30:00 11REPLICAT ABENDED RORA_HR 00:00:00 17138:29:57