I have many Oracle instances (8i) that I back up with RMAN. Most of them are on unix. Each time a backup is finished, I send a email to let me know the backup is finished. So, I have about 30 emails each morning. I was wondering if there were a script somewhere already written to query the rman database directly (not the catalog) to retreive the information I want (like last backup of all my database with the exit status) so I would have only one email! If it does not exist yet, do you know wich tables we can query to get the exit status of the backup. The only information I have is the command list or report of the rman utility.

Thanks for the help.