Re: rman equivalent of sqlplus whenever error instruction

  • From: Howard Latham <howard.latham@xxxxxxxxx>
  • To: pjhoraclel@xxxxxxxxx
  • Date: Mon, 11 Oct 2010 13:25:29 +0100

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@xxxxxxxxx> 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
> --
> //www.freelists.org/webpage/oracle-l
>
>
>


-- 
Howard A. Latham

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


Other related posts: