RE: Thread 1 cannot allocate new log

OK.

I have 3 Log Groups (Size 8M) each with 2 logfiles.

But I can't seem to find the trace-file mentioned here ...

Oracle 7.2.3 on HP-UX 10.20

> -----Original Message-----
> From: Mark Leith [SMTP:mark_at_cool-tools.co.uk]
> Sent: Wednesday, October 04, 2000 12:00 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Thread 1 cannot allocate new log
>
> I have always been led to believe that a checkpoint once every hour is
> about
> the right interval. You can check the frequency of a checkpoint by
> checking
> the trace file in -
>
> ORACLE_HOME/RDBMS%/Trace/sidCKPT.trc
>
> This gives you the timestamps of when a checkpoint occurred, you need to
> work the rest out :)
>
> To check the size/status etc of your logs you need to look in v$log -
>
> SQL> select * from v$log;
>
> GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
> FIRST_CHANGE# FIRST_TIM
> ---------- ---------- ---------- ---------- ---------- ---
> ----------------
> ------------- ---------
> 1 1 393 1048576 1 NO INACTIVE
> 2867873 03-OCT-00
> 2 1 394 1048576 1 NO CURRENT
> 2888037 04-OCT-00
> 3 1 391 1048576 1 NO INACTIVE
> 2827725 01-OCT-00
> 4 1 392 1048576 1 NO INACTIVE
> 2847757 02-OCT-00
>
> This will also give you the current log file also. And before I get any
> messages about my logs being ridiculous - it's an empty test instance:)
>
> Cheers
>
> Mark
>
> -----Original Message-----
> Kirsten, E.C. de
> Sent: 04 October 2000 11:25
> To: Multiple recipients of list ORACLE-L
>
>
> Log_checkpoint_interval : 10000
> Log_checkpoint_timeout : 0
>
> About 3 mins between each : Thread 1 advanced to log ...
> How do I check the frequency of checkpoints ??? How do I check the size of
> the redo logs ???
>
> Sorry if I'ma sking basic questions but I'm starting a training in DBA
> tomorrow :-)
>
> > -----Original Message-----
> > From: Shevtsov, Eduard [SMTP:EShevtsov_at_flagship.ru]
> > Sent: Wednesday, October 04, 2000 10:25 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: Thread 1 cannot allocate new log
> >
> > Hi
> >
> > You should check frequence of checkpoints and switching of you redo
> logs.
> > How many redo logs do you have? What is the size of redo logs? And what
> > about parameters log_checkpoint_interval, log_checkpoint_timeout ?
> >
> >
> >
> > Ed
> >
> > >
> > >
> > > Hi,
> > >
> > > I find frequent references of a similar error in my alert.log :
> > >
> > > Thread 1 cannot allocate new log, sequence 21539
> > > Checkpoint not complete
> > >
> > > How bad is this, and what can I do about it ???
> > >
> > >
> > > Greets,
> > >
> > > Kirsten
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Weerd Kirsten, E.C. de
> > > INET: Kirsten.deWeerd_at_Oranjewoud.nl
> > >
> > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > > San Diego, California -- Public Internet access /
> > > Mailing Lists
> > > --------------------------------------------------------------------
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from). You may
> > > also send the HELP command for other information (like subscribing).
> > >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Shevtsov, Eduard
> > INET: EShevtsov_at_flagship.ru
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Weerd Kirsten, E.C. de
> INET: Kirsten.deWeerd_at_Oranjewoud.nl
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Mark Leith
> INET: mark_at_cool-tools.co.uk
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
Received on Wed Oct 04 2000 - 06:41:00 CDT