| 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: cannot allocate new log
Nuala,
It looks like the DB is waiting for you to manually archive the logs. Like Lisa suggested, could you do an archive log list from the sqlplus prompt and post the results? There are two steps in setting up archiving. You have to set the proper parameters in the init.ora file, and then bring the db up in mount mode to start the archiver before you open the database.
-Scott
At 08:24 AM 6/2/03 -0800, you wrote:
>Hi Denis,
>
>Thanks for the quick reply,
>
>We're not getting an oracle error no: This is the message in the alert log
>Mon Jun 02 08:19:19 2003
>Thread 1 cannot allocate new log, sequence 711
>All online logs needed archiving
> Current log# 2 seq# 710 mem# 0: D:\ORACLE\ORADATA\GDA\GDA_21.LOG
> Current log# 2 seq# 710 mem# 1: E:\ORACLE\ORADATA\GDA\GDA_22.LOG
>
>The event log has a similar message.
>
>Our database is in archivelogmode
>log_archive_start = True
>
>Space is not an issue on the drive - there's at least 10 gigs free.
>Disk access and write permissions are ok as it seems to write some of the
>logs but then stops!
>I checked this by doing an alter system switch logfile - to force a write -
>which was successful.
>
>Any other suggestions are appreciated,
>
>N.
>
>:->-----Original Message-----
>:->From: DENNIS WILLIAMS [mailto:DWILLIAMS_at_LIFETOUCH.COM]
>:->Sent: 02 June 2003 15:37
>:->To: 'ORACLE-L_at_fatcity.com'
>:->Cc: 'ncullen_at_catlogic.com'
>:->Subject: RE: cannot allocate new log
>:->
>:->
>:->Nuala - You didn't include your error number, so the
>:->following are some
>:->guesses: Is your database in archivelogmode? Check the path
>:->to the archive
>:->logs and make sure that drive hasn't filled. For the logs
>:->themselves, check
>:->the paths and permissions.
>:->
>:->Dennis Williams
>:->DBA, 80%OCP, 100% DBA
>:->Lifetouch, Inc.
>:->dwilliams_at_lifetouch.com
>:->
>:->
>:->-----Original Message-----
>:->From: Nuala Cullen [mailto:ncullen_at_catlogic.com]
>:->Sent: Monday, June 02, 2003 9:20 AM
>:->To: Multiple recipients of list ORACLE-L
>:->Subject: cannot allocate new log
>:->
>:->
>:->
>:->Hi All,
>:->
>:->I keep getting a cannot allocate new log in the alert log.
>:->This freezes the
>:->entire application and I am unable to connect to oracle in
>:->order to do a
>:->statspack snap shot.
>:->
>:->This is an upgrade to Version 8.1.7.4 set up on a WK2000
>:->(NEW) Server with 2
>:->gigs of memory.
>:->
>:->We are writing to 3 separate disks
>:->
>:->Our D&E drives are RAID 0+1. The log files (including
>:->application logs) are
>:->written to these drives
>:->The F drive is raid 5 - this is where our data resides. (No
>:->logs are written
>:->to the F drive)
>:->
>:->Currently we have 4 groups of redo log files
>:->
>:-> group 1 ('d:\oracle\oradata\gda\gda_11.log',
>:-> 'e:\oracle\oradata\gda\gda_12.log')
>:->size 20M reuse,
>:-> group 2 ('d:\oracle\oradata\gda\gda_21.log',
>:-> 'e:\oracle\oradata\gda\gda_22.log')
>:->size 20M reuse,
>:-> group 3 ('d:\oracle\oradata\gda\gda_31.log',
>:-> 'e:\oracle\oradata\gda\gda_32.log')
>:->size 20M reuse,
>:-> group 4 ('d:\oracle\oradata\gda\gda_41.log',
>:-> 'e:\oracle\oradata\gda\gda_42.log')
>:->size 20M reuse
>:->
>:->and we archive to e:\oracle\arc\gda
>:->
>:->These are our log settings from the init.ora
>:->log_buffer = 131072
>:->log_checkpoint_interval = 100000000
>:->log_checkpoint_timeout = 0
>:->
>:->I have the performance monitor running the whole time and
>:->when this happens
>:->the CPU, DISK QUE LENGTH all look normal.
>:->I have read the archive files regarding this error but
>:->thought that the
>:->above set-up was sufficient.
>:->Can anybody *please* give me some idea of what other areas I
>:->should be
>:->looking at in order to prevent the error from occurring.
>:->Would writing smaller files help? Disk space is not an issue.
>:->
>:->Thanks - all advice appreciated,
>:->
>:->N.
>:->(developer/part-time DBA)
>:->
>:->___________________________________
>:->Nuala Cullen
>:->Catlogic
>:->30 Park Gate
>:->Milton Park
>:->Abingdon
>:->Oxfordshire
>:->OX14 4SH
>:->
>:->Phone: +44 (0) 1235 838151
>:->Fax: +44 (0) 1235 838160
>:->Direct Line: +44 (0) 1235 838147
>:->___________________________________
>:->
>:->
>:->
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Stefick INET: sstefick_at_harpercollege.edu Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).Received on Mon Jun 02 2003 - 11:49:57 CDT
 |
 |