RE: How rman delete obsolete NOT delete archivelogs.

From: Juan Miranda <>
Date: Wed, 17 Mar 2010 16:34:51 +0100
Message-ID: <7403587965544426B44E5F0520EA8113_at_portj>



We have standby databases and we donīt want to re-configure standbys if the WAN is going down during 2 days and the archivelogs was deleted.

So we need to have more archivelogs on production server but canīt have 5 days of backups on disk because space constraints.  

We have 9i and there is not configure archivelog deletion policy to applied on standby;

We do backup everyday. First to disk and then copy it to tape.  


We have older backups on tape so we can use and old backup and apply archivelogs to made point in time recovery.  


De: [] En nombre de Guillermo Alan Bort
Enviado el: miércoles, 17 de marzo de 2010 13:27 Para:
CC: Juan Cruz Miranda Vigo; Asunto: Re: How rman delete obsolete NOT delete archivelogs.  

you can't do it automatically. Oracle considers RETENTION WINDOW and REDUNDANCY as mutually exclusive policies. You could handle it through tags, but I don't think that would be easy. Do you have a tape backup infrastructure? why do you need both five days and 2 backups? it doesn't make sense to me. How often do you run backup? Alan.-

On Wed, Mar 17, 2010 at 8:43 AM, LS Cheng <> wrote:

Not sure if I understand correctly but cant you change the retention policy just before the deleting and changed it back afterwards?

On Wed, Mar 17, 2010 at 11:59 AM, Juan Miranda <> wrote:


I need to have 2 backups and 5 days of archivelogs on disk.  

RMAN “delete noprompt force obsolete” delete backups and archivelogs.  

Retention policy to redundancy 2;  

I canīt use

DELETE BACKUP COMPLETED BEFORE 'SYSDATE-3' DEVICE TYPE DISK; DELETE ARCHIVELOG UNTIL TIME 'SYSDATE-7'; because itīs time based and I need to have always 2 backup copies on disk.  

Any way to do it?  


Received on Wed Mar 17 2010 - 10:34:51 CDT

Original text of this message