Versions Compared

Old Version 14

changes.mady.by.user Paul Steffensen (Unlicensed)

Saved on

compared with

New Version Current

changes.mady.by.user Petr Horejs

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

1. On the source server, as oracle, in the $HOME/dbvrep_XEreplicate directory, start the MINE process.

No Format
cd ~oracle/dbvrep_XE/replicate


No Format
[oracle@source replicate]$ ./dbvrep_XEreplicate-run-source.sh
Initializing......done
DDC loaded from database (346399 variables).
Dbvisit Replicate version 2.78.00
Copyright (C) Dbvisit Software Limited.  All rights reserved.
DDC file /u01/app/oracle/dbvrep_XE/dbvrep_XEreplicate/replicate-MINE.ddc loaded.
Starting process MINE...Created directory /u01/app/oracle/dbvrep_XEreplicate/ddc_backup
Created directory /u01/app/oracle/dbvrep_XEreplicate/log/trace/
Created directory /u01/app/oracle/dbvrep_XEreplicate/mine/
started
[oracle@source replicate]$

2. On the target server, start the APPLY process.

No Format
cd ~oracle/dbvrep_XE/replicate


No Format
[oracle@target replicate]$ ./dbvrep_XEreplicate-run-target.sh
Initializing......done
DDC loaded from database (346400 variables).
Dbvisit Replicate version 2.78.00
Copyright (C) Dbvisit Software Limited.  All rights reserved.
DDC file /u01/app/oracle/dbvrep_XE/dbvrep_XEreplicate/replicate-APPLY.ddc loaded.
Starting process APPLY...Created directory /u01/app/oracle/dbvrep_XEreplicate/ddc_backup
Created directory /u01/app/oracle/dbvrep_XEreplicate/log/
Created directory /u01/app/oracle/dbvrep_XEreplicate/log/trace/
Created directory /u01/app/oracle/dbvrep_XEreplicate/apply
started
[oracle@target replicate]$

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

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

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

...

No Format
/ Dbvisit Replicate 2.78.00(MAX edition) - Evaluation License expires in 30 days
MINE ISis running. Currently at plog 13223 and SCN 3190128581413 (0805/0125/20142017 0500:5629:0749).
APPLY ISis running, initialization NOT yet complete. Currently at plog 13122 and SCN 3142985 (08/01/2014 04:46:37)....
Progress of replication dbvrep_XEreplicate:MINE->APPLY: total/this execution (stale)
--------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------
0 tables listed.
dbvrep>                                                                                                                                                                                  dbvrep>


Note
  1. 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
  2. No tables are shown yet. The replicated tables will only be shown once DML is run against these tables.
  3. The cls command will clear the screen.

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

...