Content Comparison

The following settings are available in "Step 2 - Replication pairs" of the setup wizard.

...

• one-by-one : This obtains a unique SCN for each table to replicate from. No locks are required on the tables.
• single-scn : This locks the tables and obtains a single SCN for all tables to replicate from. Locks are required on the tables. See Single SCN Prepare for more information.
• ddl_only : This does not obtain an SCN to replicate from. This is used when there is no initial data to be copied before the replication starts. The target tables will be empty before replication starts.
• resetlogs : This is used when a complete copy of the source database is made (for example with RMAN) and restored as a target database. When the target database is opened with a resetlogs command, then the SCN is used from the last resetlogs at the target database. It obtains the value from v$database.resetlogs at the target database. 

For more information see Creating the Starting Point (data instantiation)

What data copy script to create? (dp_networklink/dp_exp/exp/ddl_file/ddl_run/none)

...

• dp_networklink : This creates a datapump script which uses a network link connection between the source and target database. A DATABASE link needs to exist between source and target databases. The script can be run and this uses the database link to copy and load the data from the source database into the target database. 

• dp_exp : This creates a datapump script containing export and import commands for the replicated tables. An example of this is:

  Section

  Column
  width 5%

  Column

  width	95

  panel No Format

  bgColor	CCC

  echo ========================================

  
  

  
  echo EXPORT

  
  

  
  echo ========================================

  
  

  
  expdp SYSTEM/oracle@orcl dumpfile=AVI_SALES.dmp directory=DATA_PUMP_DIR flashback_scn=56898473 tables=AVI.SALES logfile=exp_AVI_SALES.log

  
  

  
  echo ========================================

  
  

  
  echo IMPORT

  
  

  
  echo ========================================

  
  

  
  impdp SYSTEM/oracle@test11202 dumpfile=AVI_SALES.dmp directory=DATA_PUMP_DIR logfile=imp_AVI_SALES.log

  The dumpfile is extracted out of the source database and imported into the target database using the TNS connection strings specified during the replication configuration. Enough space will be required on the filesystem to hold the .dmp file. 

• exp : This creates an exp/imp script containing export and import commands for the replicated tables. The export is extracted out of the source database and imported into the target database using the TNS connection strings specified during the replication configuration. Enough space will be required on the filesystem to hold the .dmp file. 
• ddl_file : This creates the DDL script (APPLY.sql) to create the table(s) in the target database. No data will be copied only the table definitions. This is useful when the CDC/Audit/BI options is chosen to create the target staging tables. 
• ddl_run : This creates the table(s) in the target database directly by Dbvisit Replicate. No data will be copied only the table definitions. This is useful when the CDC/Audit/BI options is chosen to create the target staging tables. 
• none : No script or action is taken. 

...