SomeUsefulGoldenGateCommands

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:

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