RE: Way to much log switching!!!

From: Barbara Baker <barbarabbaker_at_yahoo.com>
Date: Wed, 30 Jun 2004 13:50:37 -0700 (PDT)
Message-ID: <20040630205037.59370.qmail@web50601.mail.yahoo.com>

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_at_LIFETOUCH.COM> 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_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:49:43 CDT