GoldenGate的基本操作

1.查看帮助

 help, help add exttrail

 

2.显示当前的GoldenGate环境信息

 show

 

3.查看运行状态

  info all, info mgr, info extract einikk

 

4.启动和停止服务

  start mgr,stop mgr

  start extract einikk,stop extract einikk

  start replicat rinikk,stop replicat rinikk

 

   如果不能停止的话,

   killi extract einikk

 

5.历史命令

  history

 

6.使用OBEY（自动运行一个文件）

  1. Create and save a text file that contains the commands, one command per line. This is
your OBEY file. Name it what you want.
2. In GGSCI, call the OBEY file by using the following syntax.
OBEY <file name>


gdora@testdb11 ggs]$ cat /home/gdora/ggs/yzhq.txt
status manager
status mgr
[gdora@testdb11 ggs]$


GGSCI (testdb11.zhyhl.com) 1> obey yzhq.txt

GGSCI (testdb11.zhyhl.com) 2> status manager


Manager is running (IP port testdb11.zhyhl.com.7809).


GGSCI (testdb11.zhyhl.com) 3> status mgr


Manager is running (IP port testdb11.zhyhl.com.7809).


GGSCI (testdb11.zhyhl.com) 4>

 

  7.使用shell脚本
   Using UNIX batch and shell scripts
On a UNIX system, you can issue GoldenGate commands from a script such as a startup
script, shutdown script, or failover script by running GGSCI and calling an input file. Use
the following syntax:

ggsci < <input_file>


[gdora@testdb11 ggs]$ ggsci < yzhq.txt

GoldenGate Command Interpreter for Oracle
Version 10.4.0.12 Build 001
Linux, x86, 32bit (optimized), Oracle 10 on Aug 21 2009 14:34:04

Copyright (C) GoldenGate Software, Inc. 1995-2009.
The GoldenGate software may include other code written by third parties;
details regarding such third party code, including applicable copyright,
legal and licensing notices are available at http://support.goldengate.com.



GGSCI (testdb11.zhyhl.com) 1>
Manager is running (IP port testdb11.zhyhl.com.7809).


GGSCI (testdb11.zhyhl.com) 2>
Manager is running (IP port testdb11.zhyhl.com.7809).


GGSCI (testdb11.zhyhl.com) 3> [gdora@testdb11 ggs]$
[gdora@testdb11 ggs]$

 

8.修改参数文件

  edit params <group name>

 

9.参数文件存放的目录

  Storing parameter files<完整路径>

 

10.参数的使用规则和注释

   ---注释

 

11.参数文件内的语法

   <PARAMETER> <argument> [, <option>] [&]
 

12.查看参数文件的内容

  view params mgr

 

13.查看报告

  view report einikk

 

14.查看操作的统计信息

  STATS {EXTRACT | REPLICAT} <group>

  stats er*

 

15.info er*

 

16.查看GoldenGate的错误日志内容

  VIEW GGSEVT Contents

 

17. Deleting a process group

  delete einikk