RE: How rman delete obsolete NOT delete archivelogs.

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


 

Hi  

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.  

Dick:

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

Thanks  


De: alanbort_at_gmail.com [mailto:alanbort_at_gmail.com] En nombre de Guillermo Alan Bort
Enviado el: mi�rcoles, 17 de marzo de 2010 13:27 Para: exriscer_at_gmail.com
CC: Juan Cruz Miranda Vigo; oracle-l_at_freelists.org 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 <exriscer_at_gmail.com> 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 <jcmiranda_at_oesia.com> wrote:

Hi  

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?  

Thks.            

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Mar 17 2010 - 10:34:51 CDT

Original text of this message