rman equivalent of sqlplus whenever error instruction

  • From: Peter Hitchman <pjhoraclel@xxxxxxxxx>
  • To: oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 11 Oct 2010 12:59:36 +0100

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


Other related posts: