|
- SQL> create diskgroup mydata normal redundancy
- 2 failgroup fg1 disk 'ORCL:ASMDISK12' name fg1disk1
- 3 failgroup fg2 disk 'ORCL:ASMDISK13' name fg2disk1;
- Diskgroup created.
- SQL>
复制代码
- SQL> alter diskgroup mydata set attribute 'compatible.asm'='11.1' ;
- Diskgroup altered.
复制代码- select * from v$asm_diskgroup;
- select * from v$asm_attribute where group_number=4;
- select * from v$asm_disk where group_number=2 ;
- select * from v$asm_operation;
复制代码- SQL> alter diskgroup data add template temp1 attributes (high fine);
- Diskgroup altered.
复制代码
- select d.preferred_read, d.failgroup
- from gv$asm_disk d where group_number=2 ;
- select * from v$asm_disk_iostat;
- select * from v$fixed_table
- where name like '%USER%';
- select * from v$asm_user;
- select * from v$asm_usergroup;
- select * from v$asm_template where group_number=2;
- /* db
- create tablespace tbs1
- datafile '+data(temp1)/orcl/mytbs.dbf' size 5M; */
-
- select * from v$asm_alias where name ='mytbs.dbf';
- select * from v$asm_file where file_number=268 and
- group_number=2;
复制代码
|
|