Re: rman equivalent of sqlplus whenever error instruction

From: Howard Latham <howard.latham_at_gmail.com>
Date: Mon, 11 Oct 2010 13:25:29 +0100
Message-ID: <AANLkTin+qpO8zMM69BCeiP919HV=yFYEVwsZ6UetXohO_at_mail.gmail.com>

I do a Grep on all the rman logs - for ORA- and RMAN and email if I Find any - A whenever would be good.

On 11/10/2010, Peter Hitchman <pjhoraclel_at_gmail.com> wrote:
> Hi,
> Spent a un-happy morning with various database jobs that reported that
> they failed because there was no access to the rman catalog, because
> the machine that was on went down,
> but the backup went ahead and then the job failed, causing it to be
> re-started by the scheduler because its set to do that on failure.
>
> As a result some of the backups were actually repeated, because the
> rman session could talk to TSM OK, just not the catalog.
>
> This got me to thinking, that what I would like to do in the rman
> command script, is to tell it to stop and exit if there is a
> connection error (like the whenever instruction in sqlplus),
> but I cannot find any reference on how to do this. Anybody know if
> this type of feature is available?
>
> Thanks
> Pete
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Howard A. Latham

Sent from my Nokia N97
--
http://www.freelists.org/webpage/oracle-l

Received on Mon Oct 11 2010 - 07:25:29 CDT