Find us on Google+ Google+

February 6, 2016

ggsci Oracle GoldenGate (OGG) Command Interpreter

GGSCI   -- (Oracle) GoldenGate Software Command Interpreter

OGG files

Reports (.rpt)                       /u02/goldengate/ogg/dirrpt
Parameters (.prm)                /u02/goldengate/ogg/dirprm
Replicat Checkpoints (.cpr)    /u02/goldengate/ogg/dirchk
Extract Checkpoints (.cpe)    /u02/goldengate/ogg/dirchk
Process Status (.pcs)            /u02/goldengate/ogg/dirpcs
SQL Scripts (.sql)                 /u02/goldengate/ogg/dirsql
Database Definitions (.def)   /u02/goldengate/ogg/dirdef
Dump files (.dmp)                /u02/goldengate/ogg/dirdmp
Masterkey wallet files (.wlt)  /u02/goldengate/ogg/dirwlt
Credential store files (.crd)   /u02/goldengate/ogg/dircrd

How to Invoke OGG command line interface?
C:\GG> ggsci.exe    (in Windows)
[oracle@prod gg]$ ./ggsci

Commands
ggsci> HELP [command] [object]
ggsci> help

GGSCI/OGG Command Summary:

Object:          Command:
SUBDIRS          CREATE
DATASTORE      ALTER, CREATE, DELETE, INFO, REPAIR
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
JAGENT            INFO, START, STATUS, STOP
MANAGER         INFO, SEND, START, STOP, STATUS
MARKER           INFO
PARAMETERS    EDIT, VIEW, SET EDITOR, INFO, GETPARAMINFO
REPLICAT         ADD, ALTER, CLEANUP, DELETE, INFO, KILL, LAG, REGISTER, SEND,
                       START, STATS, STATUS, STOP, SYNCHRONIZE, UNREGISTER
REPORT                  VIEW
RMTTRAIL               ADD, ALTER, DELETE, INFO
TRACETABLE           ADD, DELETE, INFO
TRANDATA               ADD, DELETE, INFO
SCHEMATRANDATA   ADD, DELETE, INFO
CHECKPOINTTABLE  ADD, DELETE, CLEANUP, INFO, UPGRADE
WALLET                  CREATE, OPEN, PURGE
MASTERKEY             ADD, INFO, RENEW, DELETE, UNDELETE
CREDENTIALSTORE  ADD, ALTER, INFO, DELETE
HEARTBEATTABLE    ADD, DELETE, ALTER, INFO
HEARTBEATENTRY    DELETE

