Shulou(Shulou.com)06/01 Report--

This error was found in the alert log when doing daily inspection

Thread 1 cannot allocate new log, sequence 319708

Checkpoint not complete

This is actually a common mistake. Generally speaking, this is because the log group will be switched when the log is full. At this time, a checkpoint will be triggered. DBWR will write dirty blocks in memory to the data file. As long as the write is not finished, the log group will not be released. If archive mode is enabled, it is accompanied by ARCH writing archive. If redo logs are generated too quickly, when CPK or archiving is not completed, LGWR has filled up the rest of the log group and wants to write redo logs to the current log group, this time conflicts will occur and the database will be suspended. And always write error messages similar to the above in alert.log.

ORACCLE's recommendations are:

Add additional log group

Increase size of redo logs

#########################################################

select * from v$log;

select bytes/1024/1024 from v$log;

select * from v$logfile;

#Check the status of log groups and log files with the above command

#Add 3 new log groups

alter database add logfile group 4 '/u01/app/oradata/destdb/destdb/redo04.log' size 300m;

alter database add logfile group 5 '/u01/app/oradata/destdb/destdb/redo05.log' size 300m;

alter database add logfile group 6 '/u01/app/oradata/destdb/destdb/redo06.log' size 300m;

#Switch the status of the newly added log group to "not used" and the log group to be deleted to "unused" by executing the following command

alter system switch logfile;

#Delete old log groups. When adding log groups online, delete log groups only if the log group status is INACTIVE.

alter database drop logfile group 1;

alter database drop logfile group 2;

alter database drop logfile group 3;

#Finally go to OS to delete physical files of old log group

Delete/u01/app/oradata/destdb/destdb/redo01, 02, 03.log

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.