RE: Way to much log switching!!!

Barb
   It depends on your DW cycle of operations. We have a DW that operates on
a weekly cycle. Sunday it is loaded, Monday a lot of reports are run.
Noarchivelogmode. Sometime after the weekly load we perform a cold backup.
Worst case, we recover the cold backup then re-run the weekly load. The
input files are still available. This method might not work on a DW that is
loaded more frequently or needs to be available 24x7. It does speed up the
loads, which ensures we meet the Monday morning deadline. You are correct
that running in noarchivelog mode reduces your hot backup alternatives like
RMAN and also reduces your recovery alternatives.

Dennis Williams
DBA
Lifetouch, Inc.
dwilliams@xxxxxxxxxxxxx 
I said it "looked" clear - Riddick


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Barbara Baker
Sent: Wednesday, June 30, 2004 3:51 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: Way to much log switching!!!



Brings up a question that we are facing.

If we turn on archive logging in our warehouse, we
generate tons of archive logs during dataloads that we
probably do not need.

If we do not turn on archive logging, our options for
using RMAN are less attractive.

What are other sites doing about this dilemma??

Barb


--- DENNIS WILLIAMS <DWILLIAMS@xxxxxxxxxxxxx> wrote:
> Mark
>    Do you mean that you are filling logs every 1-2
> minutes every hour of the
> day and night, or is this some type of peak that
> occurs for a few minutes
> each day? Some sites operate their ODS in
> noarchivelogmode. Have you
> considered that? 


----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: