=>
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