GG常用命令

扫码查看
[ HISTORY, SHELL, !, VERSIONS, OBEY, HELP ]GGSCI (node1) 2> show all Parameter settings: SET SUBDIRS    ONSET DEBUG      OFF Current directory: /home/oracle/ogg9 Using subdirectories for all process files Editor:  vi Reports (.rpt)                 /home/oracle/ogg9/dirrptParameters (.prm)              /home/oracle/ogg9/dirprmStdout (.out)                  /home/oracle/ogg9/diroutReplicat Checkpoints (.cpr)    /home/oracle/ogg9/dirchkExtract Checkpoints (.cpe)     /home/oracle/ogg9/dirchkProcess Status (.pcs)          /home/oracle/ogg9/dirpcsSQL Scripts (.sql)             /home/oracle/ogg9/dirsqlDatabase 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 goldengateSuccessfully logged into database. GGSCI (node1) 5> versionsOperating System:LinuxVersion #1 SMP Mon Apr 20 10:34:33 EDT 2009, Release 2.6.9-89.ELsmpNode: node1Machine: i686 Database:Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - ProdPL/SQL Release 10.2.0.4.0 - ProductionCORE    10.2.0.4.0      ProductionTNS for Linux: Version 10.2.0.4.0 - ProductionNLSRTL Version 10.2.0.4.0 - Production GGSCI (node1) 6> !versionsOperating System:LinuxVersion #1 SMP Mon Apr 20 10:34:33 EDT 2009, Release 2.6.9-89.ELsmpNode: node1Machine: i686 Database:Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - ProdPL/SQL Release 10.2.0.4.0 - ProductionCORE    10.2.0.4.0      ProductionTNS for Linux: Version 10.2.0.4.0 - ProductionNLSRTL Version 10.2.0.4.0 - Production GGSCI (node1) 7> shell pwd /home/oracle/ogg9  GGSCI (node1) 8> help GGSCI Command    SummarySUBDIRS          CREATE SUBDIRSER               INFO ER, KILL ER, LAG ER, SEND ER, STATUS ER,                  START ER, STATS ER, STOP EREXTRACT          ADD, ALTER, CLEANUP, DELETE, INFO, KILL,                 LAG, SEND, START, STATS, STATUS, STOPEXTTRAIL         ADD, ALTER, DELETE, INFOGGSEVT           VIEWMANAGER          INFO, REFRESH, SEND, START, STOP, STATUSMARKER           INFOPARAMS           EDIT, VIEWREPLICAT         ADD, ALTER, CLEANUP, DELETE, INFO, KILL,                 LAG, SEND, START, STATS, STATUS, STOPREPORT           VIEWRMTTRAIL         ADD, ALTER, DELETE, INFOTRACETABLE       ADD, DELETE, INFOTRANDATA         ADD, DELETE, INFODatabase         DBLOGIN, LIST TABLES,                  ENCRYPT PASSWORDDDL              DUMPDDLCHECKPOINTTABLE  ADD CHECKPOINTTABLE, DELETE CHECKPOINTTABLE,                  CLEANUP CHECKPOINTTABLE, INFO CHECKPOINTTABLEMiscellaneous    FC, HELP, HISTORY, INFO ALL, INFO MARKER, OBEY,                   SET, SHELL, SHOW, VERSIONS, !                 For help on a specific command, type HELP . Example: HELP ADD REPLICAT GGSCI (node1) 9> [oracle@node1 ~]$ cat test.shcd /home/oracle/ogg9./ggsci OBEY /home/oracle/test.txtEOF [oracle@node1 ~]$ cat test.txtshow all[oracle@node1 ~]$ ./test.sh Oracle GoldenGate Command Interpreter for OracleVersion 10.4.0.19 Build 002Linux, 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    ONSET DEBUG      OFF Current directory: /home/oracle/ogg9 Using subdirectories for all process files Editor:  vi Reports (.rpt)                 /home/oracle/ogg9/dirrptParameters (.prm)              /home/oracle/ogg9/dirprmStdout (.out)                  /home/oracle/ogg9/diroutReplicat Checkpoints (.cpr)    /home/oracle/ogg9/dirchkExtract Checkpoints (.cpe)     /home/oracle/ogg9/dirchkProcess Status (.pcs)          /home/oracle/ogg9/dirpcsSQL Scripts (.sql)             /home/oracle/ogg9/dirsqlDatabase Definitions (.def)    /home/oracle/ogg9/dirdef  GGSCI (node1) 3> ERROR: Invalid command.
01-11 21:57
查看更多