Improve company productivity with a Business Account.Sign Up

x
?
Solved

How to cleanup/resume two-way Oracle replication after failures=16 or 19?

Posted on 2009-07-15
3
Medium Priority
?
371 Views
Last Modified: 2013-12-19
Have two sites: master and snapshot. There is a table TableA in master site and its snapshot is in snapshot site. It's a two-way replication. The snapshot is updatable. In snapshot site I check dba_jobs and found out the failures for the snapshot of TableA is 16. How to cleanup the failure status and resume operations?  
0
Comment
Question by:jl66
  • 2
3 Comments
 
LVL 7

Assisted Solution

by:fluglash
fluglash earned 2000 total points
ID: 24866814
use DBMS_JOB package.

you also can create a job that will periodicaly check replication job to kick them back to work if they are broken
0
 

Author Comment

by:jl66
ID: 24869177
how to do that? can you throw some idea?
0
 
LVL 7

Accepted Solution

by:
fluglash earned 2000 total points
ID: 24876249
something like:

declare
x binary_integer;
begin
DBMS_JOB.submit(job => x,what=>'dbms_job.broken(job => YOUR_BROKEN_JOB_ID, broken=>FALSE);',next_date => sysdate ,interval => sysdate+10/1440');
end;

for more info on DBMS_JOB package check roacle documentation:
http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_job.htm#BABBICAJ
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question