GG常用命令

[ HISTORY, SHELL, !, VERSIONS, OBEY, HELP ]
GGSCI (node1) 2> show all
 
Parameter settings:
 
SET SUBDIRS    ON
SET DEBUG      OFF
 
Current directory: /home/oracle/ogg9
 
Using subdirectories for all process files
 
Editor:  vi
 
Reports (.rpt)                 /home/oracle/ogg9/dirrpt
Parameters (.prm)              /home/oracle/ogg9/dirprm
Stdout (.out)                  /home/oracle/ogg9/dirout
Replicat Checkpoints (.cpr)    /home/oracle/ogg9/dirchk
Extract Checkpoints (.cpe)     /home/oracle/ogg9/dirchk
Process Status (.pcs)          /home/oracle/ogg9/dirpcs
SQL Scripts (.sql)             /home/oracle/ogg9/dirsql
Database Definitions (.def)    /home/oracle/ogg9/dirdef
 
 
GGSCI (node1) 3> history    
 
GGSCI Command History
 
    1: info all
    2: show all
    3: history
 
 
GGSCI (node1) 4> dblogin userid goldengate, password goldengate
Successfully logged into database.
 
GGSCI (node1) 5> versions
Operating System:
Linux
Version #1 SMP Mon Apr 20 10:34:33 EDT 2009, Release 2.6.9-89.ELsmp
Node: node1
Machine: i686
 
Database:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Prod
PL/SQL Release 10.2.0.4.0 - Production
CORE    10.2.0.4.0      Production
TNS for Linux: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production
 
GGSCI (node1) 6> !
versions
Operating System:
Linux
Version #1 SMP Mon Apr 20 10:34:33 EDT 2009, Release 2.6.9-89.ELsmp
Node: node1
Machine: i686
 
Database:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Prod
PL/SQL Release 10.2.0.4.0 - Production
CORE    10.2.0.4.0      Production
TNS for Linux: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production
 
GGSCI (node1) 7> shell pwd
 
/home/oracle/ogg9
 
 
GGSCI (node1) 8> help
 
GGSCI Command    Summary
SUBDIRS          CREATE SUBDIRS
ER               INFO ER, KILL ER, LAG ER, SEND ER, STATUS ER,
                 START ER, STATS ER, STOP ER
EXTRACT          ADD, ALTER, CLEANUP, DELETE, INFO, KILL,
                 LAG, SEND, START, STATS, STATUS, STOP
EXTTRAIL         ADD, ALTER, DELETE, INFO
GGSEVT           VIEW
MANAGER          INFO, REFRESH, SEND, START, STOP, STATUS
MARKER           INFO
PARAMS           EDIT, VIEW
REPLICAT         ADD, ALTER, CLEANUP, DELETE, INFO, KILL,
                 LAG, SEND, START, STATS, STATUS, STOP
REPORT           VIEW
RMTTRAIL         ADD, ALTER, DELETE, INFO
TRACETABLE       ADD, DELETE, INFO
TRANDATA         ADD, DELETE, INFO
Database         DBLOGIN, LIST TABLES,
                 ENCRYPT PASSWORD
DDL              DUMPDDL
CHECKPOINTTABLE  ADD CHECKPOINTTABLE, DELETE CHECKPOINTTABLE,
                 CLEANUP CHECKPOINTTABLE, INFO CHECKPOINTTABLE
Miscellaneous    FC, HELP, HISTORY, INFO ALL, INFO MARKER, OBEY, 
                 SET, SHELL, SHOW, VERSIONS, !
             
 
 
For help on a specific command, type HELP <command> <object>.
 
Example: HELP ADD REPLICAT
 
GGSCI (node1) 9>

[oracle@node1 ~]$ cat test.sh
cd /home/oracle/ogg9
./ggsci << EOF
OBEY /home/oracle/test.txt
EOF
[oracle@node1 ~]$ cat test.txt
show all
[oracle@node1 ~]$ ./test.sh
 
Oracle GoldenGate Command Interpreter for Oracle
Version 10.4.0.19 Build 002
Linux, x86, 32bit (optimized), Oracle 10 on Sep 17 2009 23:49:42
 
Copyright (C) 1995, 2009, Oracle and/or its affiliates.  All rights reserved.
 
 
 
GGSCI (node1) 1>
GGSCI (node1) 2> show all
 
 
Parameter settings:
 
SET SUBDIRS    ON
SET DEBUG      OFF
 
Current directory: /home/oracle/ogg9
 
Using subdirectories for all process files
 
Editor:  vi
 
Reports (.rpt)                 /home/oracle/ogg9/dirrpt
Parameters (.prm)              /home/oracle/ogg9/dirprm
Stdout (.out)                  /home/oracle/ogg9/dirout
Replicat Checkpoints (.cpr)    /home/oracle/ogg9/dirchk
Extract Checkpoints (.cpe)     /home/oracle/ogg9/dirchk
Process Status (.pcs)          /home/oracle/ogg9/dirpcs
SQL Scripts (.sql)             /home/oracle/ogg9/dirsql
Database Definitions (.def)    /home/oracle/ogg9/dirdef
 
 
GGSCI (node1) 3> ERROR: Invalid command.