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

By
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 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




Comments

Post a Comment

Popular posts from this blog

SQL Tuning Task Creation ORA-13780: SQL statement does not exist.

By
SQL Tuning Task Creation ORA-13780: SQL statement does not exist. ================================================= example:- declare  l_sql_tune_task_id  varchar2(100); begin  l_sql_tune_task_id := dbms_sqltune.create_tuning_task (         sql_id      => 'your sql_id',         scope       => dbms_sqltune.scope_comprehensive,         time_limit  => 10800,         task_name   => 'tuning task name',         description => 'tuning task description');  dbms_output.put_line('l_sql_tune_task_id: ' || l_sql_tune_task_id); end; / declare * ERROR at line 1: ORA-13780: SQL statement does not exist. ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79 ORA-06512: at "SYS.PRVT_SQLADV_INFRA", line 125 ORA-06512: at "SYS.DBMS_SQLTUNE", line 655 solution :----  SELECT SNAP_ID FROM DBA_HIST_...
Read more

Shareplex some commands

By
Shareplex some commands i will post here and update in this post with more commands later, if i provide with example so post become lengthy so please to understand. =====================================================================   sp_ctrl  :- Shareplex provides a command line utility called    'sp_ctrl'   this  sp_ctl located in  <product_directory>/bin  ($SP_HOME/bin)  , if you set profile in os level you easy redirect location. Below i will give commands run under  sp_ctrl  sp_ctrl (xxx)>   show config   ==> To check the active configuration (source side). sp_ctrl (xxx)>   show log reverse  ==> To check the log file sp_ctrl (xxx)>  show  ==>   command to displays status of the replication processes (Capture, Read, Export, Import and Post) . sp_ctrl (xxx)>  status  ==> command from sp_ctrl utility...
Read more

ORA-1092 : opitsk aborting process

By
sharing This error shown when load high from database and unix server(as we have unix type veritas cluster ) detect hang and db failover to another node. even in alertlog show only one errror and no other info(no trace file generation) trace cause so  in this case below is help to trace(generate trace file immediate when impact time by using below mentod) and raise case to vedor and upload trace file(even if you can able to trace cause from file as you can) Hanganalyze need to be collected when the situation occurs, below are the steps to perform such task.  Hanganalyze  sqlplus '/ as sysdba'  oradebug setmypid  oradebug unlimit  oradebug hanganalyze 3  -- Wait one minute before getting the second hanganalyze  oradebug hanganalyze 3  oradebug tracefile_name  exit  Thanks for the visit !  Any doubts or correction/suggestions, please comment below it helps me to improve in further posts.
Read more