Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Defining Obsolete Backups in RMAN

Re: Defining Obsolete Backups in RMAN

From: <Kenneth>
Date: Fri, 20 May 2005 20:12:57 GMT
Message-ID: <428e41ad.2724125@news.inet.tele.dk>


On 20 May 2005 08:13:34 -0700, amerar_at_iwc.net wrote:

>
>We are running Oracle 8i, where retention policies are not yet
>implemented.
>
>Basically, I want to run that REPORT OBSOLETE UNTIL TIME 'SYSDATE-7';
>command, then I have written a script to parse the output and create
>the proper delete commands.
>
>I just want to make sure that the command does what I think, which is
>to report a list of backups that are outside my window, which are the
>ones I will delete.
>
>Arthur
>

It does exactly what you think it does. Period.

In fact you're lucky: The 8i online doc gives an example of just your REPORT OBSOLETE UNTIL TIME 'SYSDATE-7. Consider crosschecking your backup pieces before deleting, to ensure the recent pieces are still there, in which case deleting the older backups is safe.

crosscheck backup after 'SYSDATE-7';

Note that in case you have backups on both disk and tape, you must crosscheck these separately.

allocate channel for maintenance type disk; crosscheck backup after 'SYSDATE-7';

allocate channel for maintenance type 'sbt_tape'; crosscheck backup after 'SYSDATE-7';

Received on Fri May 20 2005 - 15:12:57 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US