...
1. On the target server (dbv02), ensure that the OE schema is clean. Run the following script to ensure that there are no OE objects. If there are then the DataPump script will fail
| No Format |
|---|
sqlplus oe/oe
|
| No Format |
|---|
SQL> @/home/oracle/swingbench/sql/soedgdrop2.sql |
2. On the target server (dbv02), setup the database link as user system
| No Format |
|---|
sqlplus system/oracle
|
| No Format |
|---|
SQL> CREATE public DATABASE LINK ttorcl_src CONNECT TO system IDENTIFIED BY oracle USING 'ttorcl_src'; |
This database link is needed for the Datapump script that is created as APPLY.sh. The content of datapump script APPLY.sh is similar to:
...
The flashback_scn number (in this case 14415748) determines the consistency point as to where the data will be loaded to. All data prior to this SCN will be loaded using the above DataPump script. All data past this SCN will be replicated using Dbvisit Replicate.
3. On the source server (dbv01) start the APPLY.sh script
...