课程第69次（2017-11-03星期五）

botang

1. SQL> create diskgroup mydata  normal redundancy
   
2.   2   failgroup fg1 disk 'ORCL:ASMDISK12' name fg1disk1
   
3.   3   failgroup fg2 disk 'ORCL:ASMDISK13' name fg2disk1;
   
4. 
   
5. Diskgroup created.
   
6. 
   
7. SQL>
   

复制代码

1. SQL> alter diskgroup mydata set attribute 'compatible.asm'='11.1' ;
   
2. 
   
3. Diskgroup altered.
   
4. 
   

复制代码

1. select  * from v$asm_diskgroup;
   
2. 
   
3. select  * from v$asm_attribute  where group_number=4;
   
4. 
   
5. select  * from v$asm_disk  where  group_number=2 ;
   
6. 
   
7. select * from v$asm_operation;

复制代码

1. SQL> alter diskgroup data add template temp1 attributes (high fine);
   
2. 
   
3. Diskgroup altered.
   

复制代码

1. 
   
2. select  d.preferred_read,  d.failgroup
   
3.   from gv$asm_disk d  where  group_number=2 ;
   
4. 
   
5. 
   
6. select * from v$asm_disk_iostat;
   
7. 
   
8. select  * from v$fixed_table
   
9.   where name like '%USER%';
   
10. 
    
11. 
    
12. select  * from v$asm_user;
    
13. 
    
14. select   * from v$asm_usergroup;
    
15. 
    
16. select  * from v$asm_template  where group_number=2;
    
17. /* db
    
18. create tablespace tbs1
    
19. datafile '+data(temp1)/orcl/mytbs.dbf'  size 5M;  */
    
20. 
    
21. select  * from v$asm_alias where name ='mytbs.dbf';
    
22. 
    
23. select  * from v$asm_file where file_number=268 and
    
24.                      group_number=2;
    

复制代码