Re: RMAN Functionality Question

=>

What I really want, is to find out if RMAN has a way to check if SBT backups are available before I delete obsolete. I envision the command would look something like this:

delete obsolete redundancy 1 device type disk backed up 1 times to SBT; <=

Hello

When you say "this happened and caused us some pain ..." can you explain what happened exactly with your backups on the tape ?

You can use the command crosscheck backupset to verify the existence of your backupset on the tape (I have never played with backup backupset RMAN's option, but logically crosscheck should work on the backupset produced by this method on the tape, you need to test it). If, for some reason, the backup is not there , it will be marked as expired so you will be alerted.
Another warning, the crosscheck on the tape could possibly take much more time than the crosscheck on the disk.

HTH Dragutin

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