-
Very often I get the message in the Alert.log:
“Thread 1 cannot allocate new log, sequence 16407
Checkpoint not complete”
Are the redo logs small?
GROUP# STATUS MEMBER BYTES
------ ------- ----------------------------------------------------------------------------------
1 D:\ORANT\DATABASE\LOG1PHC1.ORA 83886080
2 D:\ORANT\DATABASE\LOG2PHC1.ORA 83886080
3 D:\ORANT\DATABASE\LOG3PHC1.ORA 83886080
log_checkpoint_interval = 85000000
log_checkpoint_timeout = 0
checkpoint_process = true
Please give your thoughts
Thank you!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|