ORACLE数据库SHUTDOWNHANG卡住不动
主库停止的日志信息:
Thu May 11 02:07:48 2023
Shutting down instance (immediate)
Stopping background process SMCO
Shutting down instance: further logons disabled
Stopping background process CJQ0
Stopping background process MMNL
Stopping background process MMON
License high water mark = 178
Thu May 11 02:07:56 2023
Waiting for dispatcher 'D000' to shutdown
Waiting for shared server 'S000' to die
All dispatchers and shared servers shutdown
ALTER DATABASE CLOSE NORMAL
Thu May 11 02:08:06 2023
Stopping Emon pool
Thu May 11 02:08:06 2023
SMON: disabling tx recovery
Thu May 11 02:08:06 2023
Stopping Emon pool
Thu May 11 02:08:07 2023
SMON: disabling cache recovery
Shutting down archive processes
Archiving is disabled
Thu May 11 02:08:08 2023
ARCH shutting down
Thu May 11 02:08:08 2023
ARCH shutting down
Thu May 11 02:08:08 2023
ARCH shutting down
Thu May 11 02:08:08 2023
ARC2: Archival stopped
Thu May 11 02:08:08 2023
ARC0: Archival stopped
Thu May 11 02:08:08 2023
ARC3: Archival stopped
Thu May 11 02:08:08 2023
ARCH shutting down
ARC1: Archival stopped
Thu May 11 02:08:09 2023
Thread 1 closed at log sequence 287311
Successful close of redo thread 1
Thu May 11 02:08:10 2023
Buffer Cache Full DB Caching mode changing from FULL CACHING DISABLED to FULL CACHING ENABLED <<<<<<
Thu May 11 02:23:08 2023
License high water mark = 178
Thu May 11 02:23:08 2023
USER (ospid: 25829): terminating the instance 》》》》 在此执行了shutdown abort
Thu May 11 02:23:11 2023
Instance terminated by USER, pid = 25829
Thu May 11 02:23:39 2023
Starting ORACLE instance (normal) (OS id: 28711)
Thu May 11 02:23:39 2023
问题原因:
Shutdown Of Database Takes Long (up To 2 Hours) (Doc ID 2710456.1)
APPLIES TO:
Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.
SYMPTOMS
The shutdown process of database takes about 2 hours.
Seeing similar messages in alert log:
Fri Apr 24 08:21:22 2020
TT00: Standby redo logfile selected for thread 1 sequence 42086 for destination LOG_ARCHIVE_DEST_2
Fri Apr 24 08:25:47 2020
Shutting down instance (immediate)
Stopping background process SMCO
Shutting down instance: further logons disabled
Fri Apr 24 08:25:50 2020
Stopping background process CJQ0
Stopping background process MMNL
Stopping background process MMON
License high water mark = 1197
Fri Apr 24 08:25:52 2020
...
Fri Apr 24 08:26:29 2020
NOTE: Deferred communication with ASM instance
Fri Apr 24 08:26:30 2020
Buffer Cache Full DB Caching mode changing from FULL CACHING DISABLED to FULL CACHING ENABLED ◀◀◀◀◀
Fri Apr 24 08:45:49 2020
Completed: ALTER DATABASE CLOSE NORMAL
ALTER DATABASE DISMOUNT
Shutting down archive processes
Archiving is disabled
Fri Apr 24 08:45:50 2020
CAUSE
This matches behavior documented in unpublished Bug 24706726
SOLUTION
Apply Patch 24706726 - SHUTDOWN IMMEDIATE HANGS ON READ ONLY STANDBY DATABASE.