/u01/app/oracle/oradata/redo04.log
Thu Jan 14 22:12:55 2011
Thread 1 cannot allocate new log, sequence 46352
Checkpoint not complete
To Solve this Issue you Can Do More Than One Thing But All of the Solution is Simple :
Solution One :
Modify Database Parameter archive_lag_target Like This :
alter system set archive_lag_target=0 scope=both;
Solution two :
1-backup Full Database
2-Check Free Disk Space
3-Start Do the Following :
SELECT a.group#, a.member, b.bytes FROM v$logfile a, v$log b WHERE a.group# = b.group#;
select group#, status from v$log;
Now You need to Work Step by Step On Inactive Logs , and Stat Drop Them like the following :
alter database drop logfile group 1;
Re add the Log File
alter database add logfile group 1 ( ‘/Log-Name01.log‘,‘/Log-Name02.log’ ) size 75M
alter system switch logfile; / Alter System Checkpoint
Do this For The Group that you have , and rearrange them again By Adding new Group contain more than one redo log inside them
Simple !!!
Enjoy
Osama Mustafa
Technology Geek 