Thread 1 cannot allocate new log, sequence 639472, Checkpoint not complete
Today database got down. Listener control was stopped and database was not mounted. I have restarted the listener and database, now application is running well but I have found some problem in the log file related to checkpoint and afraid, it could go down anytime. Please find the attached log file and below is just a glimpse.
2022-04-07T15:22:09.341712+04:00
Thread 1 advanced to log sequence 639471 (LGWR switch)
Current log# 3 seq# 639471 mem# 0: F:\ORADATA\PRODCDB\REDO031.LOG
Current log# 3 seq# 639471 mem# 1: F:\ORADATA\PRODCDB\REDO032.LOG
2022-04-07T15:22:09.482346+04:00
Archived Log entry 639470 added for T-1.S-639470 ID 0xb5682e45 LAD:1
2022-04-07T15:22:36.342128+04:00