Oracle GoldenGate的常用命令
<p><strong><span style="font-size: small;">1.查看帮助</span></strong></p>
<p> help, help add exttrail</p>
<p><strong><span style="font-size: small;">2.显示当前的GoldenGate环境信息</span></strong></p>
<p> show</p>
<p><strong><span style="font-size: small;">3.查看运行状态</span></strong></p>
<p> info all, info mgr, info extract einikk</p>
<p><strong><span style="font-size: small;"> </span></strong></p>
<p><strong><span style="font-size: small;">4.启动和停止服务</span></strong></p>
<p> start mgr,stop mgr</p>
<p> start extract einikk,stop extract einikk</p>
<p> start replicat rinikk,stop replicat rinikk</p>
<p> 如果不能停止的话,</p>
<p> killi extract einikk</p>
<p><strong><span style="font-size: small;">5.历史命令</span></strong></p>
<p> history</p>
<p><strong><span style="font-size: small;">6.使用OBEY(自动运行一个文件)</span></strong></p>
<p> 1. Create and save a text file that contains the commands, one command per line. This is<br>your OBEY file. Name it what you want.<br>2. In GGSCI, call the OBEY file by using the following syntax.<br>OBEY <file name><br><br><br>gdora@testdb11 ggs]$ cat /home/gdora/ggs/yzhq.txt <br>status manager<br>status mgr<br>$ <br><br><br>GGSCI (testdb11.zhyhl.com) 1> obey yzhq.txt<br><br>GGSCI (testdb11.zhyhl.com) 2> status manager<br><br><br>Manager is running (IP port testdb11.zhyhl.com.7809).<br><br><br>GGSCI (testdb11.zhyhl.com) 3> status mgr<br><br><br>Manager is running (IP port testdb11.zhyhl.com.7809).<br><br><br>GGSCI (testdb11.zhyhl.com) 4></p>
<p><strong><span style="font-size: small;"> 7.使用shell脚本</span></strong><br> Using UNIX batch and shell scripts<br>On a UNIX system, you can issue GoldenGate commands from a script such as a startup<br>script, shutdown script, or failover script by running GGSCI and calling an input file. Use<br>the following syntax:<br><br>ggsci < <input_file><br><br><br>$ ggsci < yzhq.txt <br><br>GoldenGate Command Interpreter for Oracle<br>Version 10.4.0.12 Build 001<br>Linux, x86, 32bit (optimized), Oracle 10 on Aug 21 2009 14:34:04<br><br>Copyright (C) GoldenGate Software, Inc. 1995-2009.<br>The GoldenGate software may include other code written by third parties;<br>details regarding such third party code, including applicable copyright,<br>legal and licensing notices are available at http://support.goldengate.com.<br><br><br><br>GGSCI (testdb11.zhyhl.com) 1> <br>Manager is running (IP port testdb11.zhyhl.com.7809).<br><br><br>GGSCI (testdb11.zhyhl.com) 2> <br>Manager is running (IP port testdb11.zhyhl.com.7809).<br><br><br>GGSCI (testdb11.zhyhl.com) 3> $ <br>$ </p>
<p><strong><span style="font-size: small;">8.修改参数文件</span></strong></p>
<p> edit params <group name></p>
<p><strong><span style="font-size: small;">9.参数文件存放的目录</span></strong></p>
<p> Storing parameter files<完整路径></p>
<p><strong><span style="font-size: small;">10.参数的使用规则和注释</span></strong></p>
<p> ---注释</p>
<p><strong><span style="font-size: small;">11.参数文件内的语法</span></strong></p>
<p> <PARAMETER> <argument> [, <option>] [&]<br> </p>
<p><strong><span style="font-size: small;">12.查看参数文件的内容</span></strong></p>
<p> view params mgr</p>
<p><strong><span style="font-size: small;">13.查看报告</span></strong></p>
<p> view report einikk</p>
<p><strong><span style="font-size: small;">14.查看操作的统计信息</span></strong></p>
<p> STATS {EXTRACT | REPLICAT} <group></p>
<p> stats er*</p>
<p><strong><span style="font-size: small;">15.info er*</span></strong></p>
<p><span style="font-size: small;"><strong> </strong></span></p>
<p><strong><span style="font-size: small;">16.查看GoldenGate的错误日志内容</span></strong></p>
<p> VIEW GGSEVT Contents</p>
<p><strong><span style="font-size: small;">17. Deleting a process group</span></strong></p>
<p> delete einikk</p>
回复 1# maoj2008
Oracle GoldenGate的常用命令的介绍很好。我知道了很多。特别感谢!!!!!!!!!!{:2_179:}
页:
[1]