How to fix an “out of Sync”:repair table Shareplex replication in oracle database

How to fix an “out of Sync”:repair table Shareplex
replication in oracle database

==================================================

please first note that we have SOURCE and
TARGET i will provide commands to run with side my SOURCE and TARGET in below
for easy understanding.

Once you get notice table in replication was out of synce
by (email notifiaction if config SPM or cheking log manual let` s move on.


Note:- please note some like schema or tablename remove plz understand.


email notification ex:-(in case u set monitoring in SPM)

We
got email for table out of sync
Subject:
[SharePlex Manager] has 1 error level event(s)
apkpdods.tw-khh01.nxp.com:2222
has 1 error level event(s):
date 
 Table “SCHEMA_NAME”.”TABLE_NAME” out of
sync for queue QUEUE_NAME since date
Sent
by SharePlex Manager Rule “SharePlex Manager SYSTEM: SharePlex
Events”

(or) log check 




Target
Check
log  by:
sp_ctrl
(xxxxx)> 
show log reverse
Notice  
date s:3 Poster: ORA-00942: table or view does not exist.  (posting from
SOURCE, queue QUEUE_NAME, to TARGET) [module osp]
Error   
2015-05-21 10:56:07.184869 121149 2085451520 s:8 Table
“SCHEMA_NAME”.”TABLE_NAME” out of sync for queue
QUEUE_NAME at source rowid AAAsLNAAJAAAADnAAA: Row Not Found  (posting
from SOURCE, queue QUEUE_NAME, to TARGET)




Target
If
need to check event_log by: go to below directory
$ pwd
//filesytstem_name/SPLEX/vardir/log
Found
error
Notice   2015-05-20
17:06:23.532533 121148 2256619264 s:6 Poster: ORA-00942: table or view does
not exist.  (posting from SOURCE, queue queue_name, to Target)
[module osp]
Notice 
  s:3 Poster: ORA-00942: table or view does not
exist.  (posting from SOURCE , queue queue_name, to TARGET) [module
osp]
Error 
   s:8 Table “SCHEMA_NAME”.”TABLE_NAME” out
of sync for queue queue_name at source rowid AAAsLNAAJAAAADnAAA: Row Not
Found  (posting from source , queue apk_pcm_mpi, to target)
Target
Check out of sync by:
sp_ctrl (XXXX)> show sync
Out Of Sync status for target
Count   Details
—–  
————————————————————————————————
   
1   Table SCHEMA_NAME”.”TABLE_NAME” out
of sync for queue
queue_name since date time
sp_ctrl (xxxxx)>
 if you want check job status
you can use command  to check (repair status)




sp_ctrl (xxxxx)> repair
statu
s
Source
Repair object as out of sync by:
$ spbin
$ sp_ctrl
 *******************************************************
* SharePlex for Oracle Command
Utility
* Copyright 2014 Dell, Inc.
* ALL RIGHTS RESERVED.
* Protected by U.S. Patents:
7,461,103 and 7,065,538
*******************************************************
sp_ctrl (xxxxx)> repair source_shcema_name.table_name
  repairing 1 of 1 objects
  repair started; job id 158
sp_ctrl (xxx)>
Target
Check keep in sync ? by: (Now keep
in sync)
$ spbin
$ sp_ctrl
*******************************************************
* SharePlex for Oracle Command
Utility
* Copyright 2014 Dell, Inc.
* ALL RIGHTS RESERVED.
* Protected by U.S. Patents:
7,461,103 and 7,065,538
*******************************************************
sp_ctrl (xxxx)> show sync
Out Of Sync status for target_name
sp_ctrl (xxxxx)>
Target
Check status are running as
normal?…by
sp_ctrl (xxxxx)> status
Brief Status for target
Process         
State                            
PID     Running   Since
————— 
——————————  ——–  ——————–
Cop             
Running                          
109486  xxxxxxxxxxxx
Import          
Running                          
121958 xxxxxxxxxxxx
Post            
Running                          
121152  xxxxxxxxxxxx
Post            
Running                          
121151  1xxxxxxxxxxxx
Post            
Running                          
121150  xxxxxxxxxxxx
Post            
Running                          
121149  xxxxxxxxxxxx
Post            
Running                          
121148  1xxxxxxxxxxxx
Post            
Running               
           121147 
1xxxxxxxxxxxx
Cmd &
Ctrl      
Running                          
111214  xxxxxxxxxxxx
Post            
Running                          
121146  xxxxxxxxxxxx
Cmd &
Ctrl      
Running                          
102361  xxxxxxxxxxxx7
There are no active configuration
files

  • February 28, 2019 | 18 views
  • Comments