Misc Commands
!
Execute current or history command.
Syntax
! [n | -n | string] n: execute command line n in the command history. -n: execute n lines before the current line. string: execute last command that starts with string.
Examples
! ! 4 ! -9 ! show
CREATE SUBDIRS
Create default directories within GoldenGate home directory.
FC
Edit previous commands before execute.
Syntax
FC [n | -n | string] n: execute command line n in the command history. -n: execute n lines before the current line. string: execute last command that starts with string.
* Command editing:
– Enter fc command
– Position cursor under the character you want to edit
i <text>: insert text r <text>: replace text <replacement text>: you can directly type in replacement text, same as r <text> d: delete character
Examples
GGSCI 48> history
GGSCI Command History
39: help info
40: help add replicat
41: versions
42: VIEW GGSEVT
43: view report
44: view reports
45: view report r_gt.rpt
46: view report R_GT.rpt
47: view report dirrpt/R_GT.rpt
48: history
GGSCI 49> info mgr
Manager is running (IP port wlbox.7809).
GGSCI 50> fc
GGSCI 50> info mgr
GGSCI 50.. all
GGSCI 50> info all
GGSCI 50..
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING E_GT 00:00:00 00:00:01
REPLICAT RUNNING R_GT 00:00:00 00:00:04
GGSCI 51> fc
GGSCI 51> info all
GGSCI 51.. e_gt
GGSCI 51> info e_gt
GGSCI 51..
EXTRACT E_GT Last Started 2012-09-08 07:24 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:05 ago)
Log Read Checkpoint Oracle Redo Logs
2012-09-08 08:11:30 Seqno 188, RBA 3990016
SCN 0.6670083 (6670083)
HELP
Displays command help
Syntax
HELP [cmd]
Examples
GGSCI 40> help add replicat ADD REPLICAT Use ADD REPLICAT to create a Replicat group. Unless SPECIALRUN is specified, ADD REPLICAT creates checkpoints so that processing continuity is maintained from run to run. Before creating a Replicat group, review the Oracle GoldenGate Windows and UNIX Administrator's Guide. This command cannot exceed 500 bytes in size for all keywords and input, including any text that you enter for the DESC option. ...
HISTORY
View command history.
Syntax
HISTORY [n] n: display n number of command history.
Examples
GGSCI 14> history 2 GGSCI Command History 13: history 14: history 2
INFO ALL
Display status and lag of all Manager, Extract, Replicat processes.
Syntax
INFO ALL [TASKS | ALLPROCESSES] TASKS: display tasks only.
Examples
GGSCI 15> info all Program Status Group Lag Time Since Chkpt MANAGER STOPPED EXTRACT STOPPED ODISC 00:00:00 16:33:41 EXTRACT STOPPED ODIT1P 00:00:00 16:33:42 GGSCI 16> info all tasks Program Status Group Lag Time Since Chkpt GGSCI 17> info all all processes Program Status Group Lag Time Since Chkpt MANAGER STOPPED EXTRACT STOPPED ODISC 00:00:00 16:33:56 EXTRACT STOPPED ODIT1P 00:00:00 16:33:56
INFO MARKER
View recently processed markers from a NonStop system.
Syntax
INFO MARKER [COUNT n] COUNT: view most recent n markers.
Examples
GGSCI 18> info marker No markers to display. GGSCI 19> info marker count 2 No markers to display.
OBEY
Execute a command file.
Syntax
OBEY
Examples
OBEY ./mycommands.txt
SHELL
Execute shell commands.
Syntax
SHELL
Examples
SHELL dir
SHOW
Show GoldenGate environment.
Syntax
SHOW
Examples
GGSCI 36> show Parameter settings: SET SUBDIRS ON SET DEBUG OFF Current directory: /u01/Oracle/GoldenGate/gg1121 Using subdirectories for all process files Editor: vi Reports (.rpt) /u01/Oracle/GoldenGate/gg1121/dirrpt Parameters (.prm) /u01/Oracle/GoldenGate/gg1121/dirprm Stdout (.out) /u01/Oracle/GoldenGate/gg1121/dirout Replicat Checkpoints (.cpr) /u01/Oracle/GoldenGate/gg1121/dirchk Extract Checkpoints (.cpe) /u01/Oracle/GoldenGate/gg1121/dirchk Process Status (.pcs) /u01/Oracle/GoldenGate/gg1121/dirpcs SQL Scripts (.sql) /u01/Oracle/GoldenGate/gg1121/dirsql Database Definitions (.def) /u01/Oracle/GoldenGate/gg1121/dirdef
VERSIONS
Show OS and DB versions.
Syntax
VERSIONS
Examples
GGSCI 41> versions Operating System: Linux Version #1 SMP Mon Mar 29 20:06:41 EDT 2010, Release 2.6.18-194.el5 Node: wlbox Machine: i686 Database: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Product PL/SQL Release 10.2.0.1.0 - Production CORE 10.2.0.1.0 Production TNS for Linux: Version 10.2.0.1.0 - Production NLSRTL Version 10.2.0.1.0 - Production
VIEW GGSEVT
View GoldenGate event logs.
Syntax
VIEW GGSEVT
Examples
GGSCI 42> VIEW GGSEVT 2012-09-07 20:21:31 INFO OGG-00987 Oracle GoldenGate Command Interpreter fo r Oracle: GGSCI command (oracle): START MANAGER. 2012-09-07 20:22:16 INFO OGG-00987 Oracle GoldenGate Command Interpreter fo r Oracle: GGSCI command (oracle): EDIT MANAGER MGR. 2012-09-07 20:22:33 INFO OGG-00987 Oracle GoldenGate Command Interpreter fo r Oracle: GGSCI command (oracle): EDIT PARAMS MGR. 2012-09-07 20:22:54 INFO OGG-00987 Oracle GoldenGate Command Interpreter fo r Oracle: GGSCI command (oracle): start manager.
VIEW REPORT
View process report generated by Extract or Replicat.
Syntax
VIEW REPORT {<group name>[n] | <file name>}
<group name>: The name of the group. The command assumes the report file named
<group>.rpt in the GoldenGate dirrpt sub-directory.
n: The number of an old report. Report files are numbered from 0 (the most
recent) to 9 (the oldest).
<file name>: A fully qualified file name, such as c:\ggs\dirrpt\orders.rpt.Examples
GGSCI 47> view report dirrpt/R_GT.rpt
***********************************************************************
Oracle GoldenGate Delivery for Oracle
Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBO
Linux, x86, 32bit (optimized), Oracle 10g on Apr 23 2012 07:23:02
Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.
Starting at 2012-09-08 07:28:18
***********************************************************************
Operating System Version:
Linux
Version #1 SMP Mon Mar 29 20:06:41 EDT 2010, Release 2.6.18-194.el5
Node: wlbox
Machine: i686
soft limit hard limit
Address Space Size : unlimited unlimited
Heap Size : unlimited unlimited
File Size : unlimited unlimited
CPU Time : unlimited unlimited
...