-
Switch logfile hangs
Hi
When we repeatedly give switch logfile command, DB is hanging after some 7 or 8 successful switches.
But if we give manual checkpoint, log is switching. Then again it is hanging after some 5 or 6 successful runs.
Database version 9.2.0.5
Solaris
log_checkpoint_interval 98000000
log_checkpoint_timeout 3600
log_checkpoints_to_alert TRUE
Thanks
-
How big is the log file? And what is Checkpoint Interval..?
-
-
Logfile size is 200mb, 4 groups of 2 members,
Wait on--- switch logfile command.
-
Originally Posted by davey23uk
and define hanging
Exactly. Is it taking longer or it never completes? Are you sure the delay is not because data is being written to archive log?
Sanjay G.
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
-
-
Originally Posted by SANJAY_G
Exactly. Is it taking longer or it never completes? Are you sure the delay is not because data is being written to archive log?
It never completes. The wait clearly says "Waiting on log swich command"
No. there is no data being written to the disk. I am manually giving switch log file command.
Thanks
-
pl see the destination of archive files may be the archive dest is filled up. in archive mode the database hangs till the redo is archived.
-
Originally Posted by RayaguruSD
pl see the destination of archive files may be the archive dest is filled up. in archive mode the database hangs till the redo is archived.
Read the post first.... Will the manul switch work if the archivelog destionation is full..?
-
If I give manual checkpoint, the hanging session completes with switch logfile command.
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
|