asm常见操作

asmcmd 可以直接进入命令行或者直接跟命令或者直接asmca图形化界面操作
1、lsdg 列出磁盘组
asmcmd lsdg

2、lsdsk 列出 Oracle ASM 磁盘
asmcmd lsdsk

3、lsdsk -G DATA -t -p 列出磁盘组的磁盘
asmcmd lsdsk -G DATA -t -p

4、lsattr -l -G data列出磁盘组的属性
asmcmd lsattr -l -G DATA

5、umount DATA 卸载掉挂载的磁盘组
asmcmd umount DATA

6、mount DATA 挂载的磁盘组
asmcmd mount DATA

7、查看磁盘组相关信息的视图
select * from v$as{m}_{d}iskselect\ast fromv$asm_diskgroup

8、实例上对磁盘组进行操作
– Create an alias using the fully qualified filename.

ALTER DISKGROUP disk_group_1 ADD ALIAS ‘+disk_group_1/my_dir/my_file.dbf’
FOR ‘+disk_group_1/mydb/datafile/my_ts.342.3’;

– Create an alias using the numeric form filename.

ALTER DISKGROUP disk_group_1 ADD ALIAS ‘+disk_group_1/my_dir/my_file.dbf’
FOR ‘+disk_group_1.342.3’;

– Rename an alias.

ALTER DISKGROUP disk_group_1 RENAME ALIAS ‘+disk_group_1/my_dir/my_file.dbf’
TO ‘+disk_group_1/my_dir/my_file2.dbf’;

– Delete an alias.

ALTER DISKGROUP disk_group_1 DELETE ALIAS ‘+disk_group_1/my_dir/my_file.dbf’;

– Drop file using an alias.

ALTER DISKGROUP disk_group_1 DROP FILE ‘+disk_group_1/my_dir/my_file.dbf’;

– Drop file using a numeric form filename.

ALTER DISKGROUP disk_group_1 DROP FILE ‘+disk_group_1.342.3’;

– Drop file using a fully qualified filename.

ALTER DISKGROUP disk_group_1 DROP FILE ‘+disk_group_1/mydb/datafile/my_ts.342.3’;

– create datafile

SQL> create tablespace users2 datafile ‘+TESTDB_DATA1’ size 100m;

9、替换votedisk
先创建一个磁盘组VOTEDSK
crsctl replace votedisk +VOTEDSK; 将votedisk换到该磁盘组