Page Comparison

...

[oracle\]$ cat APPLY.sh

impdp system/xxxx@EC2_TARGET table_exists_action=TRUNCATE network_link=XX directory=DATA_PUMP_DIR flashback_scn=1229827 tables=SCOTT.EMP SCOTT.DEPT SCOTT.SALGRADE SCOTT.LOADTEST JOB_NAME=DP_EC2-TEST_0001 exclude=statistics


[oracle@]$ ./APPLY.sh
***GOT TO HERE****
Import: Release 11.2.0.2.0 - Production on Mon Sep 30 15:45:45 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Release 11.2.0.2.0 - 64bit Production
Starting "SYSTEM"."DP_C_0001":  SYSTEM/********@EC2_TARGET table_exists_action=TRUNCATE network_link=XX directory=DATA_PUMP_DIR flashback_scn=1229827 tables=SCOTT.EMP,SCOTT.DEPT, SCOTT.SALGRADE, SCOTT.LOADTEST  JOB_NAME=DP__0001 exclude=statistics
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 102.6 MB
Processing object type TABLE_EXPORT/TABLE/TABLE
. . imported "SCOTT"."EMP"                         14 rows
. . imported "SCOTT"."DEPT"                         4 rows
. . imported "SCOTT"."SALGRADE"                     5 rows
. . imported "SCOTT"."LOADTEST"                     100 rows

Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Job "DBVADMIN"."DP__0001" successfully completed at 02:46:32

...

[oracle@]$ ./TEST-EC2-run-ec2-54-82-3-111.compute-1.amazonaws.com.sh
Initializing......done
DDC loaded from database (266 variables).
Dbvisit Replicate version 2.6
Copyright (C) Dbvisit Software Limited.  All rights reserved.
DDC file /home/oracle/TEST/TEST-EC2-APPLY.ddc loaded.
Starting process APPLY...Created directory /home/oracle/TEST/ddc_backup
Created directory /home/oracle/TEST/log/
Created directory /home/oracle/TEST/log/trace/
Created directory /home/oracle/TEST/apply
started

...

Starting the Dbvisit Replicate console

The console can be started from the Mine server (source) using the “start-console.sh” script

...

Once both Mine and Apply is initialized:
 

Testing the replication

The next step is to generate some load on the source database.  This can be done using the generate_load script.  To see the status of the replicate you can open a second terminal and open the replicate console with “start-console.sh”.    Example:

While the above is running you can open the Dbvisit Replicate console and you can see the progress of the replication:\ Dbvisit Replicate 2.6.01.3880(MAX edition) - Evaluation License expires in 30 days

MINE IS running. Currently at plog 141 and SCN 4587877 (03/12/2014 05:36:19).

APPLY IS running. Currently at plog 141 and SCN 4587867 (03/12/2014 05:36:17).

Progress of replication TEST-EC2:MINE->APPLY: total/this execution

--------------------------------------------------------------------------------------------------------------------------------------------

SCOTT.DEPT:                   100%  Mine:70/70           Unrecov:0/0         Applied:70/70       Conflicts:0/0       Last:11/03/2014 15:57:08/OK

SCOTT.EMP:                    100%  Mine:1/1             Unrecov:0/0         Applied:1/1         Conflicts:0/0       Last:11/03/2014 15:58:43/OK

--------------------------------------------------------------------------------------------------------------------------------------------

Testing the replication

Insert some rows into the source tables.
 

Replication is now up and running.