Page Comparison

The pre-requisites have been completed. The replication can now be started.

1. On the source server (dbv01) , as oracle, in the $HOME/replicate directory, start the Mine MINE process.

No Format
cd ~oracle/dbvrep_orcl/replicate

No Format

[oracle@source replicate]$ ./dbvrep_orclreplicate-run-source.sh
Initializing......done
DDC loaded from database (312399 variables).
Dbvisit Replicate version 2.68.00.3735
Copyright (C) Dbvisit Software Limited.  All rights reserved.
DDC file /homeu01/app/oracle/dbvrep_orcl/dbvrep_orclreplicate/replicate-MINE.ddc loaded.
Starting process MINE...Created directory /u01/homeapp/oracle/dbvrep_orclreplicate/ddc_backup
Created directory /u01/homeapp/oracle/dbvrep_orclreplicate/log/trace/
Created directory /homeu01/app/oracle/dbvrep_orclreplicate/mine/
started

...


[oracle@source replicate]$

2. On the target server (dbv02) , start the Apply APPLY process.

No Format
cd ~oracle/dbvrep_orcl/replicate

No Format

[oracle@target replicate]$ ./dbvrep_orclreplicate-run-target.sh 
Initializing......done
DDC loaded from database (312400 variables).
Dbvisit Replicate version 2.68.00.3735
Copyright (C) Dbvisit Software Limited.  All rights reserved.
DDC file /u01/homeapp/oracle/dbvrep_orcl/dbvrep_orclreplicate/replicate-APPLY.ddc loaded.
Starting process APPLY...Created directory /u01/homeapp/oracle/dbvrep_orclreplicate/ddc_backup
Created directory /homeu01/app/oracle/dbvrep_orclreplicate/log/
Created directory /u01/homeapp/oracle/dbvrep_orclreplicate/log/trace/
Created directory /u01/homeapp/oracle/dbvrep_orclreplicate/apply
started


[oracle@target replicate]$

3. On the source server (dbv01) , as oracle, in the $HOME/replicate directory, execute the start-console.sh script to start the Replication console to and view the replication.

No Format

[oracle@source replicate]$ ./start-console.sh

Initializing......done
DDC loaded from database (315400 variables).
Dbvisit Replicate version 2.68.00.3735
Copyright (C) Dbvisit Software Limited.  All rights reserved.

...

4. The console will be displayed. Please leave the Replication console open as it is used in the following stages.

No Format

/ Dbvisit Replicate 2.68.00.3735(MAX edition) - Evaluation License expires in 30 days
MINE ISis running. Currently at plog 71523 and SCN 14575993581413 (1205/2825/20132017 2000:2529:3649).
APPLY ISis running, initialization NOT yet complete. Currently at plog 71022 and SCN 14491060 (12/28/2013 19:32:36)....
Progress of replication dbvrep_orclreplicate:MINE->APPLY: total/this execution (stale)
--------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------
0 tables listed.

                                   dbvrep>

Note

The message "initialization NOT yet complete" is shown during the start of the replication process. This process involves Dbvisit Replicate replicating its own internal tables before replicating user tables. To show the internal tables being replicated type the command list progress all at the dbvrep> prompt
No tables are shown yet. The replicated tables will only be shown once DML is run against these tables.
The cls command will clear the screen.

Replication's a bit boring without anything happening, so let's generate some activity in the source database and see what happens.

Versions Compared

Old Version 6

New Version Current

Key