...
...
What is Data instantiation
Before data replication can start, the target database must have a copy of the database objects that are going to be replicated. It is also necessary that the data for the objects to be replicated are completely in sync at the point at which the replication starts. Replication can only keep data in sync from a certain point in time, all the data before that point in time must be replicated manually as a one off task.
...
- Everything before the SCN must be copied manually. This is the Data Instantiation and is done in this example through Oracle DataPump, but other methods are also available such as using a standby database.
- Everything after the SCN is replicated by the logical replication tool (in this case Dbvisit Replicate, but can also be Golden Gate)
Running DataPump
1. On the target server, ensure that the REPOE schema is clean. Run the following drop script to ensure that there are no OE objects. If there are then the DataPump script will fail.
...
| No Format |
|---|
SQL> @/u01/oracle/swingbench/sql/soedgdrop2.sql |
Create the Database Link
The APPLY.sh script created by the Setup Wizard for instantiating the target schema using DataPump export/import over a database link. This database link must be created for the script to work.
...
3. On the source server, start the APPLY.sh script. This script will take approximately 3 - 9 minutes to complete depending on your host machine.
| No Format |
|---|
cd ~oracle/dbvrep_XE |
...