Re: RMAN delete obsolete
Date: Mon, 14 Dec 2009 16:47:37 -0600
Message-ID: <eb64345d0912141447g25f41f09gb0c9c34f9119c45f_at_mail.gmail.com>
It's the policy. We do not have enough disk space but previous backupset files are assumed to have been backed up to tape. ( I understand that by "delete obsolete", we may have to re-catalog deleted backupsets later.) I wish it's UNIX or LINUX where I can easily use find command to delete old backupset files. Does anyone know how to delete files older than 14 days in DOS without installing any other 3rd party utility? Thanks.
On Mon, Dec 14, 2009 at 4:35 PM, David Barbour <david.barbour1_at_gmail.com>wrote:
> 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-lReceived on Mon Dec 14 2009 - 16:47:37 CST