Anuroop Challa

Shareplex : script to check number of sachems under replication(run from source db) ===================================================== select distinct owner from SPLEX_ADM.shareplex_objmap s, dba_objects o where s.objid = o.object_id ;

Shareplex : How to check number objects in replication using sql form source. =========================================================== run from source database and plz note chekc and change shareplex admin schema name as per ur environment. =========================================================== select owner, object_name, objid from SPLEX_ADM.shareplex_objmap s, dba_objects o where s.objid = o.object_id order by owner, object_name;

Shareplex : How to check number of table replicating from particular schema ======================================================== in my environ ment admin shema name of shareplex was SPLEX_ADM(if different in your env plz change script) ------------------------------------------------------------------------------------------------------------------ select count(*) from ( select owner, object_name, objid from SPLEX_ADM.shareplex_objmap s, dba_objects o where s.objid = o.object_id and owner = '< Source_schemaname >' order by owner, object_name);

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_ct...

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

How shareplex works/ just little text about shareplex the below content has been gather form shareplex documents Hope it helps for learners. ===================================================================== How SharePlex works ================================================= SharePlex replicates data using a set of replication processes; Capture, Read, Export, Import and post. These processes start automatically, as they are needed, but they can be controlled with commands as well.  Let us discuss these processes to understand how SharePlex replication actually works. Capture Process: ---------------- The Capture process reads the redo logs or archive logs on the source systems for changes to objects. Capture writes the data to the capture queue where it accumulates until the next SharePlex process is ready for it. There is a separate Capture process for each data source being replicated. Read Process: -----------  The Read process operates on the sourc...