關閉資料庫出現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中進行了修復。