Re: RMAN delete obsolete
- From: David Barbour <david.barbour1@xxxxxxxxx>
- To: wellmetus@xxxxxxxxx
- Date: Mon, 14 Dec 2009 17:35:59 -0500
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@xxxxxxxxx> 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@xxxxxxxxxxx>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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
>> *En nombre de *Roger Xu
>> *Enviado el:* lunes, 14 de diciembre de 2009 18:19
>> *Para:* oracle-l@xxxxxxxxxxxxx
>> *Asunto:* RMAN delete obsolete
>>
>>
>>
>> Does anybody know how to make RMAN (delete obsolete) only deletes
>> backupsets only (not archived log files)? Thank, Roger
>>
>>
>>
>
Other related posts:
