RE: rman equivalent of sqlplus whenever error instruction
- From: "Amit Verma (IT - Otterbase)" <averma@xxxxxxxxxxxxxxxxxxx>
- To: <pjhoraclel@xxxxxxxxx>, "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 11 Oct 2010 09:51:38 -0400
It is actually an RMAN feature
(http://jkstill.blogspot.com/2010/02/cool-but-unknown-rman-feature.html)
that even if there is a connection error to the catalog, the backup will
continue and use the control file instead of the catalog database. This
guarantees that you always have a backup even if catalog is not
available and once you fix the connection issues, all you need to do is
to resync the catalog or it does that automatically during next backup.
To avoid re-running the job by itself, you can do a "grep -v" on the
ORA- "that you don't want to consider as errors" and report the job as
successful to the scheduler so it doesn't re-start the job.
HTH,
-Amit Verma
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Peter Hitchman
Sent: Monday, October 11, 2010 8:00 AM
To: oracle-l
Subject: rman equivalent of sqlplus whenever error instruction
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
