Database Administration (MOSC)

MOSC Banner

Thread 1 cannot allocate new log, sequence 639472, Checkpoint not complete

edited Apr 7, 2022 2:35PM in Database Administration (MOSC) 2 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center