首页 > 代码库 > Some Useful GoldenGate Commands

Some Useful GoldenGate Commands

1、History

使用History可以查看以前执行的命令

GGSCI (ogg1) 5> history

GGSCI Command History

    1: infoa 
    2: inf
    3: info all
    4: show all
    5: history

2、!

使用!可以再次执行上次执行的命令

GGSCI (ogg1) 6> !
history

GGSCI Command History

    1: infoa 
    2: inf
    3: info all
    4: show all
    5: history
    6: history

 

3、Shell

使用shell可以在ggsci中运行shell命令

GGSCI (ogg1) 7> shell ls -l

total 513792
-rw-r—– 1 oracle oinstall       426 Oct 15  2010 bcpfmt.tpl
-rw-r—– 1 oracle oinstall      1725 Oct 15  2010 bcrypt.txt
drwxrwxr-x 3 oracle oinstall      4096 Aug 25 04:54 BR
drwxr-x— 2 oracle oinstall      4096 Apr 23  2012 cfg
-rw-r—– 1 oracle oinstall      1285 Feb 28  2012 chkpt_ora_create.sql
-rwxr-x— 1 oracle oinstall   5812198 Apr 23  2012 cobgen
-rwxr-x— 1 oracle oinstall   5527157 Apr 23  2012 convchk
-rw-r—– 1 oracle oinstall       159 Oct 15  2010 db2cntl.tpl
-rw-r—– 1 oracle oinstall      1059 Oct 15  2010 ddl_cleartrace.sql
-rwxr-x— 1 oracle oinstall   6110739 Apr 23  2012 ddlcob
-rw-r—– 1 oracle oinstall      4189 Oct 15  2010 ddl_ddl2file.sql

 

 

4、help

使用help获得帮助

GGSCI (ogg1) 8> help

 
GGSCI Command Summary: 
 
Object:          Command: 
SUBDIRS          CREATE 
ER               INFO, KILL, LAG, SEND, STATUS, START, STATS, STOP 
EXTRACT          ADD, ALTER, CLEANUP, DELETE, INFO, KILL, 
                 LAG, REGISTER, SEND, START, STATS, STATUS, STOP 
                 UNREGISTER 
EXTTRAIL         ADD, ALTER, DELETE, INFO 
GGSEVT           VIEW 
MANAGER          INFO, 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 
SCHEMATRANDATA   ADD, DELETE, INFO 
CHECKPOINTTABLE  ADD, DELETE, CLEANUP, INFO 
 
Commands without an object: 
(Database)       DBLOGIN, LIST TABLES, ENCRYPT PASSWORD, FLUSH SEQUENCE 
                 MININGDBLOGIN 
(DDL)            DUMPDDL 
(Miscellaneous)  FC, HELP, HISTORY, INFO ALL, OBEY, SET EDITOR, SHELL,  
                 SHOW, VERSIONS, ! (note: you must type the word 
                 COMMAND after the ! to display the ! help topic.) 
                 i.e.: GGSCI (sys1)> help ! command 
               

 

For help on a specific command, type HELP <command> <object>.

Example: HELP ADD REPLICAT

GGSCI (ogg1) 9> 


    Some Useful GoldenGate Commands