Tue Jan 23 18:58:20 2001
Thread 1 advanced to log sequence 1693
i'm getting error msgs in my alrt log about check point not completeinng... how can i remedy this..
add more redo logs??
Thanks in advance
Current log# 1 seq# 1693 mem# 0: DORANT\DATABASE\WHR_TEST\WHRTLOG1.DBF
Tue Jan 23 18:58:36 2001
Thread 1 advanced to log sequence 1694
Current log# 2 seq# 1694 mem# 0: D:\ORANT\DATABASE\WHR_TEST\WHRTLOG2.DBF
Tue Jan 23 18:58:51 2001
Thread 1 advanced to log sequence 1695
Current log# 3 seq# 1695 mem# 0: D:\ORANT\DATABASE\WHR_TEST\WHRTLOG3.DBF
Tue Jan 23 18:59:10 2001
Thread 1 advanced to log sequence 1696
Current log# 1 seq# 1696 mem# 0: D:\ORANT\DATABASE\WHR_TEST\WHRTLOG1.DBF
Tue Jan 23 18:59:24 2001
Thread 1 advanced to log sequence 1697
Current log# 2 seq# 1697 mem# 0: D:\ORANT\DATABASE\WHR_TEST\WHRTLOG2.DBF
Tue Jan 23 18:59:39 2001
Thread 1 cannot allocate new log, sequence 1698
Checkpoint not complete
I think your log file sizes are very small. Increase them. Also increase LOG_BUFFER size in INIT.ORA file.
log_buffer = 163840
is the current size of the log_buffer, what should i incrase it to?
How do i make my log files larger??
Thanks in advance.
Basic steps are if you have currently 3 log groups, create 3 more log groups with the desired size using
ALTER DATABASE ADD LOGFILE GROUP x
'/usr/oracle/dbs/log4ORCL.dbf' size xxM;
Shutdown database and open it in restrict mode and use the command ALTER SYSTEM SWITCH LOGFILE
and make sure the log file you are trying to drop is not having the status 'CURRENT' and drop it.
See the following metalink doc for detailed steps on how to resize your logs.
Larger values of LOG_BUFFER reduce redo log file I/O, if there is lots of trasactions in the database. You have 160K makeit double.
You can drop and recreate the on-line redo logfiles with a larger size. This should be done preferably when teh database is in restricted mode.
Before you do that you can add two more sets of redo logs and see if the message disppears.
Increase the log buffer only if you find too many allocation space requests.
you DON'T need to Shutdown the database for this.
After creating the new Bigger log groups, just switch the logfiles...check the status of the old logfiles to make sure it is in INACTIVE state and then drop it.
I have mentioned assuming there is lot activity on the database as logfiles are small and will be filled so quickly, to avoid the redo creation during the time new log groups are created. Be careful, if you are doing while the database open for users.
Make sure, you switch the logfile to the log group you create with diffrent size before attempting to drop the existing log groups and see all of the log groups you created havng status are inactive/current but not 'unused'.
Click Here to Expand Forum to Full Width