Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: question concerning backup, archive logs and recovery

Re: question concerning backup, archive logs and recovery

From: Myron Wintonyk <Myron.Wintonyk_at_UAlberta.ca>
Date: Mon, 2 Apr 2001 09:15:25 +1000
Message-ID: <9a8cvv$r6u$1@kraken.itc.gu.edu.au>

Always look at what the application is doing. Would the second application produce any significant amount of redo? If you're using exports, I'd guess the
answer may be no. In which case, there may not be a conflict (even though the DB is running archive log mode). I'm sure you know, but just to reiterate, EVERY application is different.

Sticking to the question, the answer is no. However, as one person indicated, you can turn off logging (for certain certain DML). If this causes a problem, then there may be a need to seperate the applications. In an ideal world, you would run the applications in seperate databases (and on seperate servers). This may however, not be an option, and/or the consequences of running them in a single DB may not be severe.

So, if the original poster is still unclear as to what to do, perhaps they could provide further information.

> > This reason, that we are talking about, is not a good example to change
> > database.
> >
>
> Excuse me? One application doesn't need redo, but the other one does?
 And
> that doesn't qualify, according to you? You're stark, staring bonkers if
> you believe that. The redo subsystem is the absolute key to good
> performance. Knacker that, and you knacker the application. And ARCH
> churning away when it doesn't need to sounds like a good case of
 application
> knackering to me.
Received on Sun Apr 01 2001 - 18:15:25 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US