checkpoint in alert log file

[mike73]

can someone tell me why

Thread cannot allocate the new log
checkpoint is not complete


Why check point is not complete ??? What cause it and how to fix it

Thanks

[Paul H]

Your redo logs are not big enough. Drop each logfile group in turn and then recreate them. You cannot drop the active redo log., so you may have to use alter system switch logfile to switch manually. Use alter database add logfile '............' size xxxM to add the new file file. ps after you drop the logfile rename it to .sav using your OS.

[mike73]

Thanks paul

what will happen to the database if we don't fix this problem ??? will the log file corrupt in the near future ???

[marist89]

No, your database just "hangs" until it can complete the checkpoint. You will not get corrupt logs, just lousy performance.

[mike73]

since the log had only 1 group and no members, Would it help if I add the new member in there without making the redo log bigger ???

[marist89]

1 group and no members? I don't see how that is possible. Anyway, you could add more log groups to help alleviate this problem as a stop-gap measure. You will still have inadequate redo-logs, it will just take longer to get the CNC error...

[mike73]

I am sorry I misinterpret myself, 3 redo log group with no members.

[jmodic]

Originally posted by mike73
I am sorry I misinterpret myself, 3 redo log group with no members.

Misinterpretation again

Each log group allways have at least one member...