asm的一些基本操作

创建diskgroup[@more@]

SQL> create diskgroup flash external redundancy disk 'ORCL:FLASH01','ORCL:FLASH02';

Diskgroup created.

添加磁盘

SQL> alter diskgroup flash add disk 'ORCL:FLASH03';

Diskgroup altered.

删除磁盘

SQL> alter diskgroup flash drop disk flash03;

Diskgroup altered.

删除磁盘组

SQL> drop diskgroup flash;

Diskgroup dropped.

SQL> create diskgroup flash normal redundancy failgroup fg1 disk 'ORCL:FLASH01' failgroup fg2 disk 'ORCL:FLASH02';

Diskgroup created.

===============================================================

SQL> select group_number,name,state,total_mb,free_mb from v$asm_diskgroup;

GROUP_NUMBER NAME STATE TOTAL_MB FREE_MB
------------ ------------------------------ ----------- ---------- ----------
1 DATA MOUNTED 6134 4605
2 FLASH MOUNTED 6132 5977

SQL> alter diskgroup flash dismount;

Diskgroup altered.

SQL> select group_number,name,state,total_mb,free_mb from v$asm_diskgroup;

GROUP_NUMBER NAME STATE TOTAL_MB FREE_MB
------------ ------------------------------ ----------- ---------- ----------
1 DATA MOUNTED 6134 4605
0 FLASH DISMOUNTED 0 0

SQL> alter diskgroup flash mount;

Diskgroup altered.

SQL> select group_number,name,state,total_mb,free_mb from v$asm_diskgroup;

GROUP_NUMBER NAME STATE TOTAL_MB FREE_MB
------------ ------------------------------ ----------- ---------- ----------
1 DATA MOUNTED 6134 4605
2 FLASH MOUNTED 6132 5977

===============================================================

create directory ,或者可以直接在asmcmd中直接使用mkdir添加目录

SQL> alter diskgroup flash add directory '+flash/test1';

Diskgroup altered.

SQL> alter diskgroup flash rename directory '+flash/test1' to '+flash/test2';

Diskgroup altered.

SQL> alter diskgroup flash drop directory '+flash/test2';

Diskgroup altered.

==============================================================

管理别名

SQL> alter diskgroup data add alias '+data/asm/current.ctl' for '+data/asm/controlfile/Current.260.801073901';

Diskgroup altered.

SQL> alter diskgroup data rename alias '+data/asm/current.ctl' to '+data/asm/current_control.ctl';

Diskgroup altered.

SQL> alter diskgroup data drop alias '+data/asm/current_control.ctl';

Diskgroup altered.

SQL> select * from v$asm_alias;

..........................................

============================================================

删除磁盘组中的文件

SQL> alter diskgroup data drop file '+data/asm/datafile/userssss';

Diskgroup altered.

===========================================================

asm中的文件名

asm中的文件创建均由系统自动命名

+diskgroupname/dbname/file_type/file_type_tag.file.incarnation

diskgroupname 磁盘组名

dbname 数据库名

file_type 创建的文件类型

file_type_tag 文件类型的标签

file.incarnation 文件序号+incarnation

SQL> alter tablespace temp add tempfile '+data/asm/tempfile/temp02.dbf' size 10m;

Tablespace altered.

SQL> alter tablespace temp add tempfile '+data' size 10m;

Tablespace altered.

ASMCMD> pwd
+data/asm/tempfile
ASMCMD> ls -l
Type Redund Striped Time Sys Name
TEMPFILE UNPROT COARSE JAN 29 15:00:00 Y TEMP.264.801073935
TEMPFILE UNPROT COARSE JAN 30 13:00:00 Y TEMP.275.806074409
TEMPFILE UNPROT COARSE JAN 30 13:00:00 Y TEMP.276.806075175
TEMPFILE UNPROT COARSE JAN 30 13:00:00 Y TEMP.277.806075277
N temp02.dbf => +DATA/ASM/TEMPFILE/TEMP.276.806075175

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

转载于:http://blog.itpub.net/24237320/viewspace-1060179/