RE: Simple RMAN question

Question:
Since we do not have a recovery catalog, should we run "crosscheck" or "delete obsolete"? All we do now is deleting backups using OS delete.  

Thanks.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[ mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Vitalis Sent: Wednesday, March 30, 2005 5:36 AM
To: rgramolini_at_tax.state.vt.us
Cc: JayMiller_at_tdwaterhouse.com; oracle-l_at_freelists.org Subject: 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



This e-mail is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Any review, dissemination, copying, printing or other use of this e-mail by persons or entities other than the addressee is prohibited. If you have received this e-mail in error, please contact the sender immediately and delete the material. 
____________________________________________________________________
This email has been scanned for all viruses by the MessageLabs Email Security System. Any questions please call 972-721-8257 or email your request to tech_support_at_dp7uptx.com.
--
http://www.freelists.org/webpage/oracle-l