Versions Compared

Key

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

...

No Format
bgColorCCC
Step 2 - Replication pairs
========================================
The second step is to set source and targets for each replication pair.
Let's configure the replication pair, selecting source and target.
Following databases are described:
1: SDB11orcl_src (Oracle)  
2: TDB11orcl_tgt (Oracle)  
Select source database: [1]                                                                                                                                                   
Select target database: [2]                                                                                                                              
                    
Will be DDL replication be enabled? (Yes/No) [yes]                      Yes]                                                                           
                                      
Use fetcher to offload the mining to a different server? (yesYes/noNo) [noNo]                                                   
Should where clauses (and change auditing) include all columns, not just changed and PK?                   (Yes/No) [No]                    
Would you like to encrypt the data across the network? (yes or noYes/No) [no]           No]                                                     
                                       
Would you like to compress the data across the network? (yes or noYes/No) [noNo]                                                         
                                             
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 : Lock tables one by one and capture SCN
single-scn : One SCN for all tables
ddl-only   : Only DDL script for target objects
resetlogs  : Use SCN from last resetlogs operation  (standby activation, rman incomplete recovery) 
no-lock    : Do not lock tables. Captures previous SCN  of oldest active transaction. Requires pre-requisite running of pre-all.sh script
(one-by-one/single-scn/ddl-only/resetlogs/no-lock) [single-scn]                        
                       (one-by-one/single-scn/ddl-only/resetlogs/no-lock) [single-scn] 

What data instantiation script to create?
dp_networklink : Data Pump with network link. No export datafile is created (APPLY.sh)
dp_exp         : Data Pump with export datafile. Creates an export datafile (APPLY.sh)

exp            : Pre-datapump exp/imp with export datafile (APPLY.sh)
ddl_file       : DDL file created (APPLY.sql)
ddl_run        : DDL is automatically executed on target
load           : All replicated data is created and loaded automatically 
none                                               
                           (dp_networklink/dp_exp/exp/ddl_file/ddl_run/load/none) [dp_networklink] load

Do you want to (re-)create the tables on target or keep them (they are already created)?                                                          (create/keep) [keep]             

   (dp_networklink/dp_exp/exp/ddl_file/ddl_run/load/none) [dp_networklink] 

Following replication pairs are now configured:
1: orcl_dbvisit210src (Oracle) ==> orcl_dbvisit230tgt (Oracle), DDL: yesYes, fetcher: noNo, process suffix: (no suffix),  compression: noNo, encryption:
noNo, network timeout: 60, prepare type: single-scn, data load: dpload_networklinkkeep
Enter number of replication pair to
modify it, or "add", or "done": [done]