[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 370
  • Last Modified:

How to cleanup/resume two-way Oracle replication after failures=16 or 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
jl66
Asked:
jl66
  • 2
2 Solutions
 
fluglashCommented:
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
 
jl66Author Commented:
how to do that? can you throw some idea?
0
 
fluglashCommented:
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

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now