关闭数据库出现PMON failed to acquire latch信息

很常见的一个信息，以前并没有太在意，不过即使是这种异常信息，Oracle也认为是bug。

[@more@]

关闭数据库时，信息如下：

Tue Aug 16 15:38:06 2011
Shutting down archive processes
Tue Aug 16 15:38:11 2011
ARCH shutting down
ARC2: Archival stopped
Tue Aug 16 15:43:41 2011
Starting background process EMN0
EMN0 started with pid=28, OS id=1294500
Tue Aug 16 15:43:41 2011
Shutting down instance: further logons disabled
Tue Aug 16 15:43:41 2011
Stopping background process QMNC
Tue Aug 16 15:43:41 2011
Stopping background process CJQ0
Tue Aug 16 15:43:44 2011
Stopping background process MMNL
Tue Aug 16 15:43:45 2011
Stopping background process MMON
Tue Aug 16 15:43:46 2011
Shutting down instance (immediate)
License high water mark = 10
Tue Aug 16 15:43:46 2011
Stopping Job queue slave processes
Tue Aug 16 15:43:51 2011
Process OS id : 1474740 alive after kill
Errors in file
Tue Aug 16 15:43:51 2011
Job queue slave processes stopped
Tue Aug 16 15:44:01 2011
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
Tue Aug 16 15:44:11 2011
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
Tue Aug 16 15:44:22 2011
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
Tue Aug 16 15:44:32 2011
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
Tue Aug 16 15:44:37 2011
ALTER DATABASE CLOSE NORMAL
Tue Aug 16 15:44:37 2011
SMON: disabling tx recovery
SMON: disabling cache recovery
Tue Aug 16 15:44:37 2011
Shutting down archive processes
Archiving is disabled
Tue Aug 16 15:44:42 2011
ARCH shutting down
ARC1: Archival stopped
Tue Aug 16 15:44:47 2011
ARCH shutting down
ARC0: Archival stopped
Tue Aug 16 15:44:49 2011
Thread 1 closed at log sequence 9371
Successful close of redo thread 1
Tue Aug 16 15:44:49 2011
Completed: ALTER DATABASE CLOSE NORMAL
Tue Aug 16 15:44:49 2011
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active

Oracle在MOS文档Bug 4632780 - PMON "failed to acquire latch" during shutdown [ID 4632780.8]专门介绍了这个信息，确认影响的版本包括9.2.0.7、10.1.0.5和10.2.0.1，Oracle在9.2.0.8、10.2.0.2和11.1.0.6中进行了修复。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/4227/viewspace-1060757/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/4227/viewspace-1060757/