...
Running DataPump
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 SQL> @/home/oracle/swingbench/sql/soedgdrop2.sql |
2. On the target server (dbv02), setup the database link as user system
...
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
...
| Note | ||
|---|---|---|
During the import of the data, the archiver will become stuck because there will not be enough space. Run the following script a few times on the target server (dbv02) to ensure that the flash recovery area does not fill up and pause the import:
|