RE: archivelog performance issues

From: Johnson, William L (TEIS) <"Johnson,>
Date: Tue, 7 Jul 2009 12:59:36 -0400
Message-ID: <2F161F8A09B99B4ABF8AE832D546E78904B4FEDFBE_at_us194mx002.tycoelectronics.net>

Just don't forget to make sure you know how to backup and delete those archive logs or you will have egg on your face when you take down production once the archive log destination fills up. It is a simple process, but you need to either have some disk or a tape management system to backup the archive logs.

---

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jared Still Sent: Tuesday, July 07, 2009 12:52 PM
To: jachang_at_lanl.gov
Cc: Oracle-L Freelists
Subject: Re: archivelog performance issues

On Tue, Jul 7, 2009 at 9:06 AM, Julio Aguilar-Chang <jachang_at_lanl.gov<mailto:jachang_at_lanl.gov>> wrote: Is there a good reason based on performance for not enabling archivelog mode?

My first reaction to that is 'forget about performance'.

You should probably ask the business owners if they can afford to lose all transactions after the most recent backup.

Because at some point, all systems need to be recovered.

And if the most recent backup is corrupt, they will lose all transactions back to the previous backup.

I know how I would answer that if it were my business.

After they tell you to implement archive logging ASAP, you can monitor for performance by asking the users if performance is still acceptable.

Others have already given good advice on log sizing.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jul 07 2009 - 11:59:36 CDT