From: Toby T. Subject: Re: Redo-Log Archiv Problem Date: 2000/07/07 Message-ID: <083df312.652b9841@usw-ex0101-006.remarq.com>#1/1 References: <3965BCFD.7696861E@brocom.de> <8k4hbs$1p6lr$1@ID-6887.news.cis.dfn.de> <223d4e04.30f2d9de@usw-ex0104-032.remarq.com> <8k4k1f$1mhan$1@ID-6887.news.cis.dfn.de> Bytes: 1595 X-Originating-Host: 12.13.177.194 X-Complaints-To: wrenabuse@remarq.com X-Trace: WReNphoon3 962976777 10.0.2.6 (Fri, 07 Jul 2000 06:32:57 PDT) Organization: http://www.remarq.com: The World's Usenet/Discussions Start Here NNTP-Posting-Date: Fri, 07 Jul 2000 06:32:57 PDT Newsgroups: comp.databases.oracle.server X-Wren-Trace: eExpQUBZHlQfCUpNSjNdQEpaTlpGRixXSFVRRkZdRkJKRB5KDA9WTwAcGgcTXxEKGhcOEgJH We experienced the same sort of problem. We added redo groups and increased their size. It helped to a degree, but, was not the total answer. What we ended up finding was that our DBWR could not keep up when checkpoints were occuring freqeuntly. This was occuring mainly in our nightly batch. What we ended up doing was keeping our increased number and size of our logs and increasing the number of DBWR_IO_SLAVES in the init.ora. Perform the following query: select substr (event,1,40) "EVENT",total_timeouts "TIMEOUTS",total_waits "WAITS " from v$system_event / and look for a checkpoint incomplete statistic, I don't remember what it's called since I have not seen the stat in quite a while. If there are more in this statistic than what's in the alert log, it's a good indication that your DBWR can not keep up on checkpoints. HTH, Eric Peterson "Kathinka Diehl" wrote: > >Mark D Powell schrieb: > >> Adding another disk or stripping may be necessary. > >You are right. I have looked in an old alert-file an saw the message: > >Threat 1 cannot allocate new log, sequence 175606 >All online logs need archiving > >But that was together with the 'out of diskspace'-O/S-Error and the complete >database stops (sic!). Afer removing some archivelog-files everything went >on. > >Have a nice weekend >Kathinka > > > > ----------------------------------------------------------- Got questions? Get answers over the phone at Keen.com. Up to 100 minutes free! http://www.keen.com