查看asm实例启动是否成功

最新推荐文章于 2023-02-08 07:38:04 发布

Snowballl

最新推荐文章于 2023-02-08 07:38:04 发布

阅读量2.8k

点赞数

分类专栏： oracle解决方案实现

本文链接：https://blog.csdn.net/minwang593/article/details/14522903

版权

oracle解决方案实现专栏收录该内容

43 篇文章 0 订阅

订阅专栏

在grid用户下，主要通过user_dump_dest查看日志/u01/app/oracle/diag/asm/+asm/+ASM1/trace中的alert_+ASM1.log文件

SQL> show parameter user_dump_dest

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
user_dump_dest                       string      /u01/app/oracle/diag/asm/+asm/
                                                 +ASM1/trace

如下内容：

GMON dismounting group 1 at 7 for pid 29, osid 13935
NOTE: Disk in mode 0x8 marked for de-assignment
SUCCESS: diskgroup BSQQNS was dismounted
NOTE: cache deleting context for group BSQQNS 1/0xdec97b2f
SUCCESS: ALTER DISKGROUP BSQQNS DISMOUNT /* asm agent *//* {1:2802:16425} */
SQL> ALTER DISKGROUP DATA DISMOUNT /* asm agent *//* {1:2802:16425} */
Tue Nov 05 22:03:39 2013
GMON querying group 2 at 8 for pid 19, osid 13589
Tue Nov 05 22:03:39 2013
NOTE: Instance updated compatible.asm to 11.2.0.0.0 for grp 2
Tue Nov 05 22:03:39 2013
ORA-15032: not all alterations performed
ORA-15027: active use of diskgroup "DATA" precludes its dismount
ERROR: ALTER DISKGROUP DATA DISMOUNT /* asm agent *//* {1:2802:16425} */
Tue Nov 05 22:03:49 2013
SQL> ALTER DISKGROUP DATA DISMOUNT /* asm agent *//* {1:2802:16425} */
Tue Nov 05 22:03:50 2013
freeing rdom 1
Received detach msg from inst 2 for dom 1
Tue Nov 05 22:03:59 2013
GMON querying group 2 at 9 for pid 19, osid 13589
Tue Nov 05 22:03:59 2013
NOTE: Instance updated compatible.asm to 11.2.0.0.0 for grp 2
Tue Nov 05 22:03:59 2013
ORA-15032: not all alterations performed
ORA-15027: active use of diskgroup "DATA" precludes its dismount
ERROR: ALTER DISKGROUP DATA DISMOUNT /* asm agent *//* {1:2802:16425} */
Tue Nov 05 22:04:09 2013
SQL> ALTER DISKGROUP DATA DISMOUNT /* asm agent *//* {1:2802:16425} */