| 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,
20M for log files might be too small. look in the alert log file and see how often logs are switching. it could be that all four sets of logs are full, and you are waiting for the archiver process to clear a log for you. the database will hang until this process completes.
log switches should not be occurring more often than 20-30 minutes at the most. some people set their systems up for much longer intervals by creating much larger log files. I personally like them no sooner than an hour apart.
good luck.
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
Sent: Monday, June 02, 2003 10: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)
Phone: +44 (0) 1235 838151 Fax: +44 (0) 1235 838160
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: NDATFM_at_labor.state.ny.us 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:30:26 CDT
 |
 |