|
- SQL> alter system set asm_diskstring='/dev/oracleasm/disks/*','/dev/raw/raw*';
- System altered.
- SQL> create diskgroup highdata high redundancy
- 2 failgroup failgroup1 disk
- 3 'ORCL:ASMDISK01' name disk1
- 4 failgroup failgroup2 disk
- 5 'ORCL:ASMDISK02' name disk2
- 6 failgroup failgroup3 disk
- 7 'ORCL:ASMDISK03' name disk3;
- create diskgroup highdata high redundancy
- *
- ERROR at line 1:
- ORA-15018: diskgroup cannot be created
- ORA-15031: disk specification 'ORCL:ASMDISK03' matches no disks
- ORA-15014: path 'ORCL:ASMDISK03' is not in the discovery set
- ORA-15031: disk specification 'ORCL:ASMDISK02' matches no disks
- ORA-15014: path 'ORCL:ASMDISK02' is not in the discovery set
- ORA-15031: disk specification 'ORCL:ASMDISK01' matches no disks
- ORA-15014: path 'ORCL:ASMDISK01' is not in the discovery set
- SQL> create diskgroup highdata high redundancy
- 2 failgroup failgroup1 disk
- 3 '/dev/oracleasm/disks/ASMDISK01' name disk1
- 4 failgroup failgroup2 disk
- 5 '/dev/oracleasm/disks/ASMDISK02' name disk2
- 6 failgroup failgroup3 disk
- 7 '/dev/oracleasm/disks/ASMDISK03' name disk3;
复制代码
- SQL> alter diskgroup data drop disk DATA_0000
- 2 disk DATA_0001
- 3 disk DATA_0002
- 4 disk DATA_0003
- 5 disk DATA_0004
- 6 disk DATA_0005;
- Diskgroup altered.
- SQL> alter diskgroup data drop disk DATA_0000
- 2 add failgroup failgroup1 disk
- 3 '/dev/raw/raw7' name DISK7,
- 4 '/dev/raw/raw8' name DISK8,
- 5 '/dev/raw/raw9' name DISK9
- 6 add failgroup failgroup2 disk
- 7 '/dev/raw/raw10' name DISK10
- 8 , '/dev/raw/raw11' name DISK11
- 9 , '/dev/raw/raw12' name DISK12
- 10 rebalance power 11 ;
- alter diskgroup data drop disk DATA_0000
- *
- ERROR at line 1:
- ORA-15032: not all alterations performed
- ORA-15029: disk '/dev/raw/raw12' is already mounted by this instance
- ORA-15029: disk '/dev/raw/raw11' is already mounted by this instance
- ORA-15029: disk '/dev/raw/raw10' is already mounted by this instance
- ORA-15029: disk '/dev/raw/raw9' is already mounted by this instance
- ORA-15029: disk '/dev/raw/raw8' is already mounted by this instance
- ORA-15029: disk '/dev/raw/raw7' is already mounted by this instance
- SQL> /
- alter diskgroup data drop disk DATA_0000
- *
- ERROR at line 1:
- ORA-15032: not all alterations performed
- ORA-15054: disk "DATA_0000" does not exist in diskgroup "DATA"
- SQL> ed
- Wrote file afiedt.buf
- 1 alter diskgroup data
- 2 add failgroup failgroup1 disk
- 3 '/dev/raw/raw7' name DISK7,
- 4 '/dev/raw/raw8' name DISK8,
- 5 '/dev/raw/raw9' name DISK9
- 6 add failgroup failgroup2 disk
- 7 '/dev/raw/raw10' name DISK10
- 8 , '/dev/raw/raw11' name DISK11
- 9 , '/dev/raw/raw12' name DISK12
- 10* rebalance power 11
- SQL> /
- Diskgroup altered.
- SQL>
复制代码
- select * from v$asm_diskgroup
- where name ='HIGHDATA' ;
- select * from v$asm_disk;
- select * from v$asm_operation;
- select * from v$asm_client;
- -----------------------------------------------
- select * from v$asm_file;
- select * from v$asm_alias
- where file_number=263 and group_number=1;
- select * from v$asm_template;
- select * from v$asm_attribute;
- select * from v$asm_file
- where file_number in (256,257) and group_number=2;
复制代码
|
|