| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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_at_lifetouch.com
I said it "looked" clear - Riddick
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Barbara Baker
Sent: Wednesday, June 30, 2004 3:51 PM
To: oracle-l_at_freelists.org
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
-- 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_at_freelists.org 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 -----------------------------------------------------------------Received on Wed Jun 30 2004 - 15:58:40 CDT
 |
 |