Re: Log switch Not taking place - db hangs

Zhu

Metalink was checked. OS logs too were checked. No issues observed.
Session wait did not show anything. Suggestion 5 is fine. But one cannot
expect the DBA to sit in front of the monitor 24x7 to type these
commands. My question is what is the cause of this so that it can be be
addressed. Earlier we had a situation where in for no apparent reason
DBMS_JOB did not fire. Later we found it was a bug in 9.2.0.1 and we
were asked to patch to 9.2.0.6 which we complied and it is working fine
now. Since i could not come up with any positive results in Metalink i
posted here.

Any useful inputs would be appreciated.

Thanks

GovindanK


On Fri, 22 Apr 2005 20:44:54 +0800, "zhu chao" <zhuchao@xxxxxxxxx> said:
> If I were you, I will check:
> 1. Metalink. See any known issues. Like necessary os patch/oracle bug.
> 2. Tusc to see what the system call lgwr/arch is doing that time.
> 3. CHeck os log to see if anything abnormal.
> 4. see v$session_wait.
> 5. try archive log stop; archive log start to try re-post the archive
>    process.
>
--
http://www.freelists.org/webpage/oracle-l

Other related posts: