Versions Compared

Key

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

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

...

Specify the number of seconds you would like to set if the network has a timeout.

Lock and copy the data initially one-by-one or at a single SCN? (one-by-one/single-scn/ddl-only/resetlogs/no-lock)

Defines how the tables will instantiated. This specifies which SCN to use to define the starting point. The options are:

  • 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. 
  • no-lock : Do not lock tables. Captures previous SCN of oldest active transaction. Requires pre-requisite running of pre-all.sh script

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)

...