Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: RMAN - Not reporting backups

Re: RMAN - Not reporting backups

From: Vitalis Jerome <vitalisman_at_gmail.com>
Date: Tue, 16 Aug 2005 16:42:43 +0200
Message-ID: <68b1285505081607424cee0aed@mail.gmail.com>


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.
>

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Aug 16 2005 - 09:44:43 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US