FW: monitoring rman jobs

Nevermind. The target database is a 10.1 database. That column doesn't get populated for 10.1 databases.  

Thanks!

Chris  

(just realized I didn't provide version information. Sorry about that)  

From: Stephens, Chris
Sent: Thursday, July 05, 2007 9:08 AM
To: oracle-l_at_freelists.org
Subject: monitoring rman jobs  

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.

--
http://www.freelists.org/webpage/oracle-l