Re: RMAN delete obsolete

From: David Barbour <david.barbour1_at_gmail.com>
Date: Mon, 14 Dec 2009 17:35:59 -0500
Message-ID: <69eafc3f0912141435u5033af7dp2212257d2c965f0e_at_mail.gmail.com>

Okay - I must be missing something. If you're deleting a subsequent backup, why do you want to save the prior archivelogs? Logminer?

On Mon, Dec 14, 2009 at 4:47 PM, Roger Xu <wellmetus_at_gmail.com> wrote:

> 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 - 16:35:59 CST