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 -----------------------------------------------------------------