RE: How rman delete obsolete NOT delete archivelogs.
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-lReceived on Wed Mar 17 2010 - 10:34:51 CDT