How to fix an “out of Sync”:repair table Shareplex
replication in oracle database
==================================================
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)
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.
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 queuequeue_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
status |
|
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 |
Recent Posts
