RE: RMAN - Not reporting backups

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_at_gmail.com] Sent: Tuesday, August 16, 2005 9:43 AM
To: Smith, Ron L.
Cc: oracle-l_at_freelists.org
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_at_kmg.com> 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_at_gmail.com]
> Sent: Tuesday, August 16, 2005 9:19 AM
> To: Smith, Ron L.
> Cc: oracle-l_at_freelists.org
> 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_at_kmg.com> 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.

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