Check the disk capacity for the archive log destination. Bonnie Finke
-----Original Message----- Cullen Sent: Monday, June 02, 2003 9:20 AM To: Multiple recipients of list ORACLE-L 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: Bonnie Finke INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).