Commands without an object:
(Database)     DBLOGIN, LIST TABLES, ENCRYPT PASSWORD, FLUSH SEQUENCE,  MININGDBLOGIN, SET NAMECCSID
(DDL)            DUMPDDL
(Miscellaneous)  !, ALLOWNESTED | NOALLOWNESTED, CREATE SUBDIRS, DEFAULTJOURNAL, FC, HELP,
             HISTORY, INFO ALL, OBEY, SHELL, SHOW, VERSIONS, VIEW GGSEVT, VIEW REPORT
                 (note: type the word COMMAND after the ! to display the
                 ! help topic, for example: GGSCI (sys1)> help ! command
                 
For help on a specific command, type HELP command object.
Example: HELP ADD REPLICAT

ggsci> help add rmttrail
=========================================================================
ggsci > CREATE SUBDIRS     -- To create default directories within Oracle GoldenGate (OGG) home directory
=========================================================================
DATASTORE        ALTER, CREATE, DELETE, INFO, REPAIR
=========================================================================
ER               INFO, KILL, LAG, SEND, STATUS, START, STATS, STOP
ggsci > INFO ER group_wildcard_specification   -- To get information on multiple Extract and Replicat groups as a unit
ggsci > info er *ext*
ggsci > info ER *

ggsci > START ER group_wildcard_specification    -- To start multiple Extract and Replicat groups as a unit
ggsci > start er *rep*

ggsci > STOP ER group_wildcard_specification    -- To stop multiple Extract and Replicat groups as a unit
ggsci > stop er *ext*

ggsci > STATUS ER group_wildcard_specification   -- To check the status of multiple Extract and Replicat groups as a unit
ggsci > status er *EX*

ggsci > LAG ER group_wildcard_specification   -- To get lag information on multiple Extract and Replicat groups as a unit
ggsci > lag er *ext*

ggsci > KILL ER group_wildcard_specification   -- To forcefully terminate multiple Extract and Replicat groups as a unit
ggsci > kill er *x*

ggsci > SEND ER group_wildcard_specification   -- To send instructions to multiple Extract and Replicat groups as a unit
ggsci > send er *ext

ggsci > STATS ER group_wildcard_specification   -- To get statistics on multiple Extract and Replicat groups as a unit
ggsci > stats er ext*
stats ER *
=========================================================================
EXTRACT          ADD, ALTER, CLEANUP, DELETE, INFO, KILL, LAG, REGISTER, SEND, START, STATS, STATUS, STOP, UNREGISTER
ggsci > INFO EXTRACT group_name [, SHOWCH [n]] [, DETAIL] [, TASKS | ALLPROCESSES]  -- To display status of Extract, approximate Extract lag, checkpoint information, process run history
ggsci > info extract emp_ext
ggsci > info extract cust_ext, detail
ggsci > info extract ext*, showch
INFO EXTRACT E*, SHOWCH 10
ggsci > info extract *, detail
ggsci > info extract hr, tasks
ggsci > info extract extp, allprocesses

ggsci > ADD EXTRACT group_name
{, SOURCEISTABLE |, TRANLOG [bsds_name] |, VAM |, EXTFILESOURCE file_name |, EXTTRAILSOURCE trail_name |, VAMTRAILSOURCE VAM_trail_name}
{, BEGIN {NOW | yyyy-mm-dd [hh:mi:[ss[.cccccc]]]} |, EXTSEQNO seqno, EXTRBA relative_byte_address |, LOGNUM log_number, LOGPOS byte_offset |, EOF |, LSN value |, EXTRBA relative_byte_address |, PAGE data_page, ROW row |
} [, THREADS n] [, PASSIVE] [, PARAMS parameter_file] [, REPORT report_file] [, DESC "description"]   -- To create an Extract group
Syntax for an alias Extract:
ADD EXTRACT group_name, RMTHOST {host_name | IP_address}, {MGRPORT port} | {PORT port} [, RMTNAME name] [, DESC "description"]
ggsci > add extract s_extr, tranlog, begin now
ggsci > add extract finext, tranlog, begin now, threads 4
ggsci > add extract fin, tranlog, begin now, passive
ADD EXTRACT ESOURCE02, INTEGRATED TRANLOG, BEGIN NOW
ggsci > add extract ext_ms, extseqno 111, begin now
ggsci > add extract hr_ext, extrba 567890, begin 2018-04-02 12:00:00
ggsci > add extract initload, sourceistable
ggsci > add extract pump, exttrailsource /oracle/ogg/dirdat/hr
ggsci > add extract fin, vam                        -- VAM - Vendor Access Module
ggsci > add extract fin, vamtrailsource /ogg/dirdat/vt
ggsci > add extract finA, rmthost host123, mgrport 7810, rmtname fin

ggsci > REGISTER EXTRACT extract_group_name LOGRETENTION
ggsci > register extract extr logretention
ggsci > REGISTER EXTRACT 1ext DATABASE

ggsci > UNREGISTER EXTRACT extract_group_name LOGRETENTION
ggsci > unregister extract extr logretention

ggsci > ALTER EXTRACT group_name [, ADD_EXTRACT_attribute] [, THREAD number] [, ETROLLOVER]  -- To change the attributes of an Extract group, To increment a trail to the next file in the sequence
ggsci > alter extract PA_AD, begin now
ggsci > alter extract EA_AD, begin 2018-08-23
ggsci > alter extract PA_AD, etrollover
ggsci > alter extract PA_AD, extseqno 5470, extrba 209184
ggsci > alter extract accounts, thread 4, begin 2018-03-09
ggsci > alter extract sales, lsn 1234:123:1
ALTER EXTRACT finance, SCN 778899
ALTER EXTRACT finance, UPGRADE INTEGRATED TRANLOG
ALTER EXTRACT finance, SEQNO 1234 JOURNAL accts/acctsjrn JRNRCV accts/jrnrcv0005

ggsci > LAG EXTRACT group_name    -- To determine a true lag time between Extract and the datasource
ggsci > lag extract ext*
ggsci > lag extract *

ggsci > KILL EXTRACT group_name    -- To kill an Extract process running in regular or PASSIVE mode
ggsci > kill extract fin

ggsci > DELETE EXTRACT group_name [!]   -- To delete an Extract group
ggsci > delete extract emp_ext
ggsci > delete extract emp_ext !              -- will not ask for confirmation

ggsci > CLEANUP EXTRACT group_name [, SAVE count]    -- To delete run history for the specified Extract group
ggsci > cleanup extract fin
ggsci > cleanup extract e*, save 6

ggsci > START EXTRACT extract_name   -- To start Extract process
ggsci > start extract extr

ggsci > STOP EXTRACT extract_name   -- To stop Extract gracefully
ggsci > stop extract extr

ggsci > STATUS EXTRACT group_name [, TASKS | ALLPROCESSES]   -- To determine whether or not Extract is running
ggsci > status extract extr_hr
ggsci > status extract ext*, tasks
ggsci > status extract *ext*, allprocesses

ggsci > STATS EXTRACT group_name [, statistic] [, TABLE table] [, TOTALSONLY table_specification] [, REPORTFETCH | NOREPORTFETCH] [, REPORTRATE HR|MIN|SEC] [, ... ]  -- To display statistics for one or more Extract group
ggsci > stats ext_hr
ggsci > stats ecm*
ggsci > stats extract ext
ggsci > stats extract ext2 reportrate sec
ggsci > stats extract fin, total, daily
stats extract fin, total, hourly, table acct, reportrate min, reset, reportfetch
stats extract ext_1a, reset

ggsci > SEND EXTRACT group_name, 
{ CACHEMGR {CACHESTATS | CACHEQUEUES | CACHEPOOL} | FORCESTOP | FORCETRANS id [THREAD n] [FORCE] | GETLAG | GETTCPSTATS | LOGEND | REPORT | ROLLOVER | SHOWTRANS [id] [THREAD n] [COUNT n] [DURATION duration_unit] [TABULAR] [FILE file_name [DETAIL]] | SKIPTRANS id [THREAD n] [FORCE] | STATUS | STOP | TLTRACE {DEBUG | OFF | level} [SIZELIMIT size] [DDLINCLUDE | DDL[ONLY]] [FILE] file_name | TRACE[2] {tracefile | OFF} | TRACEINIT | TRANLOGOPTIONS {PURGEORPHANEDTRANSACTIONS | NOPURGEORPHANEDTRANSACTIONS} | TRANLOGOPTIONS TRANSCLEANUPFREQUENCY minutes | VAMMESSAGE "Teradata_command" | VAMMESSAGE {ARSTATS | INCLUDELIST [filter] | EXCLUDELIST [filter]} | VAMMESSAGE OPENTRANS
}     -- To communicate with a running Extract process
Teradata_command = {"control:terminate" | "control:suspend" | "control:resume" | "control:copy database.table"
ggsci > send extract exthr status
ggsci > send extract extr, getlag
ggsci > send extract group_name tltrace file file_name ddlinclude
ggsci > send extract fin, rollover
ggsci > send extract fin  stop
ggsci > send extract fin, vammessage control:suspend
ggsci > send extract fin, tranlogoptions transcleanupfrequency 15
ggsci > send extract fin, showtrans
ggsci > send extract fin, showtrans count 10
ggsci > send extract fin, skiptrans 15.7.42734 thread 4
=========================================================================
EXTTRAIL         ADD, ALTER, DELETE, INFO
ggsci > INFO EXTTRAIL trail_name  -- To retrieve configuration information for a local trail
ggsci > info exttrail *
ggsci > info exttrail e:\ogg\dirdat\ex

ggsci > ADD EXTTRAIL trail_name, EXTRACT group_name [, MEGABYTES n] [, SEQNO n]   -- To create a trail for online processing on local system
ggsci > add exttrail /oracle/ogg/dirdat/lt, extract s_extr
ggsci > add exttrail C:\OGG\dirdat\et, extract emp_ext
ggsci > add exttrail c:\ogg\dirdat\fi, extract fin, megabytes 50

ggsci > ALTER EXTTRAIL trail_name, EXTRACT group_name [, MEGABYTES n]   -- To change the attributes of a trail (on the local system)
ggsci > alter exttrail c:\ogg\dirdat\aa, extract fin, megabytes 30

ggsci > DELETE EXTTRAIL trail_name    -- To delete the record of checkpoints associated with a trail on a local system
ggsci > delete exttrail /home/ogg/dirdat/et
=========================================================================
JAGENT           INFO, START, STATUS, STOP
=========================================================================
MANAGER          INFO, SEND, START, STOP, STATUS
ggsci > INFO ALL [TASKS | ALLPROCESSES]   -- To display the status of all Manager, Extract, Datapump and Replicat processes
ggsci > info all
Program     Status      Group       Lag       Time Since Chkpt
MANAGER     RUNNING

EXTRACT     STOPPED     EXTR      00:01:15      00:00:07

REPLICAT    ABENDED     REP       00:00:00      00:00:04
ggsci > info all tasks
ggsci > info all allprocesses
ggsci > INFO MANAGER   -- To determine whether or not the Manager process is running
ggsci > INFO MGR
ggsci > INFO MARKER [COUNT number_of_items]  -- To review recently processed markers from a nonstop system
ggsci > info marker

ggsci > EDIT PARAMS {MGR | ./GLOBALS | group_name | file_name}  -- To create or change a parameter file
ggsci > EDIT PARAMS DEFGEN
ggsci > edit params ./GLOBALS
GGSCHEMA ogg_own

CHECKPOINTTABLE ogg_own.checkpoint
ALLOWOUTPUTDIR /u02/ogg_trails
HEARTBEATTABLE table_name
ENABLEMONITORING

ggsci > edit params mgr

ggsci > VIEW PARAMS {MGR | group_name | file_name}   -- To view the contents of a parameter file
ggsci > view params mgr

ggsci > view params s_extr
ggsci > view params e:\ogg_parameters\replp.prm

ggsci > START MANAGER    -- To start Manager process
ggsci > start MGR
ggsci > start *

ggsci > STOP MANAGER [!]    -- To stop Manager process
ggsci > stop manager
ggsci > stop mgr
ggsci > stop manager !    -- will not ask for confirmation

ggsci > REFRESH MANAGER  -- not available in Oracle 11g
ggsci > REFRESH MGR

ggsci > SEND MANAGER [CHILDSTATUS [DEBUG]] [GETPORTINFO [DETAIL]] [GETPURGEOLDEXTRACTS]   -- To retrieve the status of the active Manager process or to retrieve dynamic port information as configured in the Manager parameter file
ggsci > send manager childstatus
ggsci > send manager childstatus debug
ggsci > send manager getportinfo
ggsci > send manager getportinfo detail
ggsci > send manager getpurgeoldextracts

ggsci > STATUS MANAGER    -- To determine whether or not the Manager process is running
ggsci > status manager
=========================================================================
PARAMETERS       EDIT, VIEW, SET EDITOR, INFO, GETPARAMINFO
ggsci > SET EDITOR program_name    -- To change the default text editor for the current session of GGSCI, default editors are Notepad for Windows and vi for UNIX
ggsci > set editor wordpad
=========================================================================
REPLICAT         ADD, ALTER, CLEANUP, DELETE, INFO, KILL, LAG, REGISTER, SEND,
                 START, STATS, STATUS, STOP, SYNCHRONIZE, UNREGISTER
ggsci > INFO REPLICAT group_name [, SHOWCH [n]] [, DETAIL] [, TASKS | ALLPROCESSES] -- To display status of Replicat, approximate replication lag, the trail from which Replicat is reading, Replicat run history, including checkpoints in the trail, information about the Replicat environment.
ggsci > info replicat emp_rep
ggsci > info replicat emp_rep, detail
ggsci > info replicat prd*, detail, allprocesses
ggsci > info replicat *, tasks
ggsci > info replicat fin, showch
info ra002 detail

INFO command will read the checkpoint file.
LAG command get the lag time more precisely, because it directly communicates with ER to obtain the lag time.
SEND command communicates directly with the process and gets the current/latest status of it.

ggsci > edit params e:\ogg\dirprm\replp.prm

ggsci > ADD REPLICAT group_name
{, SPECIALRUN |, EXTFILE full_path_name |, EXTTRAIL full_path_name}
[, BEGIN {NOW | YYYY-MM-DD HH:MM[:SS[.CCCCCC]]} |, EXTSEQNO seqno, EXTRBA rba] [, CHECKPOINTTABLE owner.table | NODBCHECKPOINT]
[, PARAMS parameter_file] [, REPORT report_file] [, DESC "description"]   -- To create a Replicat group
ggsci > add replicat repl, exttrail C:\OGG\dirdat\lt
ggsci > add replicat R3CT, exttrail /u01/ogg/dirdat/lt, checkpointtable ogg_own.checkpoint
ggsci > add replicat initload, specialrun
ggsci > add replicat sales, exttrail /oracle/ogg/dirdat/lt, nodbcheckpoint
ADD REPLICAT financer, INTEGRATED, EXTTRAIL c:\ggs\dirdat\rt
ggsci > add replicat sales, EXTTRAIL /ogg/dirdat/ex, FORMAT RELEASE 11.1

ggsci > SEND REPLICAT group_name,
{ FORCESTOP | GETLAG | HANDLECOLLISIONS [table_specification] | NOHANDLECOLLISIONS [table_specification] | REPORT [HANDLECOLLISIONS [table_specification]] | STATUS | STOP | TRACE[2] [DDLINCLUDE | DDL[ONLY]] [FILE] file_name | TRACE[2] OFF | TRACEINIT
}    -- To communicate with a starting or running Replicat process
ggsci > send replicat fin, handlecollisions
ggsci > send replicat fin, report handlecollisions fin_*
ggsci > send replicat fin, getlag

ggsci > ALTER REPLICAT group_name , 
[, BEGIN {NOW | YYYY-MM-DD HH:MM[:SS[.CCCCCC]]} |, EXTSEQNO seqno, EXTRBA rba] [, PARAMS parameter_file] [, REPORT report_file] [, DESC "description"]   -- To change the attributes of a Replicat group
ggsci > alter replicat fin, begin now
ggsci > alter replicat rfin, begin 2018-08-08 08:08:08
ggsci > alter replicat RA_AD, extseqno 3804
ggsci > alter replicat RA_AD, extrba 766338576
alter replicat RBBP01 extseqno 13, extrba 11995

ggsci > CLEANUP REPLICAT group_name [, SAVE count]   -- To delete run history for a specified Replicat group
ggsci > cleanup replicat fin
ggsci > cleanup replicat *, save 10

ggsci > DELETE REPLICAT group_name [!]   -- To delete a Replicat group
ggsci > delete replicat emp_ext
ggsci > delete replicat emp_ext !             -- will not ask for confirmation

ggsci > KILL REPLICAT group_name   -- To kill a Replicat process
ggsci > kill replicat fin

ggsci > LAG REPLICAT group_name   -- To determine a true lag time between Replicat and the trail
ggsci > lag replicat myrepl
ggsci > lag replicat *

ggsci > START REPLICAT group_name [SKIPTRANSACTION | ATCSN csn | AFTERCSN csn]   -- To start Replicat process
ggsci > start replicat RCT
ggsci > start replicat fin, atcsn 5238306       -- commit sequence number (CSN)
ggsci > start replicat fin, aftercsn 0X000006B1:0002334D:0004
ggsci > start replicat MYREP skiptransaction
start RAU8 NOFILTERDUPTRANSACTIONS

ggsci > STOP REPLICAT replicat_name [!]   -- To stop Replicat gracefully
ggsci > stop replicat 2RCT
ggsci > stop replicat rep !

ggsci > STATUS REPLICAT group_name [, TASKS | ALLPROCESSES]  -- To determine whether or not Replicat is running
ggsci > status replicat emp_rep
ggsci > status replicat cust_rep, tasks
ggsci > status replicat rep, allprocesses

ggsci > STATS REPLICAT group_name [, statistic] [, TABLE table] [, TOTALSONLY table_specification] [, REPORTDETAIL | NOREPORTDETAIL] [, REPORTRATE HR|MIN|SEC] [, ... ]   -- To display statistics for one or more Replicat groups
ggsci > stats rep_hr
ggsci > stats rep_name -total
STATS REPLICAT r_trg REPORTDETAIL SEC
STATS REPLICAT r_trg, TOTAL, DAILY
stats replicat fin, total, table acct, reportrate hr, reset, noreportdetail
STATS REPLICAT group, REPORTCDR
=========================================================================
RMTTRAIL          ADD, ALTER, DELETE, INFO
ggsci > INFO RMTTRAIL trail_name  -- To retrieve configuration information for a remote trail
ggsci > info rmttrail *
ggsci > info rmttrail d:\ogg\dirdat\ex

ggsci > ADD RMTTRAIL trail_name, EXTRACT group_name [, MEGABYTES n] [, SEQNO n]   -- To create a trail for online processing on remote system
ggsci > add rmttrail C:\OGG\dirdat\hr, extract extr
ggsci > add rmttrail /u01/app/oracle/ogg/dirdat/ms, extract msextr
ggsci > add rmttrail /u02/app/ogg/dirdat/my, extract mysql, megabytes 50

ggsci > ALTER RMTTRAIL trail_name, EXTRACT group_name [, MEGABYTES n]   -- To change the attributes of a trail (on a remote system)
ggsci > alter rmttrail c:\ogg\dirdat\et, extract fin, megabytes 25

ggsci > DELETE RMTTRAIL trail_name    -- To delete the record of checkpoints associated with a trail on a remote system
ggsci > delete rmttrail /home/ogg/dirdat/et
=========================================================================
TRACETABLE        ADD, DELETE, INFO
ggsci > INFO TRACETABLE [owner.table]      -- To verify the existence of the specified trace table
ggsci > info tracetable
ggsci > info tracetable ora_trace

ggsci > ADD TRACETABLE [owner.table]    -- To create a trace table in the Oracle database
ggsci > add tracetable
ggsci > add tracetable ora_trace

ggsci > DELETE TRACETABLE [owner.table]    -- To delete a trace table
ggsci > delete tracetable
ggsci > delete tracetable ora_trace
=========================================================================
TRANDATA         ADD, DELETE, INFO
ggsci > INFO TRANDATA user_name.table_names [, OLDFORMAT] [, USETRIGGER]  -- To determine whether logging/replication enabled or not
ggsci > info trandata hr.*
ggsci > info trandata fin.acct

ggsci > ADD TRANDATA user_name.table_names [, COLS (column_list)] [, INCLUDELONG | EXCLUDELONG]
 [, LOBSNEVER | LOBSALWAYS | LOBSIFCHANGED | LOBSALWAYSNOINDEX] [, NOKEY] [, OLDFORMAT] [, USETRIGGER]    -- To enable Oracle GoldenGate to acquire the transaction information it needs from the transaction records
ggsci > add trandata hr.*
ggsci > add trandata emp.employees
ggsci > add trandata fin.acct, cols (name, address)
ggsci > add trandata fin.acct, nokey, cols (name, pid)
ggsci > add trandata fin.acct, lobsalwaysnoindex
ADD TRANDATA \u20AC1
ggsci > ADD TRANDATA SCHEMA_NAME.TABLE_NAME ALLCOLS 

ggsci > DELETE TRANDATA user_name.table_names [, OLDFORMAT] [, USETRIGGER]  -- To delete logging/replication data
ggsci > delete trandata fin.acct
ggsci > delete trandata fin.cust*
ggsci > delete trandata emp.hr, usetrigger
=========================================================================
SCHEMATRANDATA   ADD, DELETE, INFO
ggsci > ADD SCHEMATRANDATA OWNER ALLCOLS
ggsci > INFO SCHEMATRANDATA
=========================================================================
CHECKPOINTTABLE  ADD, DELETE, CLEANUP, INFO, UPGRADE
ggsci > INFO CHECKPOINTTABLE [user_name.table_name]  -- To confirm the existence of a checkpoint table and view the date and time that it was created
ggsci > info checkpointtable ogg_own.chkpt_table

ggsci > ADD CHECKPOINTTABLE [user_name.table_name]   -- To create a checkpoint table in the target database
ggsci > add checkpointtable
ggsci > add checkpointtable ogg_own.checkpoint

ggsci > CLEANUP CHECKPOINTTABLE [user_name.table_name]  -- To remove checkpoint records from the checkpoint table
ggsci > cleanup checkpointtable ggs.fin_check

ggsci > DELETE CHECKPOINTTABLE [user_name.table_name] [!]     -- To drop a checkpoint table from the database
ggsci > delete checkpointtable ggs.fin_check
=========================================================================
WALLET            CREATE, OPEN, PURGE
create wallet
open wallet
purge wallet
=========================================================================
MASTERKEY        ADD, INFO, RENEW, DELETE, UNDELETE
ADD MASTERKEY
add masterkey ogg_mk
INFO MASTERKEY [VERSION version]
INFO MASTERKEY VERSION 7
info masterkey ogg_mk version 1
DELETE MASTERKEY {VERSION version | RANGE FROM begin_value TO end_value | ALL}
DELETE MASTERKEY VERSION 10
DELETE MASTERKEY RANGE FROM 3 TO 6
UNDELETE MASTERKEY VERSION version
UNDELETE MASTERKEY VERSION 3
renew masterkey ogg
=========================================================================
CREDENTIALSTORE  ADD, ALTER, INFO, DELETE
ggsci > ADD CREDENTIALSTORE
ggsci > ALTER CREDENTIALSTORE ADD USER oggadmin@suq alias gg_root
ggsci > ALTER CREDENTIALSTORE delete user gg_root
ALTER CREDENTIALSTORE {
  ADD USER userid |
  REPLACE USER userid |
  DELETE USER userid }
[PASSWORD password]
[ALIAS alias]
[DOMAIN domain]

ggsci > ADD CREDENTIALSTORE
ggsci > ALTER CREDENTIALSTORE ADD USER oggadmin password password
ggsci > ALTER CREDENTIALSTORE REPLACE USER oggadmin password password
ALTER CREDENTIALSTORE ADD USER ggadmin PASSWORD oracle ALIAS gg_root DOMAIN gg
ALTER CREDENTIALSTORE ADD USER oggown PASSWORD oggown ALIAS gg_root
ALTER CREDENTIALSTORE REPLACE USER oggown@testdb PASSWORD oggown ALIAS gg_root
ggsci > INFO CREDENTIALSTORE
ggsci > DELETE CREDENTIALSTORE
=========================================================================
HEARTBEATTABLE    ADD, DELETE, ALTER, INFO
ggsci > ADD HEARTBEATTABLE # from OGG 12.2
ggsci > add heartbeattable, frequency 5
ggsci > ALTER HEARTBEATTABLE
ggsci > INFO heartbeattable
ggsci > DELETE HEARTBEATTABLE
=========================================================================
HEARTBEATENTRY   DELETE

=========================================================================

Commands without an object:
(Database)       DBLOGIN, LIST TABLES, ENCRYPT PASSWORD, FLUSH SEQUENCE, MININGDBLOGIN, SET NAMECCSID
ggsci > DBLOGIN {SOURCEDB|TARGETDB dsn | USERID user_name[, PASSWORD password] [SYSDBA] | 
SOURCEDB|TARGETDB dsn, USERID user_name[, PASSWORD password] [SYSDBA] [SQLID sqlid]   -- To establish a database connection
ggsci > dblogin sourcedb testdb
ggsci > dblogin targetdb repldb
ggsci > dblogin userid gg
ggsci > dblogin userid gg, password oracle
ggsci > dblogin userid system@localhost:1521/prod, password 12345678
ggsci > dblogin sourcedb ctdb@host1, userid ogg_own, password ggs sysdba
ggsci > dblogin USERIDALIAS gg_login

ggsci > ENCRYPT PASSWORD password [ENCRYPTKEY keyname]   -- To encrypt a database login password
ggsci > encrypt password oracle143 encryptkey spiderman

ggsci > LIST TABLES table_name   -- To list all tables in the database that match the specification
ggsci > list tables cust*
=========================================================================
(DDL)            DUMPDDL

ggsci > DUMPDDL [SHOW]   -- To view the data in the Oracle GoldenGate DDL history table
ggsci > dumpddl
=========================================================================

(Miscellaneous)  !, ALLOWNESTED | NOALLOWNESTED, CREATE SUBDIRS, DEFAULTJOURNAL, FC, HELP, 
  HISTORY, INFO ALL, OBEY, SHELL, SHOW, VERSIONS, VIEW GGSEVT, VIEW REPORT
ggsci > SHOW   -- To display the Oracle GoldenGate (OGG) environment
ggsci > SHOW ALL

ggsci > VIEW GGSEVT                -- To view GoldenGate error log (ggserr.log file)

ggsci > VIEW REPORT {group_name[n] | file_name|mgr}   -- To view the process report that is generated by Extract or Replicat
ggsci > view report ext6
ggsci > view report rep
ggsci > view report mgr  
ggsci > view report c:\ogg\dirrpt\orders.rpt

ggsci > HISTORY [n]   -- To view the most recently issued GGSCI commands since the session started
ggsci > history       -- by default, shows last 10 commands
ggsci > history 30

ggsci > VERSIONS   -- To display operating system and database version information
ggsci > versions

Operating System:

Linux

Version #1 SMP Mon Mar 29 20:19:03 EDT 2013, Release 2.6.18-194.el5PAE

Node: linux03.calldba.com

Machine: x86_64
Database:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – Production

PL/SQL Release 11.2.0.3.0 – Production

CORE 11.2.0.3.0 Production

TNS for Linux: Version 11.2.0.3.0 – Production

NLSRTL Version 11.2.0.3.0 – Production

ggsci > FC [n | -n | string]   -- To display edit a previously issued GGSCI command and then execute it again
ggsci > fc
ggsci > fc 9
ggsci > fc -3
ggsci > fc sta
FC editor commands
i text  -- Inserts text
r text  -- Replaces text
d        -- Deletes a character
replacement_text  -- Replaces the displayed command with the text that we enter on a one-for-one basis.

ggsci > SHELL shell_command   -- To execute shell commands from within GGSCI interface
ggsci > shell ls -l /u01/app/oracle/ogg/dirdat
ggsci > sh dir dirprm\*
ggsci > shell rm ./dat*
GGSCI > shell pmap -x replicate_process_id

ggsci > ! [n | -n | string]    -- To execute previous GGSCI command
ggsci > !
ggsci > ! 6    -- To run the command 6 listed in the history
ggsci > ! -3
ggsci > ! sta
ggsci > help ! command

ggsci > OBEY ggsci_script      -- To process a file that contains a list of Golden Gate commands.
ggsci > shell more /u01/app/oracle/ogg/startup.txt
START MANAGER

START EXTRACT EXT3

START EXTRACT DPUMP

INFO ALL
ggsci > obey /u01/app/oracle/ogg/startup.txt
ggsci > obey ./mycommands.txt


ggsci > EXIT

Related Articles:  Golden Gate (OGG) LogDump Commands

7 comments:

  1. Hi i am new to Oracle golden gate.... Installing OGG 11g soft...
    OGG:- 11.2.1.0.1
    oracle database :- 11.2.0.1.0
    O.S.:- OEL5 (32-bit)

    I have done these steps:-
    SQL> create tablespace OGGDATA datafile '+ASM1/oggdata01.dbf' size 1000M autoextend ON;
    SQL> create user ggs_owner identified by ggs_owner default tablespace OGGDATA temporary tablespace TEMP profile DEFAULT;
    SQL> alter user ggs_owner QUOTA UNLIMITED ON OGGDATA;
    SQL> grant RESOURCE,CONNECT to ggs_owner;
    SQL> grant CREATE SESSION,ALTER SESSION to ggs_owner;
    SQL> grant SELECT ANY TABLE to ggs_owner;
    SQL> grant CREATE TABLE to ggs_owner;
    SQL> grant FLASHBACK ANY TABLE to ggs_owner;
    SQL> grant SELECT ANY DICTIONARY to ggs_owner;
    SQL> grant execute on dbms_flashback to ggs_owner;
    SQL> grant execute on utl_file to ggs_owner;

    e.Run scripts for creating all necessary objects for support ddl replication:
    SQL> @$/u01/ogg/marker_setup.sql
    SQL> @$/u01/ogg/ddl_setup.sql
    SQL> @$/u01/ogg/role_setup.sql
    SQL> grant GGS_GGSUSER_ROLE to ggs_owner;
    SQL> @$/u01/ogg/ddl_enable.sql

    dblogin ggs_owner, password ggs_owner
    Error: Unable to connect to database using user ggs_owner. Please check privileges.
    ORA-12162: TNS:net service name is incorrectly specified…

    I have checked the listener and tnsnames file, i have only 1 listener and 1tns specified… tns is getting pinged successfully...
    Help me out….

    ReplyDelete
  2. This comment has been removed by a blog administrator.

    ReplyDelete
  3. I follow all your posts , they are too good. I searche alot for multiple gg process and I need more info . Can you give a good idea how to divide schemsa having procedures packages,functions, tables,views and public synonyms of the objects in these 5 schemas.There are few contraints which are refering to tables in other schemas, and if tables created with contraints refering to objects of diff schema. To what extent TABLEEXCLUDE AND TABLEINDCLUE will be helpful. How to divde between extracts and replicats and can you give a good reference guide for mutliple goldengate processes. and good resource for that.I have schema with low activity and high activity . How to design a good replicat which overcome all these and how about extract. Thanks in advance.
    ..

    ReplyDelete
  4. I really love your website.. Very nice colors &
    theme. Did you build this amazing site yourself?
    Please reply back as I'm hoping to create my own website and would like to find out where you got this from or
    just what the theme is called. Thanks!

    ReplyDelete
  5. Hello,
    Very useful post. This is my first time I visit here. I found so many interesting information in your blog. Really it’s great article. Keep it up. Oracle GoldenGate

    ReplyDelete
  6. Do you want to pass 1Z0-447 exam in 1st try? Pass your OPN Certified Specialist 1Z0-447 easily by the help of latest 1Z0-447 dumps questions & answers. Your Oracle GoldenGate 12c Implementation Essentials success is guaranteed with our 100% money back guarantee. Braindumps4IT provide real 1Z0-447 exam questions and latest 1Z0-447 braindumps.

    ReplyDelete