课程第22次（2017-04-12星期三）

botang

+ASM：

1. select  * from  v$asm_disk;
   
2. 
   
3. select  * from v$asm_diskgroup;
   
4. 
   
5. 
   
6. v$asm_operation
   
7. 
   
8. select *  from v$asm_client;
   
9. 
   
10. select  * from v$asm_file
    
11.   where group_number=1 and file_number=264;
    
12. 
    
13. select * from v$asm_alias
    
14.   where  group_number=1
    
15.    and lower(name)=lower('tbsasmunprotfine.dbf') ;
    
16. 
    
17. 
    
18. ---
    
19.   v$asm_attribute
    
20. ---
    
21. select  * from v$asm_template
    
22.   where group_number=1;
    
23.   
    
24.   
    

复制代码

orcl:

1. select  * from dba_data_files;
   
2. create tablespace tbsasmhigh
   
3. datafile '+newdata' size 10M;
   
4. 
   
5. drop tablespace tbsasmhigh including contents ;
   
6. 
   
7. create tablespace tbsasmhigh2
   
8. datafile '+newdata/orcl/datafile/tbsasmhigh2.dbf' size 10M;
   
9. 
   
10. alter tablespace tbsasmhigh2 offline ;
    
11. 
    
12. alter database rename file '+newdata/orcl/datafile/tbsasmhigh2.dbf'
    
13.   to '+newdata/orcl/datafile/TBSASMHIGH2.257.941145673';
    
14.   
    
15.   alter tablespace tbsasmhigh2 online ;
    
16.   
    
17.   select  * from v$controlfile;
    
18.   
    
19.   create tablespace tbsasmhighfine datafile '+DATA(mytemp1)'  size 10M;
    
20.   
    
21.   create tablespace tbsasmunprotfine
    
22.   datafile '+DATA(mytemp2)/orcl/datafile/tbsasmunprotfine.dbf' size 10M;
    

复制代码