手动mountASM磁盘

11gR2数据库启动之后，发现TMP磁盘组未MOUNT：

GROUP_NUMBER NAME                           STATE       TYPE     TOTAL_MB    FREE_MB USABLE_FILE_MB
------------ ------------------------------ ----------- ------ ---------- ---------- --------------
           0 CRS                            MOUNTED     EXTERN       5120       4756           4756
           0 OCRNEW                         MOUNTED     NORMAL      15360      14436           7063
           5 FRA                            MOUNTED     EXTERN       8192       6650           6650
           0 TMP                            DISMOUNTED                  0          0              0
           5 DATA                           MOUNTED     EXTERN       8192       5533           5533

TMP磁盘为dismounted状态。

mount该磁盘：

SQL> alter diskgroup tmp mount;   

Diskgroup altered.

查看：
GROUP_NUMBER NAME                           STATE       TYPE     TOTAL_MB    FREE_MB USABLE_FILE_MB
------------ ------------------------------ ----------- ------ ---------- ---------- --------------
           0 CRS                            MOUNTED     EXTERN       5120       4756           4756
           0 OCRNEW                         MOUNTED     NORMAL      15360      14436           7063
           5 FRA                            MOUNTED     EXTERN       8192       6650           6650
           5 TMP                            MOUNTED     EXTERN       5120       4757           4757
           5 DATA                           MOUNTED     EXTERN       8192       5533           5533

mount了！但是搞定了么？
不要忘记还有另一个节点：
GROUP_NUMBER NAME                           STATE       TYPE     TOTAL_MB    FREE_MB USABLE_FILE_MB
------------ ------------------------------ ----------- ------ ---------- ---------- --------------
           0 CRS                            MOUNTED     EXTERN       5120       4756           4756
           0 OCRNEW                         MOUNTED     NORMAL      15360      14436           7063
           5 FRA                            MOUNTED     EXTERN       8192       6650           6650
           0 TMP                            DISMOUNTED                  0          0              0
           5 DATA                           MOUNTED     EXTERN       8192       5533           5533

同样操作：
SQL> alter diskgroup tmp mount;

Diskgroup altered.

这才是搞定了！！！

手动mountASM磁盘

原文：http://blog.csdn.net/ghostliming/article/details/50503054