RE: RMAN - Not reporting backups

  • From: "Smith, Ron L." <rlsmith@xxxxxxx>
  • To: "Vitalis Jerome" <vitalisman@xxxxxxxxx>
  • Date: Tue, 16 Aug 2005 09:46:21 -0500

If I do a crosscheck and delete obsolete, everything will be deleted
because there are no backups on disk.
The control has not been recreated.  The database has not been
refreshed.

Ron

-----Original Message-----
From: Vitalis Jerome [mailto:vitalisman@xxxxxxxxx] 
Sent: Tuesday, August 16, 2005 9:43 AM
To: Smith, Ron L.
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: RMAN - Not reporting backups


If you don't issue any "delete obsolete;" command, the retention policy
in your configuration is useless. And if you don't issue any "delete
backupset" (et al) or "delete obsolete specific_policy]" command, the
"list backup;" should list all backups in the control file.

Since control_file_record_keep_time is set to 21, the result is strange.
Was the control file recreated recently? Is the database refreshed
regularly (thanks to a duplication for instance)?

On 8/16/05, Smith, Ron L. <rlsmith@xxxxxxx> wrote:
> At this time we are not using Crosscheck or delete commands. The 
> reason, is that we are doing backups to disk, compressing the backups,

> and then writing them to tape.
> 
> -----Original Message-----
> From: Vitalis Jerome [mailto:vitalisman@xxxxxxxxx]
> Sent: Tuesday, August 16, 2005 9:19 AM
> To: Smith, Ron L.
> Cc: oracle-l@xxxxxxxxxxxxx
> Subject: Re: RMAN - Not reporting backups
> 
> 
> Hi
> 
> Which RMAN command/job is used to delete the backups?
> 
> On 8/16/05, Smith, Ron L. <rlsmith@xxxxxxx> wrote:
> >
> > I am running RMAN on a 9i database with the following parameters: 
> > CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 14 DAYS; and
> > control_file_record_keep_time = 21
> >
> > I have run several days of successful backups.  But when I do a list

> > backup, I only get the last backup listed.
> >
> > I am not using an RMAN catalog.
> >
> > What am I missing?
> >
> > Thanks!
> > Ron
> >
> >
> > Important Notice!
> > If you are not the intended recipient of this e-mail message, any 
> > use,
> 
> > distribution or copying of the message is prohibited. Please let me 
> > know immediately by return e-mail if you have received this message 
> > by
> 
> > mistake,  then delete the e-mail message.
> > Thank you.
>


Important Notice!!
If you are not the intended recipient of this e-mail message, any use, 
distribution or copying of the message is prohibited.
Please let me know immediately by return e-mail if you have received this 
message by mistake, then delete the e-mail message.
Thank you.
--
//www.freelists.org/webpage/oracle-l

Other related posts: