Add new apply process (new target database) to an existing replication.

Owned by Clive Otten (Unlicensed)
Jan 21, 2020
5 min read

Problem Description

The article explains the step by step procedure to add a new APPLY process to a existing replication setup without having to disturb the Repository , or the MINE process. 


Steps Perfomed

  1. Setup normal one way replication MINE ---> APPLY

| Dbvisit Replicate 2.8.02(MAX edition) - Evaluation License expires in 30 days MINE is running. Currently at plog 3840 and SCN 204288611 (12/09/2016 12:02:33). APPLY is running. Currently at plog 3840 and SCN 204288596 (12/09/2016 12:02:29). Progress of replication ZD8622:MINE->APPLY: total/this execution ------------------------------------------------------------------------- TEST.DEPT:   100%  Mine:1/1   Unrecov:0/0   Applied:1/1  Conflicts:0/0   Last:09/12/2016 12:02:31/OK TEST.EMP:    100%  Mine:1/1   Unrecov:0/0   Applied:1/1  Conflicts:0/0  Last:09/12/2016 12:02:31/OK ------------------------------------------------------------------------- 2 tables listed.

2. Shutdown all processes.

3. Backup the following files on MINE before going to step4:

  • all.sh

  • onetime.ddc

  • setup.dbvrep

4. Run setup wizard again to configure the second pair MINE->APPLY1 (i.e DSRC->TRG11G). 

1: Oracle dsrc, SYS/***, SYSTEM/***, dbvrep/***, USERS/TEMP, dbvrep/, ASM:No, TZ: +13:00 2: Oracle dtrg, SYS/***, SYSTEM/***, dbvrep/***, OEDATA/TEMP, dbvrep/, ASM:No, TZ: +00:00 3: Oracle trg11g, SYS/***, SYSTEM/***, dbvrep/***, USERS/TEMP, dbvrep/, ASM:No, TZ: +00:00

 Use same dbvrep repository.

Following processes are defined:

1: MINE on dsrc Host: dbvlin822.dbvisit.co.nz, SMTP: No, SNMP: No 2: APPLY on dtrg Host: dbvlin823.dbvisit.co.nz, SMTP: No, SNMP: No 3: MINE1 on dsrc Not used, work done by MINE. 4: APPLY1 on trg11g Host: dbvlin821.dbvisit.co.nz, SMTP: No, SNMP: No

Finish setup wizard.

This will generate new all.sh, onetime.ddc, setup.dbvrep. Do not run the newly generated all.sh yet!

5. Edit the new all.sh -> it should contain only configuration of 3rd db (i.e. TRG11G). 

6. Edit newly generated onetime.ddc - below is actual content. 

 

7. Edit setup.dbvrep - below is actual file.

8. Once all the 3 files are modified correctly, run the modified all.sh. Make sure there are no errors.

9. Run APPLY1.sh

10) NB : On MINE, start the console (make sure all processes are still down).

These parameters are key in making this setup work properly - map mine and apply processes

 Show the unique id for the processes

 Set the unique id for APPLY1

 Show the unique id for the processes, now includes APPLY1

11) Start MINE, APPLY, APPLY1

12) Start console on MINE again and make sure the parameters are set correctly. 

Below are the parameters to take note of. 

Console :