Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

No Format
bgColorCCC
oracle@dbvldemo102[/home/oracle/]: rman target sys/odb10g@reptest1password@reptest1 auxiliary sys/odb10g@reptest2password@reptest2
Recovery Manager: Release 11.2.0.3.0 - Production on Tue Jun 25 12:52:13 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: REPTEST1 (DBID=290605816)
connected to auxiliary database: REPTEST2 (not mounted)
RMAN> duplicate target database to reptest2 until scn 1007088;

...

No Format
bgColorCCC
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.
Let's configure the replication pair, selecting source and target.
Following databases are described:
1: reptest1 (Oracle) 
2: reptest2 (Oracle) 
Select source database: [1] 
Select target database: [2] 
Will be DDL replication enabled? (If YES, the script will grant more privileges to the Dbvisit Replicate users and enable database-wide supplemental logging): [yes] 
Use fetcher to offload the mining to a different server? (yes/no) [no] 
Would 
(NETWORK_QUALITY) - Please specify youryou like to encrypt the data across the network type (LANyes or WAN). Autoconfigures timeouts, use of compression etc. [LAN] 
Lock and copy the data no) [no]
Would you like to compress the data across the network (yes or no) [no]
How long do you want to set the network timeouts. Recommended range between 60-300 seconds [60]
Lock and copy the data initially one-by-one or at a single SCN? (one-by-one/single-scn/ddl-only/resetlogs) [single-scn] resetlogs 
What data copy script to create? (dp_networklink/dp_exp/exp/ddl_file/ddl_run/none) [none]
Following replication pairs are now configured:
1: reptest1 (Oracle) ==> reptest2 (Oracle), DDL: yes, fetcher: no, process suffix: (no suffix),
compression: no, encryption: no, network timeout: LAN60, prepare type: resetlogs, data load: none
Enter number of replication pair to modify it, or "add", or "done": [done]

...

Note
  • This will require the Mine MINE process to go back in time to start mining from the SCN starting point. You will need archivelogs available from the SCN starting point for mine MINE to process all the changes.
  • When target database creation takes a long time the Mine MINE process has to do a lot of catchup work before it can actually start to replicate the current changes.