Re: RMAN questions

Unfortunately, the DELETE OBSOLETE commands in 9i require you to configure a retention policy of which I personally don't like. We use RMAN in conjunction with Legato and the Legato Module for Oracle so that we can back up to an automated tape library system. In our Legato tape library system, we have a retention period of 90 days. After 90 days, the file is no longer available in the system. RMAN's retention policy doesn't exactly work the same way. About the closest one can come to, IIRC, is to specify that one needs no more than 90 days of archived redo logs to apply recovery (by specifying the RECOVERY WINDOW). The other retention policy is to specify the REDUDANCY. Personally, I wish that they'd just let me remove stuff that is 90 days or older. And why do I have to perform a crosscheck? Shouldn't I have to power to just remove a backup set if I deem it is no longer necessary?

Just my troubles....
Brian

Dave Hau wrote:
>
> bcjm wrote:
> > Brian Peasland <oracle_dba_at_remove_spam.peasland.com> wrote in message news:<3EF9B505.5BDA4D0F_at_remove_spam.peasland.com>...
> >
> >>Have a look at the following files:
> >>
> >>$ORACLE_HOME/rdbms/demo/rman1.sh
> >>$ORACLE_HOME/rdbms/demo/rman2.sh
> >>
> >>HTH,
> >>Brian
> >>
> >
> >
> > You would think Oracle should have the command available to delete the
> > backuppiece instead of making us to build it on the fly. Not everyone
> > is running on Unix. Window DOS scripting does not take "<<" command
> > if I am not mistaken.
>
> You're right. That's why in 9i, Oracle added the command DELETE
> OBSOLETE to rman. You only need to use the above scripts in 8i, not 9i.
>
> Cheers,
> Dave

-- 
===================================================================

Brian Peasland
oracle_dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"