RE: Simple RMAN question
- From: "Roger Xu" <roger_xu@xxxxxxxxxxx>
- To: <vitalisman@xxxxxxxxx>, "Oracle-L@Freelists. Org (E-mail)" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 30 Mar 2005 13:40:40 -0600
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@xxxxxxxxxxxxx
[ mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Vitalis
Sent: Wednesday, March 30, 2005 5:36 AM
To: rgramolini@xxxxxxxxxxxxxxx
Cc: JayMiller@xxxxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: Re: Simple RMAN question
On Tue, 29 Mar 2005 11:53:45 -0500, Ruth Gramolini
<rgramolini@xxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxx
> [ mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of
> JayMiller@xxxxxxxxxxxxxxxx
> Sent: Tuesday, March 29, 2005 11:44 AM
> To: oracle-l@xxxxxxxxxxxxx
> 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@xxxxxxxxxxxx
--
http://www.freelists.org/webpage/oracle-l
- Follow-Ups:
- Re: Simple RMAN question
- From: David Sharples
Other related posts:
- » Simple RMAN question
- » RE: Simple RMAN question
- » Re: Simple RMAN question
- » RE: Simple RMAN question
- » Re: Simple RMAN question
- » RE: Simple RMAN question
- Re: Simple RMAN question
- From: David Sharples