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.
这才是弄定了！！！
11gR2数据库启动以后，发明TMP磁盘组未MOUNT：
GROUP_NUMBER NAME
阅读背景：
手动mountASM磁盘
来源：互联网
分享到：
