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