RE: How rman delete obsolete NOT delete archivelogs.
- From: Juan Miranda <jcmiranda@xxxxxxxxx>
- To: "'Guillermo Alan Bort'" <cicciuxdba@xxxxxxxxx>, <Richard.Goulet@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 17 Mar 2010 16:34:51 +0100
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@xxxxxxxxx [mailto:alanbort@xxxxxxxxx] En nombre de Guillermo
Alan Bort
Enviado el: miércoles, 17 de marzo de 2010 13:27
Para: exriscer@xxxxxxxxx
CC: Juan Cruz Miranda Vigo; oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxx> 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@xxxxxxxxx> 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.
Other related posts:
