Re: rman equivalent of sqlplus whenever error instruction

From: Howard Latham <>
Date: Mon, 11 Oct 2010 13:25:29 +0100
Message-ID: <>

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 <> 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
> --

Howard A. Latham

Sent from my Nokia N97
Received on Mon Oct 11 2010 - 07:25:29 CDT

Original text of this message