课程第18次（2017-08-17星期四）

botang

1. SQL> alter system set asm_diskstring='/dev/oracleasm/disks/*','/dev/raw/raw*';
   
2. 
   
3. System altered.
   
4. 
   
5. SQL>  create diskgroup highdata  high redundancy
   
6.   2  failgroup failgroup1 disk
   
7.   3   'ORCL:ASMDISK01' name disk1
   
8.   4  failgroup failgroup2 disk
   
9.   5   'ORCL:ASMDISK02' name disk2
   
10.   6  failgroup failgroup3 disk
    
11.   7   'ORCL:ASMDISK03' name disk3;
    
12. create diskgroup highdata  high redundancy
    
13. *
    
14. ERROR at line 1:
    
15. ORA-15018: diskgroup cannot be created
    
16. ORA-15031: disk specification 'ORCL:ASMDISK03' matches no disks
    
17. ORA-15014: path 'ORCL:ASMDISK03' is not in the discovery set
    
18. ORA-15031: disk specification 'ORCL:ASMDISK02' matches no disks
    
19. ORA-15014: path 'ORCL:ASMDISK02' is not in the discovery set
    
20. ORA-15031: disk specification 'ORCL:ASMDISK01' matches no disks
    
21. ORA-15014: path 'ORCL:ASMDISK01' is not in the discovery set
    
22. 
    
23. 
    
24. SQL>  create diskgroup highdata  high redundancy
    
25.   2  failgroup failgroup1 disk
    
26.   3   '/dev/oracleasm/disks/ASMDISK01' name disk1
    
27.   4  failgroup failgroup2 disk
    
28.   5   '/dev/oracleasm/disks/ASMDISK02' name disk2
    
29.   6  failgroup failgroup3 disk
    
30.   7   '/dev/oracleasm/disks/ASMDISK03' name disk3;
    
31. 
    
32. 
    

复制代码

1. SQL> alter diskgroup data drop disk DATA_0000
   
2.   2   disk DATA_0001
   
3.   3   disk DATA_0002
   
4.   4   disk DATA_0003
   
5.   5  disk DATA_0004
   
6.   6  disk DATA_0005;
   
7. 
   
8. Diskgroup altered.
   
9. 
   
10. SQL> alter diskgroup data drop disk DATA_0000
    
11.   2    add failgroup failgroup1 disk
    
12.   3  '/dev/raw/raw7' name DISK7,
    
13.   4   '/dev/raw/raw8' name DISK8,
    
14.   5   '/dev/raw/raw9' name DISK9
    
15.   6  add failgroup failgroup2 disk
    
16.   7   '/dev/raw/raw10'  name DISK10
    
17.   8   , '/dev/raw/raw11' name DISK11
    
18.   9   , '/dev/raw/raw12'  name DISK12
    
19. 10   rebalance power 11 ;
    
20. alter diskgroup data drop disk DATA_0000
    
21. *
    
22. ERROR at line 1:
    
23. ORA-15032: not all alterations performed
    
24. ORA-15029: disk '/dev/raw/raw12' is already mounted by this instance
    
25. ORA-15029: disk '/dev/raw/raw11' is already mounted by this instance
    
26. ORA-15029: disk '/dev/raw/raw10' is already mounted by this instance
    
27. ORA-15029: disk '/dev/raw/raw9' is already mounted by this instance
    
28. ORA-15029: disk '/dev/raw/raw8' is already mounted by this instance
    
29. ORA-15029: disk '/dev/raw/raw7' is already mounted by this instance
    
30. 
    
31. 
    
32. SQL> /
    
33. alter diskgroup data drop disk DATA_0000
    
34. *
    
35. ERROR at line 1:
    
36. ORA-15032: not all alterations performed
    
37. ORA-15054: disk "DATA_0000" does not exist in diskgroup "DATA"
    
38. 
    
39. 
    
40. SQL> ed
    
41. Wrote file afiedt.buf
    
42. 
    
43.   1  alter diskgroup data
    
44.   2    add failgroup failgroup1 disk
    
45.   3  '/dev/raw/raw7' name DISK7,
    
46.   4   '/dev/raw/raw8' name DISK8,
    
47.   5   '/dev/raw/raw9' name DISK9
    
48.   6  add failgroup failgroup2 disk
    
49.   7   '/dev/raw/raw10'        name DISK10
    
50.   8   , '/dev/raw/raw11' name DISK11
    
51.   9   , '/dev/raw/raw12'  name DISK12
    
52. 10*  rebalance power 11
    
53. SQL> /
    
54. 
    
55. Diskgroup altered.
    
56. 
    
57. SQL>
    

复制代码

1. select   * from v$asm_diskgroup
   
2.   where  name ='HIGHDATA'  ;
   
3. 
   
4. select  * from v$asm_disk;
   
5. 
   
6. select  * from v$asm_operation;
   
7. 
   
8. select  * from v$asm_client;
   
9. -----------------------------------------------
   
10. select  * from v$asm_file;
    
11. 
    
12. select  * from v$asm_alias
    
13.   where file_number=263 and group_number=1;
    
14. 
    
15. select  * from v$asm_template;
    
16. 
    
17. select  * from v$asm_attribute;
    
18. 
    
19. select  * from v$asm_file
    
20. where file_number in (256,257) and group_number=2;
    

复制代码