...
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:
| Code Blocknoformat |
|---|
MINE IS running. Currently at plog 32 and SCN 573985 (01/22/2015 23:06:56). APPLY IS running. Currently at plog 32 and SCN 573979 (01/22/2015 23:06:55) |
...
Check on target database that the row does not exist on the target:
| Code Blocknoformat | ||
|---|---|---|
| ||
select count(*) from REPOE.CARD_DETAILS where card_type='REPOE_TEST';
COUNT(*)
----------
0
|
...
Open any SQL tool, connect as repoe/repoe@TTORCL_SRC to source database and run following command:
| Code Blocknoformat | ||
|---|---|---|
| ||
REPOE@TTORCL_SRC> insert into REPOE.CARD_DETAILS (card_id, customer_id, card_type, card_number, expiry_date, is_valid, security_code) values (CARD_DETAILS_SEQ.nextval, 1287, 'REPOE_TEST', 9102450385, sysdate, 'Y', 1000 ); 1 row created. REPOE@TTORCL_SRC> commit; Commit complete. |
Now look at the dbvrep console, if the row was successfully replicated;
| Code Blocknoformat |
|---|
Progress of replication repoe:MINE->APPLY: total/this execution ------------------------------------------------------------------------------------------------------------------ REPOE.CARD_DETAILS: 100% Mine:1/1 Unrecov:0/0 Applied:1/1 Conflicts:0/0 Last:22/01/2015 23:23:54/OK ------------------------------------------------------------------------------------------------------------------ |
When we see in the console, that the row was sucessfully replicated to the target database, we should check, if it is correctly replicated. Connect to target database as user repoe/repoe and run following command:
| Code Blocknoformat | ||
|---|---|---|
| ||
select * from REPOE.CARD_DETAILS where card_type='REPOE_TEST';
CARD_ID CUSTOMER_ID CARD_TYPE CARD_NUMBER EXPIRY_DATE I SECURITY_CODE
---------- ----------- ------------------------------ ----------- ------------------ - -------------
750005 1287 REPOE_TEST 9102450385 22-JAN-15 Y 1000 |