Re: Snapshot: what happens if one computer is inactive?

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Fri, 23 Jul 1999 20:59:07 +0200
Message-ID: <932756331.2380.0.pluto.d4ee154e@news.demon.nl>

Hi Nicolas,
Snapshots are being processed by dbms_job calls. This means the job will be resubmitted automatically if it fails.
This process will repeat itself 16 times, after that the job is considered broken. If the source site is down, the snapshot refresh will fail of course. You could always refresh the snapshots manually by running dbms_snapshot.refresh_all.
You could restart the job by issuing
dbms_job.broken(<job number>, false, sysdate)

Hth,

Sybrand Bakker, Oracle DBA

Nicolas Bronke <news_at_TRINITY.de> wrote in message news:3798883b_at_news.uk.ibm.net...
> I am not sure about the behaviour of my automatic snapshots. It works
fine.
> But what happens if one of the instance is inactive (not available) at the
> snapshot time?
> Does the refresh starts again if both instances are active again? Or how
can
> I reinitiate the refresh?
>
> And how can a user reinitiate a refresh between the normal refreh period?
>
> Thanks for any help.
>
> Kind regards
> Nicolas Bronke
>
>
Received on Fri Jul 23 1999 - 13:59:07 CDT