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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Archive log file deletion(URGENT)

Re: Archive log file deletion(URGENT)

From: Onkar N Tiwary <onkarnath.tiwary_at_gmail.com>
Date: Tue, 17 May 2005 15:58:18 +0530
Message-ID: <a144e521050517032822a1351d@mail.gmail.com>


thanx David,
 My requirement is basically to do point in time recovery preventing as much data as possible. The second thing is wht type of backup u r talkin about. Let me put in this way:
 I have taken one cold backup on say 20th April and the next is on 5th of May. Then can I delete the archive files generated before 20th? Suppose I deleted the file on 6th May and my db crashed on 7th 10.am then will be in a position to do point in time recovery?

 On 5/17/05, David Sharples <davidsharples_at_gmail.com> wrote:
>
> Delete them if you dont need them. i.e have them backed up already.=20
> You only need the ones generated since the last backup. Or to go as
> far back as possible if you want to do point in time recovery. It
> depends on what requirements you have
>
>
> On 5/17/05, Onkar N Tiwary <onkarnath.tiwary_at_gmail.com> wrote:
> > Hey guys,
> > It may be a silly question but I wonder if i can delete my archive files
> =
> or
> > not. If yes then when and in wht circumstances? and if no then am i
> suppo=
> sed
> > to store my archive files for say a yr or two or till my db needs a
> recov=
> er?
> --
> http://www.freelists.org/webpage/oracle-l
>

-- 
Thanks & Regards,
T. Onkar Nath
Ph : +91-9826728111(Cell)
to_onkar_at_yahoo.com
onkarnath.tiwary_at_gmail.com

--
http://www.freelists.org/webpage/oracle-l
Received on Tue May 17 2005 - 06:32:55 CDT

Original text of this message

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