创建ASM With Oracle 10G(三)
up order by 1,2;
GROUP_NUMBERNAME STATE TYPE TOTAL_MB FREE_MB USABLE_FILE_MBREQUIRED_MIRROR_FREE_MB
------------------ ------------ -------- ----------- ----------- -------------------------------------
1 DATA01 MOUNTED EXTERN 2048.00 1996.00 1996 0
2 FRA MOUNTED EXTERN 2048.00 1996.00 1996 0
其他一些语法：
SQL> create diskgroup group_high highredundancy
2 failgroup fg1 disk '/dev/raw/raw1' name d1
3 failgroup fg2 disk '/dev/raw/raw2' name d2
4 failgroup fg3 disk '/dev/raw/raw3' name d3;
Diskgroup created.
SQL> create diskgroup group_normal normalredundancy
2 failgroup fg4 disk '/dev/raw/raw4' name d4
3 failgroup fg5 disk '/dev/raw/raw5' name d5;
Diskgroup created.
SQL> create diskgroup group_external externalredundancy disk '/dev/raw/raw6';
Diskgroup created.
SQL> drop diskgroup group_external;
Diskgroup dropped.
SQL> alter diskgroup group_normal add disk'/dev/raw/raw6' name d61;
Diskgroup altered.
SQL> alter diskgroup group_normal resize diskd61 size 150m;
Diskgroup altered.
SQL> alter diskgroup group_normal drop diskd61;
Diskgroup altered.
SQL> alter diskgroup group_normal addfailgroup fg5 disk '/dev/raw/raw6' name d6;
Diskgroup altered.
SQL> alter diskgroup group_high dismount;
Diskgroup altered.
SQL> alter diskgroup all dismount;
Diskgroup altered.
SQL> alter diskgroup all mount;
Diskgroup altered.
ASM目录和别名
SQL> alter diskgroup group_normal adddirectory '+group_normal/mydir';
Diskgroup altered.
SQL> alter diskgroup group_normal add alias'+group_normal/gt10g/datafile/gtlions01.dbf' for'+group_normal/gt10g/datafile/GTLIONS.256.807383189';
Diskgroup altered.