RE: How rman delete obsolete NOT delete archivelogs.
- From: "Goulet, Richard" <Richard.Goulet@xxxxxxxxxxx>
- To: "kathryn axelrod" <kat.axe@xxxxxxxxx>, <jcmiranda@xxxxxxxxx>
- Date: Thu, 18 Mar 2010 01:13:34 -0400
Also could use "delete archivelogs backed up 5 times to device type disk".
Dick Goulet
Senior Oracle DBA/NA Team Lead
PAREXEL International
________________________________
From: kathryn axelrod [mailto:kat.axe@xxxxxxxxx]
Sent: Thursday, March 18, 2010 12:52 AM
To: jcmiranda@xxxxxxxxx
Cc: Guillermo Alan Bort; Goulet, Richard; oracle-l@xxxxxxxxxxxxx
Subject: Re: How rman delete obsolete NOT delete archivelogs.
>We have older backups on tape so we can use and old backup and apply
>archivelogs to made point in time recovery.
Are you not also putting the archive logs on tape?
I would assume you are and thus wonder why you can't restore said archive logs
from tape if needed? (Along with the backups you would have to restore anyway
in order to use them).
On Wed, Mar 17, 2010 at 8:34 AM, Juan Miranda <jcmiranda@xxxxxxxxx> wrote:
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:
