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