...
If everything went fine, you should see at the top of the console output that MINE and APPLY processes are running and applying changes from PLOG files:
| No Format |
|---|
MINE ISis running. Currently at plog 3229 and SCN 573985774447 (0106/2208/20152017 2321:0644:5650). APPLY ISis running. Currently at plog 3229 and SCN 573979774443 (0106/2208/20152017 2321:0644:5550). |
Lets insert some simple row and check in console, how did the replication work.
...
| No Format | ||
|---|---|---|
| ||
[oracle@source replicate]$ sqlplus repoe/repoe@TARGET
SQL> set lines 200 pages 999
SQL> select * from REPOE.CARD_DETAILS where card_type='REPOE_TEST';
CARD_ID CUSTOMER_ID CARD_TYPE CARD_NUMBER EXPIRY_DATE I SECURITY_CODE
---------- ----------- ------------------------------ ----------- ------------------ - -------------
750004 1287 REPOE_TEST 9102450385 25-MAY-17 Y 1000
|
Simple DDL operation
Let's try a bit more complex command - Create table as select:
| No Format | ||
|---|---|---|
| ||
[oracle@source replicate]$ sqlplus repoe/repoe@TARGET
REPOE@SOURCE> create table repoe.tables as select * from user_tables;
Table created.
|
See, what happened in the dbvrep console - run ./start-console.sh from $HOME/replicate directory:
| No Format | ||
|---|---|---|
| ||
/ Dbvisit Replicate 2.8.04(MAX edition) - Evaluation License expires in 30 days MINE is running. Currently at plog 33 and SCN 788527 (06/08/2017 22:08:59). APPLY is running. Currently at plog 33 and SCN 788507 (06/08/2017 22:08:54). Progress of replication replicate:MINE->APPLY: total/this execution -------------------------------------------------------------------------------------------------------------------------------------------- REPOE.CARD_DETAILS: 100% Mine:1/1 Unrecov:0/0 Applied:1/1 Conflicts:0/0 Last:08/06/2017 22:04:48/OK REPOE.TABLES: 100% Mine:11/11 Unrecov:0/0 Applied:11/11 Conflicts:0/0 Last:08/06/2017 22:08:03/OK -------------------------------------------------------------------------------------------------------------------------------------------- |
You can see, that the table was created on source and filled with 11 rows. The same table was created on target database under REPOE user and the 11 rows were successfully replicated.
You can check, if the rows were successfully replicated using following query under system user in target database:
| No Format | ||
|---|---|---|
| ||
SQL> conn system/manager@target
Connected.
select * from repoe.tables
minus
select * from repoe.tables@source
union all
select * from repoe.tables@source
minus
select * from repoe.tables
/
no rows selectedSQL> |
This query uses database link created before and checks for any rows, that are in source database and are not present in target database and vice versa. If it returns some rows, than something bad happened.