SQL> startup nomount
SQL> startup
ORA-01012: not logged on
SQL> shutdown immediate
查看alert日志:
NOTE: Instance updated compatible.asm to 11.2.0.0.0 for grp 3
SUCCESS: diskgroup SYS_DG was mounted
SUCCESS: ALTER DISKGROUP ALL MOUNT
NOTE: diskgroup resource ora.DATA_DG.dg is online
NOTE: diskgroup resource ora.DG_FRA.dg is online
NOTE: diskgroup resource ora.SYS_DG.dg is online
Sat Feb 22 19:38:59 2014
Shutting down instance (immediate)
Shutting down instance: further logons disabled
Stopping background process MMNL
Stopping background process MMON
License high water mark = 4
Sat Feb 22 19:44:02 2014
SHUTDOWN: Active processes prevent shutdown operation
Sat Feb 22 19:49:04 2014
SHUTDOWN: Active processes prevent shutdown operation
[grid@myrac1 trace]$ date
Sat Feb 22 21:07:46 PST 2014
[grid@myrac1 trace]$ tail -f alert_+ASM.log
Sat Feb 22 19:38:59 2014
Shutting down instance (immediate)
Shutting down instance: further logons disabled
Stopping background process MMNL
Stopping background process MMON
License high water mark = 4
Sat Feb 22 19:44:02 2014
SHUTDOWN: Active processes prevent shutdown operation
Sat Feb 22 19:49:04 2014
SHUTDOWN: Active processes prevent shutdown operation
Sat Feb 22 21:09:49 2014
License high water mark = 4
从日志可以发现是实例出现异常,导致无法启动shutdown,尝试强行停止
SQL> shutdown abort
ASM instance shutdown
SQL> startup
ASM instance started
Total System Global Area 284565504 bytes
Fixed Size 1336036 bytes
Variable Size 258063644 bytes
ASM Cache 25165824 bytes
ASM diskgroups mounted
: