...
Instantiate Data (Import data into AWSDB)
Start the import process
...
To import the data into the RDS database you will need to use Datapump using the database links.
The import script was created as part of the setup wizard process. You will have a file called APPLY.sh located in the /home/oracle/TEST_RDS directory. Edit this file and add the option “exclude=statistics” at the end. This will ensure you do not get any errors at the end of the import process. Once you have updated the file and as per the above instructions you have your database links in place you can execute the script from the dbvrdsrep01 server.
...
Start the Replication Processes
...
Mine Server (SOURCE)
| Code Block | ||
|---|---|---|
| ||
[oracle@dbvrds01]$ ./home/oracle/TEST_RDS/TEST_RDS-run-dbvlin210.dbvisit.co.nz.sh Initializing......done [oracle@dbvrds01 ]$ DDC loaded from database (266 variables). Dbvisit Replicate version 2.7 Copyright (C) Dbvisit Software Limited. All rights reserved. DDC file /home/oracle/TEST_RDS/TEST_RDS-MINE.ddc loaded. Starting process MINE...Created directory /home/oracle/TEST_RDS/ddc_backup Created directory /home/oracle/TEST_RDS/log/ Created directory /home/oracle/TEST_RDS/log/trace/ Created directory /home/oracle/TEST_RDS/mine/ started |
...
| Code Block | ||
|---|---|---|
| ||
[oracle@ ]$ ./home/oracle/TEST_RDS/TEST_RDS-run-ec2-54-82-47-176.compute-1.amazonaws.com.sh Initializing......done DDC loaded from database (266 variables). Dbvisit Replicate version 2.6.x Copyright (C) Dbvisit Software Limited. All rights reserved. DDC file /home/oracle/TEST_RDS/TEST_RDS-APPLY.ddc loaded. Starting process APPLY...Created directory /home/oracle/TEST_RDS/ddc_backup Created directory /home/oracle/TEST_RDS/log/ Created directory /home/oracle/TEST_RDS/log/trace/ Created directory /home/oracle/TEST_RDS/apply started |
...
Starting the Dbvisit Replicate console
...
The console can be started from the Mine server (source) using the “start-console.sh” script
...
[oracle@ ]$ ./start-console.sh
Note that the mine and apply process does take some time to initialize.
Once both Mine and Apply is initialized.
Testing the replication
...
While the above is running you can open the Dbvisit Replicate console and you can see the progress of the replication. Insert some rows into the source tables and then look in the target to see them appear there.
...