Re: How long to keep archive logs?

You need to know how long your business may require to go back.
Once you have that double it and then keep as many archived logs as you can
without running out of disc space.
On 20 April 2010 20:31, <Mayen.Shah@xxxxxxxxxx> wrote:

>
> Janine,
>
> Short answer is "it depends".
>
> How frequently are you taking backups? At the least you must keep archived
> logs from last backup time to current time. If you take backups every week,
> you must keep archived logs for a week. Please make sure your backup is
> successful before deleting old archived logs. I have seen some one had that
> two separate jobs one for taking backup and second for deleting archived
> logs. Backup job failed, but deletion of archived logs succeeded, and this
> is when Murphy may strike.
>
> HTH
>
> - Mayen
>
>
>
>
>
> *"Janine Sisk" <janine@xxxxxxxxxx>*
> Sent by: oracle-l-bounce@xxxxxxxxxxxxx
>
> Apr 20 2010 03:07 PM
>  Please respond to
> janine@xxxxxxxxxx
>
>   To
> "oracle-l L" <oracle-l@xxxxxxxxxxxxx>
> cc
>   Subject
> How long to keep archive logs?
>
>
> Here comes another one of those extremely newbie questions...
>
> I have turned on archive logging for the first time, so of course I now
> have large archive log files piling up.
>
> I currently do my backups via the caveman begin/end backup method, because
> it works very well with Amazon EC2's snapshot feature.  I eventually plan to
> implement RMAN backups as well, but have not done it yet.
>
> I have gathered from the reading I have done that archive logs do not need
> to be kept once a backup has been taken, but I'm not sure if that applies to
> the type of backups I'm doing or if it is only true if RMAN is involved.  It
> seems logical that I would not need them;  if I needed to recover back to
> before the last snapshot, I would just restore that and be done with it.
>
> Can anyone tell me what a reasonable deletion strategy would be for these
> log files?
>
> thanks,
>
> janine
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
>
>


-- 
Howard A. Latham

Other related posts: