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
> --
> //www.freelists.org/webpage/oracle-l
>
> --
> //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
--
//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
--
//www.freelists.org/webpage/oracle-l

Other related posts: