...
| No Format | ||
|---|---|---|
| ||
Step 1 - Describe databases ======================================== The first step is to describe databases used in the replication. There are usually two of them (source and target); however, there can be just one (when source and target is the same) or more than two (one-to-many or other complex configurations.) Following databases are now configured: 1: Oracle orcl, SYS/**, SYSTEM/*, dbvrep/**, USERS/TEMP, dbvrep/, ASM:YES,TZ: +00:00 2: Oracle test11202, SYS/**, SYSTEM/*, dbvrep/**, USERS/TEMP, dbvrep/, ASM:NO,TZ: +00:00 3: Oracle dbvisit210_d112f, SYS/**, SYSTEM/*, dbvrep/**, USERS/TEMP, dbvrep/, ASM:NO,TZ: +00:00 Enter number of database to modify it, or "add", or "done": [done] |
...
| No Format | ||
|---|---|---|
| ||
Step 2 - Replication pairs ======================================== The second step is to set source and targets for each replication pair. This is usually just choosing the first database as source and the second one as target, but many more configurations are possible. Following replication pairs are now configured: Following replication pairs are now configured: 1: orcl (Oracle) ==> test11202 (Oracle), DDL: yes, fetcher: no, process suffix: (no suffix), compression: no, encryption: no, network timeout: LAN 60, prepare type: single-scn, data load: dp_networklink 2: orcl (Oracle) ==> dbvisit210_d112f (Oracle), DDL: yes, fetcher: no, process suffix: (no suffix), compression: 1no, encryption: no, network: LAN timeout: 60, prepare type: single-scn, data load: dp_networklink Enter number of replication pair to modify it, or "add", or "done": [done] |
...
| No Format | ||
|---|---|---|
| ||
Step 4 - Process configuration ===Following processes are defined: 1: MINE on orcl Host: rac11202node1, SMTP: YES, SNMP: NO 2: APPLY on test11202 Host: dbvisit400, SMTP: YES, SNMP: NO 3: MINE1 on orcl Not used, work done by MINE. 4: APPLY1 on dbvisit210_d112f Host: dbvisit210, SMTP: YES, SNMP: NO Enter number of process to modify it, or "done": [done] |
...
| Note |
|---|
Note that the MINE process MINE is shared for both the APPLY processes APPLY and APPLY1. The process MINE1 is not used because it is more efficient to only use 1 MINE process (MINE) for all the target databases. |