Can we use an existing Dbvisit Standby database as a source for a Replicate target database?
Yes! With Dbvisit Standby version 7.0.30 and higher you can read standby archive logs to move data to a target database.
Note: for this example the Standby database & the Replicate target co-exist on same host.
Tnsnames.ora on this server has an entry for a primary database that it will use to connect to for metadata (
dbvrep) table updates.
Install the same version of Replicate Software on primary, standby & target hosts.
dbvrepsetup wizard on the primary server and define what you want to replicate.
-all.batfor Windows) script on the primary source DB.
Instantiate the target from primary with
APPLY.shor whatever is advised by the
tnsnames.oraentry may be needed on primary to connect to the target database for this step. Please refer to the User Guide.
*.shover to the target host. Include
Note: in this example both MINE & APPLY run on the target host which is the same as the Standby host.
Start up the console from the target host & change/set the following:
dbvrep> set REDO_READ_METHOD=ARCHONLY
dbvrep> set MINE.MINE_REMOTE_INTERFACE = <IP or Name\_ofYour\_StandbyHost>:7901 , ie dbvtarget:7901
dbvrep> set MINE_ARCH_DEST = <path to Dbvisit Standby archive logs directory on standby DB>
dbvrep> set MINE_ARCH_DEST_FORMAT = %t_%s_%r.arc -- make sure that default format has not been changed
Add rows to user/password
$ dbvisit <DDC>to ship logs on Primary.
$dbvisit <DDC>to APPLY logs on Standby.
Start MINE & APPLY processes on target host.
Verify that new rows are added on the target database.
Donna Zehl January 22, 2015 04:16