I Agree with Dragutin Jastrebic.
Also take care of manitanence channel set during the check .
If you created a backup on an SBT channel, but have not configured
automatic SBT channels for this device, then you must manually allocate an
SBT channel before CROSSCHECK can check the backup .
If the default channel is SBT, then you can crosscheck both disk and SBT
backups by running CROSSCHECK with the default channel .
But if default channel is Disk it will crosscheck only disk and not tape .
On Thu, Sep 1, 2016 at 2:04 AM, Dragutin Jastrebic <orahawk@xxxxxxxxx>
wrote:
=>
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
