Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to determine the reason for snapshot autorefresh failure?

Re: How to determine the reason for snapshot autorefresh failure?

From: <jshen.cad_at_gmail.com>
Date: 30 Jan 2007 07:25:17 -0800
Message-ID: <1170170713.619792.325580@l53g2000cwa.googlegroups.com>


On 1月29日, 上午1时38分, DA Morgan <damor..._at_psoug.org> wrote:
> jshen...._at_gmail.com wrote:
> > hi,
>
> > we have a central DB which is updated frequently. there are three
> > satallite DB which much keep syncronized with central DB at 5min
> > interval. there are six tables need to be syncronized.
>
> > We have three dbms_jobs which are run every 5min. In past weeks ,
> > we experience three times of syncronization failure. But, when I
> > noticed data in satalite DB was not syncronized with central DB, I
> > run the three dbms_job manually successfully. But, satalite DB conten
> > does not updated at all. I have to rebuild snapshot and run a full
> > syncronization manually.
>
> > How could I determine why data syncronization failed ? why did
> > manual syncronization succeed with no data updated?
>
> > regards
>
> > Joe
>
> Version number?
>
> Does DBA_JOBS show failures?
> --

Oracle 8.1.7,
There is no error shown by run those jobs manually under SQL>.

Joe Received on Tue Jan 30 2007 - 09:25:17 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US