Re: RMAN delete obsolete

From: Roger Xu <wellmetus_at_gmail.com>
Date: Mon, 14 Dec 2009 15:47:01 -0600
Message-ID: <eb64345d0912141347x6d42d19djbe18c344bd0f68de_at_mail.gmail.com>

Thanks for everyone's reply. Here is what I want -

• Every hour, backup archivelog files generated in the hour;
• Every night, backup the database then remove last night's backupset;
• Keep archivelog files for two weeks at log_archive_dest_1;

I thought I could delete last night's backupset via "delete obsolete" with retention policy set to redundancy 1. But it deletes archivelog files as well.

(Oracle 10g Windows 2003)
Thanks,

Roger
On Mon, Dec 14, 2009 at 12:40 PM, Juan Miranda <jmirandavigo_at_hotmail.com>wrote:

> You can´t as far I know.
>
> You can delete backups and archivelog:
>
>
>
> delete [noprompt force] backup completed before 'sysdate-(1/24)*36';
>
>
>
> delete expired backup device type sbt completed before 'sysdate-2';
>
>
>
> delete [noprompt force] archivelog all completed before 'sysdate-0.5';
>
>
>
> delete backup backed up 2 times to device type sbt;
>
>
>
>
>
>
>
> *De:* oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> *En nombre de *Roger Xu
> *Enviado el:* lunes, 14 de diciembre de 2009 18:19
> *Para:* oracle-l_at_freelists.org
> *Asunto:* RMAN delete obsolete
>
>
>
> Does anybody know how to make RMAN (delete obsolete) only deletes
> backupsets only (not archived log files)? Thank, Roger
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Dec 14 2009 - 15:47:01 CST