Switch logfile hangs

[engiri]

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

[Thomasps]

How big is the log file? And what is Checkpoint Interval..?

[davey23uk]

and define hanging

[engiri]

Logfile size is 200mb, 4 groups of 2 members,
Wait on--- switch logfile command.

[SANJAY_G]

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?

[Thomasps]

http://www.ixora.com.au/q+a/0012/18102646.htm

[engiri]

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

[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.

[Thomasps]

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..?

[engiri]

If I give manual checkpoint, the hanging session completes with switch logfile command.