Re: Simple RMAN question

On Tue, 29 Mar 2005 11:53:45 -0500, Ruth Gramolini <rgramolini_at_tax.state.vt.us> wrote:
> Just delete the backups using the OS delete. The backup will stay in the
> catalog (or controlfile) until the window is passed. Do not delete it from
> the catalog or using rman.
>
> HTH,
> Ruth
>
> p.s, We used to do just exactly this. Now we just do a level 0 every nite.
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of
> JayMiller_at_TDWaterhouse.com
> Sent: Tuesday, March 29, 2005 11:44 AM
> To: oracle-l_at_freelists.org
> Subject: Simple RMAN question
>
> Okay, I know there must be a way to do this but none of us here are very
> experienced at RMAN and I haven't found it in my documentation searches.
>
> We want to do a level 0 backup once a week and incremental backups daily on
> one of our databases. We backup to disk and then copy the backups to tape.
>
> In order to conserve space we'd like to delete the level 0 backup but when
> we do that the validation of the incremental backup fails. Is there any way
> around this?
>
> Thanks,
> Jay Miller
> --
> http://www.freelists.org/webpage/oracle-l
>
> --
> http://www.freelists.org/webpage/oracle-l
>

Hi,

After the OS deletion, you should use the command "change backup|backupset ... unavailable" for the related backup sets.

Otherwise you might loose your backups should someone run "crosscheck backup;" + "delete expired backup;"

Regards,
Jerome

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