monitoring rman jobs
- From: "Stephens, Chris" <chris_stephens@xxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 5 Jul 2007 09:08:27 -0500
Hello,
I'm writing a notification package to report on the success/failure of
the previous nights rman jobs. Our rman backup scripts are very simple:
Connect to target
Connect to catalog
Run {
Backup recovery area;
Backup database;
Backup archivelog all;
Backup recovery area;
}
I want to report on the success for each command. To do that I am
looking at rc_rman_status. The documentation says that
rc_rman_status.object_Type should be populated with 'DATABASE
FULL','RECOVERY_AREA', 'ARCHIVELOG' for the above commands. For 4 out
of 5 of the databases registered in the catalog I have values 'DB
FULL','RECVR AREA', and 'ARCHIVELOG'. So, it looks like the
documentation is wrong. The remaining database has nothing but null
values in this column. The exact same rman script is run for every
database.
Anybody know why that database doesn't have values populated in
object_type?
When rc_rman_status.status != 'COMPLETED' grab the (rsr_key, db_key) and
head off to rc_rman_output to email the error to myself. Anybody see an
problems with this?
Thanks for any input.
Chris
CONFIDENTIALITY NOTICE:
This message is intended for the use of the individual or entity to
which it is addressed and may contain information that is privileged,
confidential and exempt from disclosure under applicable law. If the reader of
this message is not the intended recipient or the employee or agent responsible
for delivering this message to the intended recipient, you are hereby notified
that any dissemination, distribution or copying of this communication is
strictly prohibited. If you have received this
communication in error, please notify us immediately by email reply.
Other related posts:
