This example creates two extracts by splitting the load into two extract processes with the RANGE function.
Preparation
Please follow the step to setup the WEST database in Bi-directional Replication - Oracle DB to Oracle DB (1) - Basic Setup.
Configure the Extracts
In the TABLE setup in the extract parameter file, you can add the RANGE function. The first extract is configured as follows:
Please follow the step to setup the WEST database in Bi-directional Replication - Oracle DB to Oracle DB (1) - Basic Setup.
Configure the Extracts
In the TABLE setup in the extract parameter file, you can add the RANGE function. The first extract is configured as follows:
The second extract is configured as follows:
Extract exw01 SETENV(ORACLE_HOME="/u01/app/oracle/product/11.2.0/dbhome_1") SETENV(ORACLE_SID = "ogg11r2") ExtTrail ./dirdat/e1 UserID ogguser@ogg11r2, Password Welcome1 StatOptions ResetReportStats ReportCount Every 10 Records TranLogOptions ExcludeUser ogguser Table WEST.account, filter(@range(1, 2, ACCT_ID));
Extract exw02 SETENV(ORACLE_HOME="/u01/app/oracle/product/11.2.0/dbhome_1") SETENV(ORACLE_SID = "ogg11r2") ExtTrail ./dirdat/e2 UserID ogguser@ogg11r2, Password Welcome1 StatOptions ResetReportStats ReportCount Every 10 Records TranLogOptions ExcludeUser ogguser Table WEST.account, filter(@range(2, 2, ACCT_ID));
Check the Replication
To check the replication, you can perform an update in the WEST.ACCOUNT table as follows:
To check the replication, you can perform an update in the WEST.ACCOUNT table as follows:
UPDATE account set account_balance = 2400 where acct_id = 299;
After the update, you can check the stats of the extract shown as follows:
Note that if you stop one of the extract process, the other process will keep running. However, the record which needs to be processed by the stopped the extract process won't be replicated until the extract group start.
GGSCI (EDLVC3AR5P5) 23> stats exw01 Sending STATS request to EXTRACT EXW01 ... Start of Statistics at 2015-07-17 10:30:41. Output to ./dirdat/e1: Extracting from WEST.ACCOUNT to WEST.ACCOUNT: *** Total statistics since 2015-07-17 10:30:28 *** Total inserts 0.00 Total updates 1.00 Total deletes 0.00 Total discards 0.00 Total operations 1.00 *** Daily statistics since 2015-07-17 10:30:28 *** Total inserts 0.00 Total updates 1.00 Total deletes 0.00 Total discards 0.00 Total operations 1.00 *** Hourly statistics since 2015-07-17 10:30:28 *** Total inserts 0.00 Total updates 1.00 Total deletes 0.00 Total discards 0.00 Total operations 1.00 *** Latest statistics since 2015-07-17 10:30:28 *** Total inserts 0.00 Total updates 1.00 Total deletes 0.00 Total discards 0.00 Total operations 1.00 End of Statistics. GSCI (EDLVC3AR5P5) 18> stats exw02 Sending STATS request to EXTRACT EXW02 ... Start of Statistics at 2015-07-17 10:30:09. Output to ./dirdat/e2: Extracting from WEST.ACCOUNT to WEST.ACCOUNT: *** Total statistics since 2015-07-17 10:26:30 *** No database operations have been performed. *** Daily statistics since 2015-07-17 10:26:30 *** No database operations have been performed. *** Hourly statistics since 2015-07-17 10:26:30 *** No database operations have been performed. *** Latest statistics since 2015-07-17 10:26:30 *** No database operations have been performed. End of Statistics.