解决dbca建库时节点2的asm资源OFFLINE

在安装完GI之后创建asm磁盘组之后发现资源异常

并没有在意继续下一步dbca 建库

这事不得不解决了！
[grid@dbrac2 ~]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.4.0 Production on Mon Jan 9 21:43:51 2017

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

SQL> conn / as sysasm
Connected.
SQL> select group_number gno,name,state,type,total_mb,free_mb,required_mirror_free_mb rmfmb,usable_file_mb ufmb from v$asm_diskgroup;

       GNO NAME                           STATE       TYPE     TOTAL_MB
---------- ------------------------------ ----------- ------ ----------
   FREE_MB      RMFMB       UFMB
---------- ---------- ----------
         1 SYSTEMDG                       MOUNTED     HIGH        25600
     24344      10240       4701

         3 BACKUPDG                       MOUNTED     EXTERN       5120
      5025          0       5025

         0 DATA                           DISMOUNTED                  0
         0          0          0
//
显示没有挂载
SQL> ALTER DISKGROUP DATA MOUNT;

Diskgroup altered.

SQL> select group_number gno,name,state,type,total_mb,free_mb,required_mirror_free_mb rmfmb,usable_file_mb ufmb from v$asm_diskgroup;

       GNO NAME                           STATE       TYPE     TOTAL_MB
---------- ------------------------------ ----------- ------ ----------
   FREE_MB      RMFMB       UFMB
---------- ---------- ----------
         1 SYSTEMDG                       MOUNTED     HIGH        25600
     24344      10240       4701

         3 BACKUPDG                       MOUNTED     EXTERN       5120
      5025          0       5025

         2 DATA                           MOUNTED     EXTERN      11264
     11167          0       5025

在查看资源online



下一步正常出现!

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

转载于:http://blog.itpub.net/29674916/viewspace-2132449/