Re: Archive Log

lkj741_at_my-deja.com wrote:
>
> ------------------------------------------------------------------------
> --------
> My archive logs are growing everyday. It is archiving at least 3times a
> day.
> It is a new DB and log# is 3096.
> Like to know can i delete some and how often
> it should archive and is there any way it can
> be archive once a day?
> Thanks for your advice
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

You need them for recovery - for example, if you backup each night to tape, you should keep (say) 2 days worth of logs to ensure that you can recover from either the most recent or next to most recent tape.

If you never backup, you need every archive etc...

I wouldn't worry about 3 per day - many sites run 1000's per day.

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse