GoldenGate Microservices Architecture command line client
[oracle@rac201 ~]$ cd $OGG_HOME
[oracle@rac201 ogg21c_ma]$
[oracle@rac201 ogg21c_ma]$
[oracle@rac201 ogg21c_ma]$ ls -lrt
total 56
-rw-r-----. 1 oracle oinstall 63 Sep 1 13:16 oraInst.loc
drwxr-xr-x. 3 oracle oinstall 4096 Dec 7 14:30 diagnostics
drwxr-xr-x. 3 oracle oinstall 4096 Dec 7 14:30 srvm
drwxr-xr-x. 2 oracle oinstall 4096 Dec 7 14:30 deinstall
drwxr-xr-x. 8 oracle oinstall 4096 Dec 7 14:30 lib
drwxr-xr-x. 2 oracle oinstall 4096 Dec 7 14:30 jlib
drwxr-xr-x. 2 oracle oinstall 4096 Dec 7 14:30 include
drwxr-xr-x. 7 oracle oinstall 4096 Dec 7 14:30 jdk
drwxr-xr-x. 13 oracle oinstall 4096 Dec 7 14:30 OPatch
drwxr-xr-x. 2 oracle oinstall 4096 Dec 7 14:30 bin
drwxr-xr-x. 8 oracle oinstall 4096 Dec 7 14:30 oui
drwxr-x---. 13 oracle oinstall 4096 Dec 7 14:30 inventory
drwxr-xr-x. 3 oracle oinstall 4096 Dec 7 14:30 install
drwxr-xr-x. 3 oracle oinstall 4096 Dec 7 14:32 cfgtoollogs
[oracle@rac201 ogg21c_ma]$ cd bin
[oracle@rac201 bin]$
[oracle@rac201 bin]$
[oracle@rac201 bin]$ ls -lrt
total 113596
-rwxrwxr-x. 1 oracle oinstall 6809 Oct 18 2018 XAGTask
-rwxr-x---. 1 oracle oinstall 10362 Dec 16 2020 oggca.sh
-rwxrwxr-x. 1 oracle oinstall 4369 Jul 28 2021 orapki
-rwxrwx---. 1 oracle oinstall 12413968 Jul 29 2021 distsrvr
-rwxrwxr-x. 1 oracle oinstall 8483888 Jul 29 2021 ServiceManager
-rwxrwxr-x. 1 oracle oinstall 1690360 Jul 29 2021 retrace
-rwxrwxr-x. 1 oracle oinstall 1694456 Jul 29 2021 oggerr
-rwxrwxr-x. 1 oracle oinstall 5568576 Jul 29 2021 logdump
-rwxrwxr-x. 1 oracle oinstall 1645280 Jul 29 2021 cachefiledump
-rwxrwxr-x. 1 oracle oinstall 11692320 Jul 29 2021 adminsrvr
-rwxrwxr-x. 1 oracle oinstall 5111424 Jul 29 2021 adminclient
-rwxrwx---. 1 oracle oinstall 11236912 Jul 29 2021 replicat
-rwxrwxr-x. 1 oracle oinstall 8977080 Jul 29 2021 pmsrvr
-rwxrwxr-x. 1 oracle oinstall 5676840 Jul 29 2021 defgen
-rwxrwxr-x. 1 oracle oinstall 1903992 Jul 29 2021 convchk
-rwxrwxr-x. 1 oracle oinstall 5013192 Jul 29 2021 ggcmd
-rwxrwx---. 1 oracle oinstall 11182752 Jul 29 2021 extract
-rwxrwxr-x. 1 oracle oinstall 4976136 Jul 29 2021 emsclnt
-rwxrwxr-x. 1 oracle oinstall 3075192 Jul 29 2021 convprm
-rwxrwxr-x. 1 oracle oinstall 2325248 Jul 29 2021 checkprm
-rwxrwxr-x. 1 oracle oinstall 3185008 Jul 29 2021 certstore
-rwxrwx---. 1 oracle oinstall 10299008 Jul 29 2021 recvsrvr
-rwxrwxr-x. 1 oracle oinstall 112920 Jul 29 2021 keygen
[oracle@rac201 bin]$ ./adminclient
Oracle GoldenGate Administration Client for Oracle
Version 21.3.0.0.0 OGGCORE_21.3.0.0.0_PLATFORMS_210728.1047
Copyright (C) 1995, 2021, Oracle and/or its affiliates. All rights reserved.
Oracle Linux 7, x64, 64bit (optimized) on Jul 28 2021 12:32:46
Operating system character set identified as UTF-8.
OGG (not connected) 1>
OGG (not connected) 2> connect http://rac201.priyadba.com:7802 deployment Deployment1 as oggadmin password oggadmin
OGG (http://rac201.priyadba.com:7802 Deployment1) 3>
OGG (http://rac201.priyadba.com:7802 Deployment1) 3>
OGG (http://rac201.priyadba.com:7802 Deployment1) 4> info all
Program Status Group Type Lag at Chkpt Time Since Chkpt
ADMINSRVR RUNNING
DISTSRVR RUNNING
PMSRVR RUNNING
RECVSRVR RUNNING
EXTRACT RUNNING EXTSAML INTEGRATED 00:00:00 00:00:03
EXTRACT STOPPED SAM_EXT INTEGRATED 00:00:00 03:30:21
OGG (http://rac201.priyadba.com:7802 Deployment1) 5> INFO EXTRACT EXTSAML
Extract EXTSAML Last Started 2024-12-08 15:18 Status RUNNING
Description EXTSAML this is extract process for SAM Larger table
Checkpoint Lag 00:00:00 (updated 00:00:02 ago)
Process ID 7925
Log Read Checkpoint Oracle Integrated Redo Logs
2024-12-08 18:32:57
SCN 0.4876338 (4876338)
Settings Profile Default
Encryption Profile LocalWallet
OGG (http://rac201.priyadba.com:7802 Deployment1) 6> STATUS EXTRACT EXTSAML
EXTRACT EXTSAML: RUNNING
You can edit SAM_EXT by executing edit params SAM_EXT
OGG (http://rac201.priyadba.com:7802 Deployment1) 5> edit params SAM_EXT
OGG (http://rac201.priyadba.com:7802 Deployment1) 8> INFO EXTRACT EXTSAML, LAG;
Error: Unexpected value 'LAG;'.
Syntax for 'INFO EXTRACT' command is:
INFO EXTRACT <group-name-wildcard>
[ SHOWCH [ <checkpoints-number> ] ]
[ DETAIL ]
[ TASKS | ALLPROCESSES ]
[ UPGRADE | DOWNGRADE | CONTAINERS ]
OGG (http://rac201.priyadba.com:7802 Deployment1) 8> STATS EXTRACT EXTSAML
Sending STATS request to Extract group EXTSAML ...
Start of statistics at 2024-12-08 18:34:42.
DDL replication statistics (for all trails):
*** Total statistics since extract started ***
Operations 1.00
Mapped operations 1.00
Unmapped operations 0.00
Other operations 0.00
Excluded operations 0.00
Output to LR:
Extracting from SAM.LARGE_DATA_TABLE to SAM.LARGE_DATA_TABLE:
*** Total statistics since 2024-12-08 16:19:37 ***
Total inserts 65536.00
Total updates 0.00
Total deletes 0.00
Total upserts 0.00
Total discards 0.00
Total operations 65536.00
*** Daily statistics since 2024-12-08 16:19:37 ***
Total inserts 65536.00
Total updates 0.00
Total deletes 0.00
Total upserts 0.00
Total discards 0.00
Total operations 65536.00
*** Hourly statistics since 2024-12-08 16:19:37 ***
Total inserts 65536.00
Total updates 0.00
Total deletes 0.00
Total upserts 0.00
Total discards 0.00
Total operations 65536.00
*** Latest statistics since 2024-12-08 16:19:37 ***
Total inserts 65536.00
Total updates 0.00
Total deletes 0.00
Total upserts 0.00
Total discards 0.00
Total operations 65536.00
End of statistics.
OGG (http://rac201.priyadba.com:7802 Deployment1) 9> VIEW REPORT EXTSAML
***********************************************************************
Oracle GoldenGate Capture for Oracle
Version 21.3.0.0.0 OGGCORE_21.3.0.0.0_PLATFORMS_210728.1047_FBO
Oracle Linux 7, x64, 64bit (optimized), Oracle Database 21c and lower supported versions on Jul 29 2021 04:01:17
Copyright (C) 1995, 2021, Oracle and/or its affiliates. All rights reserved.
Starting at 2024-12-08 15:18:17
***********************************************************************
Operating System Version:
Linux
Version #1 SMP Tue May 16 11:07:48 PDT 2023, Release 4.18.0-477.10.1.el8_8.x86_64
Node: rac201.priyadba.com
Machine: x86_64
soft limit hard limit
Address Space Size : unlimited unlimited
Heap Size : unlimited unlimited
File Size : unlimited unlimited
CPU Time : unlimited unlimited
Process id: 7925
Description: EXTSAML this is extract process for SAM Larger table
***********************************************************************
** Running with the following parameters **
***********************************************************************
2024-12-08 15:18:17 INFO OGG-03059 Operating system character set identified as UTF-8.
2024-12-08 15:18:17 INFO OGG-02695 ANSI SQL parameter syntax is used for parameter parsing.
2024-12-08 15:18:17 INFO OGG-01360 EXTRACT is running in Integrated mode.
EXTRACT EXTSAML
USERIDALIAS oggadmin DOMAIN OracleGoldenGate
2024-12-08 15:18:18 INFO OGG-03541 Oracle Environment Variables:
TNS_ADMIN = /u01/app/oracle/product/19.3/db_home/network/admin
LD_LIBRARY_PATH = /u04/app/ogg/ogg21c_ma/lib/instantclient:/u04/app/ogg/ogg21c_ma/lib.
EXTTRAIL LR
DDL INCLUDE MAPPED
DDLOPTIONS REPORT
TABLE SAM.LARGE_DATA_TABLE;
2024-12-08 15:18:18 INFO OGG-02734 Using heartbeat table from schema ggadmin.
2024-12-08 15:18:18 INFO OGG-01815 Virtual Memory Facilities for: BR
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/u04/app/ogg/ogg21c_deploy/var/run/BR/EXTSAML.
Bounded Recovery Parameter:
BRINTERVAL = 4HOURS
BRDIR = /u04/app/ogg/ogg21c_deploy/var/run/
2024-12-08 15:18:18 INFO OGG-01851 filecaching started: thread ID: 139723429570304.
2024-12-08 15:18:18 INFO OGG-01815 Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/u04/app/ogg/ogg21c_deploy/var/temp.
2024-12-08 15:18:18 INFO OGG-25340
Database Version:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production.
2024-12-08 15:18:18 INFO OGG-25341
Database Language and Character Set:
NLS_LANGUAGE = "AMERICAN"
NLS_TERRITORY = "AMERICA"
NLS_CHARACTERSET = "AL32UTF8".
2024-12-08 15:18:18 INFO OGG-26025
Database Unique Name: orcl.
2024-12-08 15:18:18 INFO OGG-06604 Connected to database ORCL.PRIYADBA.COM, CPU info: CPU Count 1, CPU Core Count 1, CPU Socket Count 1.
2024-12-08 15:18:18 INFO OGG-06618 Database ORCL.PRIYADBA.COM Platform: Linux x86 64-bit.
2024-12-08 15:18:24 INFO OGG-02248 Logmining server DDL filtering enabled.
2024-12-08 15:18:25 INFO OGG-02339 Integrated capture successfully attached to logmining server OGG$CAP_EXTSAML using 60 second streaming dur
ation.
2024-12-08 15:18:25 INFO OGG-02089 Source redo compatibility version is: 19.0.0.
2024-12-08 15:18:25 INFO OGG-15446 Extract configured as OTHER_GROUPS resource group.
2024-12-08 15:18:25 INFO OGG-02086 Integrated Dictionary will be used.
2024-12-08 15:18:25 WARNING OGG-02905 Replication of OID column in object tables may diverge.
2024-12-08 15:18:25 INFO OGG-02776 Native data capture is enabled for Oracle NUMBER data type.
2024-12-08 15:18:25 INFO OGG-01971 The previous message, 'INFO OGG-02776', repeated 1 times.
2024-12-08 15:18:25 INFO OGG-01052 No recovery is required for target file LR000000000, at RBA 0 (file not opened).
2024-12-08 15:18:25 INFO OGG-01478 Output file LR is using format RELEASE 19.1/21.1.
***********************************************************************
** Run Time Messages **
***********************************************************************
2024-12-08 16:18:38 INFO OGG-00538 Metadata not invalidated for "SAM".LARGE_DATA_TABLE because of TRUNCATE.
2024-12-08 16:18:38 INFO OGG-01487 DDL found, operation [truncate table LARGE_DATA_TABLE (size 31)], start SCN [4842939], commit SCN [4842977
] instance [ (1)], DDL seqno [0], marker seqno [0].
2024-12-08 16:18:38 INFO OGG-00487 DDL operation included [INCLUDE MAPPED], optype [TRUNCATE], objtype [TABLE], objowner "SAM", objname "LARG
E_DATA_TABLE".
2024-12-08 16:18:39 INFO OGG-00538 Metadata not invalidated for "SAM".LARGE_DATA_TABLE because of TRUNCATE.
2024-12-08 16:18:39 INFO OGG-00497 Writing DDL operation to extract trail file.
2024-12-08 16:19:37 INFO OGG-06507 MAP (TABLE) resolved (entry SAM.LARGE_DATA_TABLE): TABLE "SAM"."LARGE_DATA_TABLE".
2024-12-08 16:19:37 WARNING OGG-06439 No unique key is defined for table LARGE_DATA_TABLE. All viable columns will be used to represent the key,
but may not guarantee uniqueness. KEYCOLS may be used to define the key.
2024-12-08 16:19:37 INFO OGG-06509 Using the following key columns for source table SAM.LARGE_DATA_TABLE: ID, NAME, CREATED_DATE.
2024-12-08 16:40:04 INFO OGG-01026 Rolling over remote file LR000000000.
2024-12-08 18:34:42 INFO OGG-01021 Command received from application REST API: STATS.
OGG (http://rac201.priyadba.com:7802 Deployment1) 3> help
Administration Client Command Summary:
! - Executes the previous command without modifications.
ADD AUTORESTART - (Command removed) Create an autorestart rule.
ADD CHECKPOINTTABLE - Creates a checkpoint table in a database.
ADD CREDENTIALS - Create user credentials for use by the Administration Client.
ADD CREDENTIALSTORE - (Deprecated) Creates a credentials store (wallet) that stores encrypted database user credentials.
ADD DISTPATH - Creates a distribution path.
ADD ENCRYPTIONPROFILE - Create an encryption profile for trail encryption/decryption.
ADD EXTRACT - Creates an Extract group.
ADD EXTTRAIL - Adds a local trail to the Oracle GoldenGate configuration.
ADD HEARTBEATTABLE - Add a heartbeat table to the database
ADD MASTERKEY - Adds a master encryption key to a master encryption key wallet.
ADD PROCEDURETRANDATA - Enables procedure-level supplemental logging.
ADD PROFILE - Create a profile for managed processes.
ADD RECVPATH - Creates a target-initiated distribution path in Receiver Service.
ADD REPLICAT - Adds a Replicat group.
ADD RMTTRAIL - Adds a remote trail to the Oracle GoldenGate configuration.
ADD SCHEMATRANDATA - Enables schema-level supplemental logging.
ADD TRACETABLE - Creates a trace table.
ADD TRANDATA - Enables table-level supplemental logging.
ALLOWNESTED - Enables the use of nested OBEY files.
ALTER CREDENTIALSTORE - Changes the contents of a credentials store.
ALTER DISTPATH - Changes the attributes of a distribution path.
ALTER ENCRYPTIONPROFILE - Alter an encryption profile for trail encryption/decryption.
ALTER EXTRACT - Changes attributes of an Extract group.
ALTER EXTTRAIL - Changes attributes of a local trail.
ALTER HEARTBEATTABLE - Alter a heartbeat table in the database
ALTER RECVPATH - Changes the attributes of a target-initiated distribution path in Receiver Service.
ALTER REPLICAT - Changes attributes of a Replicat group.
ALTER RMTTRAIL - Changes attributes of a remote trail.
CD - Change the Admin Client working directory
CLEANUP CHECKPOINTTABLE - Removes checkpoint records that are no longer needed.
CLEANUP EXTRACT - Deletes run history for an Extract group.
CLEANUP REPLICAT - Deletes run history of a Replicat group.
CLEAR INSTANTIATION CSN FOR - Clear the instantiation CSN on a target table.
CONNECT - Connect to an Oracle GoldenGate Service Manager
CREATE WALLET - (Deprecated) Creates a wallet that stores master encryption keys.
DBLOGIN USERIDALIAS - Logs the session into a database so that other commands that affect the database can be issued.
DELETE AUTORESTART - (Command removed) Remove an autorestart rule.
DELETE CHECKPOINTTABLE - Removes a checkpoint table from a database.
DELETE CREDENTIALS - Remove user credentials from the Administration Client.
DELETE CREDENTIALSTORE - Deletes the wallet that serves as a credentials store.
DELETE DISTPATH - Deletes a distribution path.
DELETE ENCRYPTIONPROFILE - Remove an encryption profile.
DELETE EXTRACT - Deletes an Extract group.
DELETE EXTTRAIL - Removes a local trail from the Oracle GoldenGate configuration.
DELETE HEARTBEATENTRY - Delete heartbeat table entries from the database
DELETE HEARTBEATTABLE - Delete a heartbeat table from the database
DELETE MASTERKEY - Marks a master encryption key for deletion.
DELETE PROCEDURETRANDATA - Disables procedure-level supplemental logging.
DELETE PROFILE - Remove a managed process profile.
DELETE RECVPATH - Deletes a target-initiated distribution path in Receiver Service.
DELETE REPLICAT - Deletes a Replicat group.
DELETE RMTTRAIL - Removes a remote trail from the Oracle GoldenGate configuration.
DELETE SCHEMATRANDATA - Disables schema-level supplemental logging.
DELETE TRACETABLE - Removes a trace table.
DELETE TRANDATA - Disables table-level supplemental logging.
DISABLE SERVICE - Disable the specified Oracle GoldenGate services.
DISCONNECT - Disconnect from the Oracle GoldenGate Service Manager
EDIT ENCKEYS - Opens the ENCKEYS file for editing in the default text editor.
EDIT GLOBALS - Opens the GLOBALS parameter file for editing in the default text editor.
EDIT PARAMS - Opens a parameter file for editing in the default text editor.
ENABLE SERVICE - Enable the specified Oracle GoldenGate services.
ENCRYPT PASSWORD - Encrypt a password that is used in an Oracle GoldenGate parameter file or command.
EXIT - Exit the Oracle GoldenGate Admin Client
FLUSH SEQUENCE - Updates an Oracle sequence so that initial redo records are available at the time that Extract starts capturing transaction data.
HEALTH DEPLOYMENT - Display the health of the specified Oracle GoldenGate deployments.
HELP - Provides assistance with syntax and usage of commands.
HISTORY - Shows a list of the most recently issued commands since the startup of the session.
INFO ALL - Displays status and lag for all Oracle GoldenGate processes on a system.
INFO AUTORESTART - (Command removed) Returns information about autorestart rules.
INFO CHECKPOINTTABLE - Returns information about one or more checkpoint tables.
INFO CREDENTIALS - Display information about Administration Client user credentials.
INFO CREDENTIALSTORE - Returns information about a credentials store.
INFO DISTPATH - Returns information about distribution path(s).
INFO ENCRYPTIONPROFILE - Returns information about encryption profiles.
INFO ER - Returns information about the specified wildcarded groups.
INFO EXTRACT - Returns information about an Extract group.
INFO EXTTRAIL - Returns information about a local trail.
INFO HEARTBEATTABLE - Describe a heartbeat table in the database
INFO MASTERKEY - Returns information about master encryption keys.
INFO PARAM - Displays parameter definition information.
INFO PROCEDURETRANDATA - Returns information about the state of procedure-level supplemental logging.
INFO PROFILE - Returns information about managed process profiles.
INFO RECVPATH - Returns information about target-initiated distribution path(s) in Receiver Service.
INFO REPLICAT - Returns information about a Replicat group.
INFO RMTTRAIL - Returns information about a remote trail.
INFO SCHEMATRANDATA - Returns information about the state of schema-level supplemental logging.
INFO TRACETABLE - Returns information about a trace table.
INFO TRANDATA - Returns information about the state of table-level supplemental logging.
KILL ER - Forcibly terminates the specified wildcarded groups.
KILL EXTRACT - Forcibly terminates the run of an Extract group.
KILL REPLICAT - Forcibly terminates a Replicat group.
LAG ER - Returns lag information about the specified wildcarded groups.
LAG EXTRACT - Returns information about Extract lag.
LAG REPLICAT - Returns information about Replicat lag.
LIST TABLES - Lists the tables in the database with names that match the input specification.
MININGDBLOGIN USERIDALIAS - Specifies the credentials of the user that an Oracle GoldenGate process uses to log into an Oracle mining database.
NOALLOWNESTED - Disables the use of nested OBEY files.
OBEY - Processes a file that contains a list of Oracle GoldenGate commands.
OPEN WALLET - (Deprecated) Opens a master encryption key wallet.
PURGE EXTTRAIL - Removes files related to a local trail from the file system.
PURGE WALLET - Permanently removes from a wallet the master encryption keys that are marked as deleted.
REGISTER EXTRACT - Registers an Extract group with the database.
REGISTER REPLICAT - Registers a Replicat group with the database.
RENEW MASTERKEY - Adds a new version of a master encryption key.
RESTART DEPLOYMENT - Restart the specified Oracle GoldenGate deployments.
RESTART ER - Stops, then starts the specified wildcarded groups.
RESTART EXTRACT - Stops, then starts an Extract group.
RESTART REPLICAT - Stops, then starts a Replicat group.
RESTART SERVICE - Restart the specified Oracle GoldenGate services.
SEND ER - Sends instructions to, or returns information about, the specified wildcarded groups.
SEND EXTRACT - Sends instructions to, or returns information about, a running Extract group.
SEND REPLICAT - Sends instructions to, or returns information about, a running Replicat group.
SET COLOR - Enable or disable colored text in the Administration Client.
SET DEBUG - Enable or disable debugging mode for the Administration Client.
SET EDITOR - Sets the default text editor program for editing parameter files.
SET INSTANTIATION CSN - Set the instantiation CSN on a target table.
SET PAGER - Sets the default text viewer program for viewing parameter and report files.
SET VERBOSE - Enable or disable verbose command result output.
SHELL - Executes shell commands on the local system.
SHOW - Displays the attributes of the Oracle GoldenGate environment.
START DEPLOYMENT - Start the specified Oracle GoldenGate deployments.
START DISTPATH - Starts a distribution path.
START ER - Starts the specified wildcarded groups.
START EXTRACT - Starts an Extract group.
START RECVPATH - Starts a target-initiated distribution path in Receiver Service.
START REPLICAT - Starts a Replicat group.
START SERVICE - Start the specified Oracle GoldenGate services.
STATS DISTPATH - Returns statistics for a distribution path.
STATS ER - Returns processing statistics for the specified wildcarded groups.
STATS EXTRACT - Returns processing statistics for an Extract group.
STATS RECVPATH - Returns statistics for a target-initiated distribution path in Receiver Service.
STATS REPLICAT - Returns processing statistics for a Replicat group.
STATUS DEPLOYMENT - Display status of the specified Oracle GoldenGate deployments.
STATUS ER - Returns the state of the specified wildcarded groups.
STATUS EXTRACT - Returns the state of an Extract group.
STATUS REPLICAT - Returns the state of a Replicat group.
STATUS SERVICE - Display status of the specified Oracle GoldenGate services.
STOP DEPLOYMENT - Stop the specified Oracle GoldenGate deployments.
STOP DISTPATH - Stops a distribution path.
STOP ER - Stops the specified wildcarded groups.
STOP EXTRACT - Stops an Extract group.
STOP RECVPATH - Stops a target-initiated distribution path in Receiver Service.
STOP REPLICAT - Stops a Replicat group.
STOP SERVICE - Stop the specified Oracle GoldenGate services.
SYNCHRONIZE REPLICAT - Returns all threads of a coordinated Replicat to a uniform start point after an unclean shutdown of the Replicat process.
UNDELETE MASTERKEY VERSION - Changes the state of a master encryption key from being marked as deleted to marked as available.
UNREGISTER EXTRACT - Unregisters an Extract group from the database.
UNREGISTER REPLICAT - Unregisters a Replicat group from the database.
UPGRADE CHECKPOINTTABLE - Adds a supplemental checkpoint table when upgrading Oracle GoldenGate from version 11.2.1.0.0 or earlier.
UPGRADE HEARTBEATTABLE - Alters heartbeat tables to track Extract restart position.
VALIDATE ENCRYPTIONPROFILE - Validates that data can be encrypted with the given profile.
VERSIONS - Displays information about the operating system and database.
VIEW DISCARD - Displays the discard file that is generated by Extract or Replicat.
VIEW ENCKEYS - Displays the contents of the ENCKEYS file in read-only mode on-screen.
VIEW GLOBALS - Displays the contents of the GLOBALS parameter file in read-only mode on-screen.
VIEW MESSAGES - Displays the Oracle GoldenGate message log (ggserr.log file).
VIEW PARAMS - Displays the contents of a parameter file in read-only mode on-screen.
VIEW REPORT - Displays the process report that is generated by Extract or Replicat.
No comments:
Post a Comment