首页 > 代码库 > 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