Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 

BTS10200- How to verify db mismatch between A side and B side of EMS

Here is the step :

su - oracle

dbadm -C db

...........

.......

....

Number of tables to be checked: 195
Number of tables checked OK:    195
Number of tables out-of-sync:   0

If there were out-of-sync tables then the prosecure to fix it:

1- Login to EMS side that has bad data :

su - oracle
dbadm -A copy -o <OWNER> -t <TABEL NAME>

2- Let's say the out-of-sync table is subscriber_feature_data. Then command should be :

dbadm –A copy –o opticall –t subscriber_feature_data

3- To check replication status :

su - oracle

dbadm –C rep

OPTICAL2::Deftrandest is empty?           YES

OPTICAL2::dba_repcatlog is empty?       YES

OPTICAL2::Deferror is empty?              YES ßMake sure it is “YES”

OPTICAL2::Deftran is empty?                  YES

OPTICAL2::Has no broken job?               YES

OPTICAL2::JQ Lock is empty?                YES

OPTICAL1::Deftrandest is empty?          YES

OPTICAL1::dba_repcatlog is empty?      YES

OPTICAL1::Deferror is empty?             YES ßMake sure it is “YES”

OPTICAL1::Deftran is empty?                YES

OPTICAL1::Has no broken job?              YES

OPTICAL1::JQ Lock is empty?               YES

If "DeferroR is emty?" value is NO then follow this steps:

1-

ssh root@EMS-B

su - oracle

dbadm -A truncate_defferor

2-

ssh root@EMS-A

su - oracle

dbadm -A truncate_defferor

3- Verify again with dbadm -C rep that problem has been resolved.

Version history
Revision #:
1 of 1
Last update:
‎05-03-2010 05:46 AM
Updated by:
 
Labels (1)
Everyone's tags (6)