Switching between GoldenGate integrated extraction (Integrated capture) mode and traditional decimation mode (classic capture) in Oracle environments

Check extraction process mode

in the Ggsci environment, execute a statement similar to the following to see the status of a particular process.

Ggsci>Info <Group_Name>
Where,<group_name> is the process name.
Example: the Epubadm process extraction mode shown is Integrated Extraction Mode(Integrated Capture)

Example: the ETEST process extraction mode shown is Traditional decimation mode(Classic Capture) upgrade from classic capture mode to integrated extraction (Integrated capture) mode 1. Pre-upgrade Preparation A. Enabling database archivingEnsure that the extracted source-side database runs in archive mode and can be SQLPLUSEnvironment is checked by the following statement. Sql>Archive Log List

B. Enable Force LOGGING archive mode (optional)You need to enable the Force LOGGING Archive mode when you need to synchronize objects in nologging mode. Enable the following statement for the step. (1). Check the Force LOGGING mode status sql> SELECT force_logging_mode from V$database;(2), enable Force LOGGING mode sql> ALTER DATABASE Force LOGGING; ALTER SYSTEM SWITCH LOGFILE; c. Enable additional logsIn the GGSCI environment, add additional logs at the table level with the following command ggsci> ADD trandata <schema.table_name>For additional logs at the schema level, you can add them using the following command. Ggsci> ADD schematrandata <schema_name> D. Configuring the Stream pool sizeOn the extraction process-enabled database (extraction Source library or downstream library), you need to configure the stream pool size to apply to logmining Server. Sql> ALTER SYSTEM SET streams_pool_size=<pool_size> scope=both sid= ' * '; Note :The flow pool size is extracted by the integrated parameter max_sga_sizeAnd PARALLELISMDecided that the recommended formula is (Max_sga_size * PARALLELISM) * 1.25

2. Upgrade the extraction process

A. backup software catalog

Back to the current Oracle GoldenGate working directories. B. Modifying the extraction process parametersIn most cases, the extraction process parameters in the traditional decimation mode also apply to the extraction process in the integrated extraction mode. you need to modify the extraction process parameters as needed. For example: Set up an integrated extraction process with a single logminner process using the SGA size for the 100m,logminner process number of 1. tranlogoptions integratedparams (max_sga_size, PARALLELISM 1) Landing source database under C.GGSCI environmentLog in to the source-side database in the GGSCI environment using a statement similar to the following. Ggsci> dblogin userid goldengate, password goldengate_2015 D. Registering the extraction process to mine the database ggsci> REGISTER EXTRACT <group> DATABASE E. Stopping the extraction processGgsci> STOP EXTRACT <group> F. Check whether the process allows upgrade to integrated extraction modeIssue the following command to determine whether the upgrade command can be issued. Transactions that started before the registration command must be written To the Trail before you can proceed with the upgrade. Issue this command more than once until it returns a message stating this Extract can be upgraded.Ggsci> INFO EXTRACT <group> UPGRADE G. Upgrading the extraction process to the integrated extraction modeGgsci> ALTER EXTRACT <group> UPGRADE INTEGRATED tranlog H. Restart the extraction processggsci> START EXTRACT <group>

degraded from integrated extraction (Integrated capture) mode to classic capture mode
1. Downgrade the extraction process

A. backup software catalog

Back to the current

Oracle GoldenGate working directories.

B. Modifying the extraction process parametersIn most cases, the extraction process parameters in the traditional decimation mode also apply to the extraction process in the integrated extraction mode. you need to modify the extraction process parameters as needed. C. Stopping the extraction processGgsci> STOP EXTRACT <group> D. Checking if a process is allowed to downgrade to traditional extraction modeIssue the following command to determine whether the downgrade command can be issued. Transactions that started before the downgrade command is issued must being written to the trail before you can proceed. Your may has to issue this command more than once until it returns a message stating that Extract can be downgraded. Ggsci> INFO EXTRACT <group> UPGRADE Landing source database under E.GGSCI environmentLog in to the source-side database in the GGSCI environment using a statement similar to the following. Ggsci> dblogin userid goldengate, password goldengate_2015 F. Downgrade the extraction process to the integrated extraction modeGgsci> ALTER EXTRACT <group> downgrade INTEGRATED tranlog G. Anti-registration extraction processGgsci> UNREGISTER EXTRACT <group> DATABASE H. Restart the extraction processGgsci> START EXTRACT <group>

Reference Documents(1). Oracle GoldenGate Performance Best Practices "(2)." GoldenGate administering Oracle GoldenGate for Windows and UNIX 12c (12. 1.2) "

20.7 switching Extract from Classic mode to Integrated mode

Switching between GoldenGate integrated extraction (Integrated capture) mode and traditional decimation mode (classic capture) in Oracle environments