Cataloged here are some very important, common commands that are used via the GGSCI interface during the GoldenGate configuration and for troubleshooting.
Related Links
• GGSCI Commands I
• GGSCI Commands II
• GoldenGate: GGSCI Commands I
INFO
INFO MANAGER
Provides details of the Manager process
INFO MGR
Also provides details of the Manager process
STATUS MANAGER
This command also display the info of manager
REFRESH
REFRESH MANAGER
Reloads from the Manager Parameter file
REFRESH MGR
Reloads from the Manager Parameter file
SEND
SEND MANAGER CHILDSTATUS
Displays status of processes, started by Manager.
SEND MANAGER CHILDSTATUS DEBUG
Return the ports numbers allocated by the Manager
SEND MANAGER GETPORTINFO
Displays the list of currently allocated ports by Manager process
SEND MANAGER GETPORTINFO DETAIL
Provides info on ports and process assigned to them.
SEND MANAGER GETPURGEOLDEXTRACTS
Retrieves trail purge retention info.
START
START MANAGER
Starts the Manager Process
START MGR
Starts the Manager Process
STOP
STOP MGR
Stops the Manager Process
STOP MANAGER !
Stops Manager without asking for user confirmation.
STOP MGR !
Stops Manager without asking for user confirmation.
ADD Command
Creates an Extract group.
ADD EXTRACT E_SRC, Tranlog, Begin Now
Used to specify transaction logs as data source for extract.
ADD EXTRACT E_SRC, Begin Now, Passive
Specifies the extract to be run in passive mode.
ADD EXTRACT E_SRC, Extseqno 000008 Extrba 287458, Begin Now
Specifies the extract process starting position
ADD EXTRACT E_SRC, SOURCEISTABLE
Extracts data from data tables for initial loading.
ALTER Command
ALTER EXTRACT e_src, BEGIN NOW
Instructs extract to start processing
ALTER EXTRACT e_src, BEGIN 2013-04-16
Instructs extract to start processing from specific date
ALTER EXTRACT e_src, ETROLLOVER
Extract rolls over to next trail file
ALTER EXTRACT e_src, EXTSEQNO 01, EXTRBA 2887
Alters extract to start from the specific locaton in the trail
ALTER EXTRACT e_src, THREAD 4, BEGIN 2012-03-09
Alters extract thread & start date for RAC
ALTER EXTRACT e_src, LSN 1234:123:1
Altering extract for the SQL Server
CLEANUP Command
It is used to clear the run history for the specific extract group
CLEANUP EXTRACT e_src
It purges all history of records except last
CLEANUP EXTRACT e_src, SAVE 10
It saves last 10 records and deletes all other
DELETE Command
It is used to delete the extract process, its checkpoints detail and unregister the extract group.
DELETE EXTRACT e_src
deletes the extract process
DELETE EXTRACT e*
deletes all extract process whose name starts with e
DELETE EXTRACT e* !
deletes all extract process whose name starts with e without prompting
INFO Command
It is used to display the info of the extract like its status, lag, checkpoint, run history, trail info etc
INFO EXTRACT e_src, SHOWCH
Display checkpoint info of extract
INFO EXTRACT e_src, DETAIL
Display trail info, run history
INFO EXTRACT e_src, TASKS
Display extract tasks
KILL Command
It is used to kill the extract that can't be stopped with STOP Command""
KILL EXTRACT e_src
LAG Command
It is used to find the lag time between Extract and data source more precisely than the "INFO Command"
LAG EXTRACT e_src
To find lag for extract "e_src"
LAG EXTRACT *
To find lag for all of the extract processes
REGISTER Command
It is used to register the extract process, so that it can retain the archive logs required for its recovery.
REGISTER EXTRACT e_src LOGRETENTION
To register extract "e_src"
SEND Command
It is used to communicate with the running extract like sending requests for report creation, stats, to force extract to rollover to next trail etc
SEND EXTRACT finance, ROLLOVER
To increment the extract to next file in trail
SEND EXTRACT finance, STOP
To stop the extract process
SEND EXTRACT finance, TRANLOGOPTIONS TRANSCLEANUPFREQUENCY 20
For the Oracle RAC, specify the time after which the OGG scan and delete the orphan transactions
SEND EXTRACT finance, SKIPTRANS 5.17.27634 THREAD 2
For skipping the transaction in the Oracle RAC environment
SEND EXTRACT e_src, SHOWTRANS
Display the info about the open transactions like checkpoint, extract group name, SCN, Redo log and RB, status etc
SEND EXTRACT e_src, SHOWTRANS COUNT 2
Display the info for two transactions only
START Command
It is used to start the Extract process
START EXTRACT e_src
STATS Command
It is used to display the stats for the extract process including the DDL and DML operations.
STATS e_src
STATS EXTRACT e_src
stats will be displayed for the extract E_SRC""
STATS EXTRACT e_src REPORTRATE SEC
display the stats for the fetch opertions per sec
STATS EXTRACT e_src, TOTAL, DAILY
The total stats is shown since the start of the day
STATS EXTRACT e_src, TOTAL, HOURLY, REPORTRATE MIN, RESET, REPORTFETCH
By using comma between the keywords multiple options can be used for the stats command
STATUS Command
It is used to check whether extract process is currently running or not.
STATUS EXTRACT e_src
To check the status for extract "E_SRC"
STATUS EXTRACT e*
To check the status for all extracts starting with "e"
STOP Command
It is used to stop the running extract process
STOP EXTRACT e_src
To stop the extract "e_src"
STOP EXTRACT e*
To stop all of the running extract process whose name start with "e"
STOP EXTRACT *
To stop all of the running extract processes
UNREGISTER Command
it is used to unregister the extract group by removing its registration from oracle DB.
UNREGISTER EXTRACT e_src LOGRETENTION
To unregister the extract e_src""
ADD Command
It is used to create the replicat process by creating checkpoints
ADD REPLICAT INITLOAD, SPECIALRUN
It will create a special run replicat as task.
ADD REPLICAT r_trg, EXTTRAIL /ORACLE/GOLDENGATE/DIRDAT/TT
Create the replicat with the trail
ADD REPLICAT r_trg, EXTTRAIL /ORACLE/GOLDENGATE/DIRDAT/TT, CHECKPOINTTABLE OGG_USER.OGG_CHECKPOINT
Create the replicat with the trail and the checkpoint info like the DB table used to save checkpoint info.
ADD REPLICAT r_trg, EXTTRAIL /ORACLE/GOLDENGATE/DIRDAT/TT, NODBCHECKPOINT
Create the replicat with the trail and specifying that this replicat did'nt write info to DB table
ALTER Command
It is used to change the properties of the existing replicat process
ALTER REPLICAT r_trg, BEGIN NOW
Alter replicat to start processing from now
ALTER REPLICAT r_trg, BEGIN 2013-05-11
Alter replicat to start processing from specific date
ALTER REPLICAT r_trg, BEGIN 2013-01-07 08:00:01
Alter replicat to start processing from specific date and time
ALTER REPLICAT r_trg, EXTSEQNO 00007
Alter replicat to start from the specific trail file
ALTER REPLICAT r_trg, EXTRBA 65477
Alter replicat to start from the specific location in the trail
CLEANUP Command
It is used to clear the run history for the specific replicat process
CLEANUP REPLICAT r_trg
It purges all history of records except last
CLEANUP REPLICAT r_trg, SAVE 10
It saves last 10 records and deletes all other
DELETE Command
It is used to delete the replicat process, by removing the checkpoints and freeing trail file for purging by manager. But the process must be stopped and user must be logged in using DBlogin command
DELETE REPLICAT r_trg
deletes the replicat process
DELETE EXTRACT r*
deletes all replicat process whose name starts with r
DELETE EXTRACT r* !
deletes all replicat process whose name starts with r without prompting
INFO Command
It is used to display the replicat info like processing history, status, appox lag, trail info, checkpoint info and environment of replicat.
INFO REPLICAT *, TASKS
It is used to display replicat tasks only.
INFO REPLICAT r_trg
It is used to display the information of replicat.
INFO REPLICAT r_trg, DETAIL
It display the detailed information of replicat.
INFO REPLICAT r_trg, SHOWCH
It displays the checkpoint table information, from checkpoint file and checkpoint table.
KILL Command
It is used to kill the replicat that can't be stopped with "STOP Command", but checkpoint info remain unchanged and transactions are rolled back in DB
KILL REPLICAT r_trg
LAG Command
It is used to find the lag time between Replicat and trail more precisely than the "INFO Command"
LAG REPLICAT r_trg
To find lag for replicat "r_trg"
LAG REPLICAT *
To find lag for all of the replicat processes
SEND Command
It is used to communicate with the running replicat process
SEND REPLICAT r_trg, HANDLECOLLISIONS
Enable the handlecollisions option of OGG used for error handling
SEND REPLICAT r_trg, REPORT HANDLECOLLISIONS r_*
Generate statical report to replicat report file
SEND REPLICAT r_trg, GETLAG
Get the lag info in seconds
START Command
To start the replicat process
START REPLICAT r_trg
START REPLICAT r_trg, ATCSN 6454388
To start the replicat process from the oracle-specific CSN number including the CSN no transaction
START REPLICAT r_trg, AFTERCSN 6454389
To start the replicat process from the oracle-specific CSN number, but ignoring that CSN no transaction
STATS Command
It is used to display the stats for the replicat process.
STATS r_trg
STATS REPLICAT r_trg
stats will be displayed for the REPLICAT r_trg""
STATS REPLICAT r_trg REPORTDETAIL SEC
display the stats for the opertaion that were not replicated due to errors
STATS REPLICAT r_trg, TOTAL, DAILY
The total stats is shown since the start of the day
STATS REPLICAT r_trg, TOTAL, HOURLY, REPORTRATE MIN, RESET, NOREPORTDETAIL
By using comma between the keywords multiple options can be used for the stats command
STATUS Command
It is used to find whether replicat is running or not
STATUS REPLICAT r_trg
To check the status for replicat "r_trg"
STATUS REPLICAT r*
To check the status for all replicat starting with "r"
STOP Command
It is used to stop the running replicat process
STOP REPLICAT r_trg
To stop the replicat "r_trg"
STOP REPLICAT r*
To stop all of the running replicat process whose name start with "r"
STOP REPLICAT *
To stop all of the running replicat processes
ER Commands
They are used to control the multiple extract and replicat processes
INFO ER *
To info all of the process
KILL ER *
To kill all of the process
LAG ER *
To get lag info of all the process
SEND ER *
To use send command on all of the process
START ER *
To start all of the process
STATS ER *
To check the stats all of the process
STATUS ER *
To find status of all the process
STOP ER *
To stop all of the process
ADD EXTTRAIL
It is used to create the local trail file for extract process on local system
ADD EXTTRAIL /ORACLE/GOLDENGATE/DIRDAT/SE, EXTRACT e_src, MEGABYTES 100
Create EXTTRAIL with the Prefix"SE", and the size of 100 mb
ADD EXTTRAIL /ORACLE/GOLDENGATE/DIRDAT/SE000009
To create the EXTTRAIL with specific sequence number
ADD RMTTRAIL
It is used to create the remote trail files for the extract or pump processes on remote systems
ADD RMTTRAIL /ORACLE/GOLDENGATE/DIRDAT/TE, EXTRACT p_src, MEGABYTES 100
Create RMTTRAIL with the Prefix"TE", and the size of 100 mb
ADD RMTTRAIL /ORACLE/GOLDENGATE/DIRDAT/SE000009
To create the RMTTRAIL with specific sequence number
ALTER EXTTRAIL
It is used to change the options of the existing EXTTRAIL file for extract process on local system
ALTER EXTTRAIL /ORACLE/GOLDENGATE/DIRDAT/SE, EXTRACT e_src, MEGABYTES 50
ALTER RMTTRAIL
It is used to change the options of the existing RMTTRAIL file of extract or pump processes on remote systems
ALTER RMTTRAIL /ORACLE/GOLDENGATE/DIRDAT/TE, EXTRACT p_src, MEGABYTES 50
DELETE EXTTRAIL
It is used to delete the exttrail assigned to the extract on local system by deleting its references from checkpoint file
DELETE EXTTRAIL /ORACLE/GOLDENGATE/DIRDAT/SE
DELETE RMTTRAIL
It is used to delete the exttrail for the extract or pump on remote system by deleting its references from checkpoint file
DELETE RMTTRAIL /ORACLE/GOLDENGATE/DIRDAT/TE
INFO EXTTRAIL
It is used to display the info of local trail like name, associated extract, rba and file size etc
INFO EXTTRAIL /ORACLE/GOLDENGATE/DIRDAT/SE
Display info for specific exttrails
INFO EXTTRAIL *
Display info for all exttrails
INFO RMTTRAIL
It is used to display the info of remote trail like name, associated extract, rba and file size etc
INFO RMTTRAIL /ORACLE/GOLDENGATE/DIRDAT/TE
Display info for specific rmttrails
INFO RMTTRAIL *
Display info for all rmttrails
GGSCI Command Series
• GoldenGate: GGSCI Commands II
• GoldenGate: GGSCI Commands IIILogDump Command Series
Leave a Reply