Re: RMAN Functionality Question

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_at_gmail.com> 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
>
>
>

-- 

*--*
*BR*
*Sumit Tyagi*
*+91-7829543355*

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