Versions Compared

Old Version 22

changes.mady.by.user Arjen Visser

Saved on

compared with

New Version 23

changes.mady.by.user Arjen Visser

Saved on

Key

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

...

Note

TIP 4

There are many settings and configurations possible with Dbvisit Replicate. To see all the settings type: "show all"

For example, to see all the settings regarding notifications:

No Format
dbvrep> show notify                                                                                                                          
*.NOTIFY_ALERT_EMAIL = OFF
*.NOTIFY_ALL_EMAIL = OFF
*.NOTIFY_CONFLICT_CURRENT_PAUSE = YES
*.NOTIFY_CONFLICT_CURRENT_RETRY = 2
*.NOTIFY_CONFLICT_THRESHOLD = 100
*.NOTIFY_DAILY_LIST_PROGRESS_TIME24 = 0700
*.NOTIFY_EXCEEDED_CYCLE_NUM = 2
*.NOTIFY_INCIDENT_LIMIT = 10
*.NOTIFY_INTERVAL_BETWEEN_CHECK = 5m
*.NOTIFY_ON_DDL = YES
*.NOTIFY_PEER_DOWN = ALL
*.NOTIFY_PROGRESS_DIFFERENCE_PERC = 10
*.NOTIFY_SCN_DIFFERENCE = 1000
*.NOTIFY_SEND_HEARTBEAT_TIME24 = 0800:1300
*.NOTIFY_SEQUENCE_DIFFERENCE = 10
*.NOTIFY_SUCCESS_EMAIL = OFF
*.NOTIFY_TIME_DIFFERENCE = 300

Confirm the data is replicated

To confirm that the data is replicated the following query can be run on both the source and the target database.

1. Connect to the source database.

No Format
sqlplus oe/oe@ttorcl_src

Run the query.

No Format
SQL> select to_char(sum(order_total),'$999,999,999,999.00') "Total Orders" from orders;
 
Total Orders
--------------------
$7,317,074,993.00

2. Connect to the target database.

No Format
sqlplus oe/oe@ttorcl_trg

Run the query.

No Format
SQL> select to_char(sum(order_total),'$999,999,999,999.00') "Total Orders" from orders;
 
Total Orders
--------------------
$7,317,074,993.00
Note

This query should give the approximately the same number on the source and target database when the replication is < 100%.

Run the queries several times to see that the numbers are updating on both the source and target database. 

If the replication is at 100% then the numbers will be the same.