CREATE ASM ON AIX LV DEVICE
OS:AIX 6100-03
ASM版本 10205
# lspv
hdisk0 000d295a6d68902b rootvg active
hdisk1 000d2e62ac906f43 rootvg active
hdisk2 000d2e629b38c89d datavg active
hdisk3 none None
hdisk4 none None
# lsvg
rootvg
datavg
# chdev -l hdisk3 -a pv=yes --创建PV
hdisk3 changed
hdisk3已识别PVID
# lspv
hdisk0 000d295a6d68902b rootvg active
hdisk1 000d2e62ac906f43 rootvg active
hdisk2 000d2e629b38c89d datavg active
hdisk3 000d2e621c735061 None
hdisk4 none None
创建VG:
# mkvg -y asmvg hdisk3
asmvg
# lsvg -o
asmvg
datavg
rootvg
创建LV
mklv -y lv_asm1 asmvg 8
mklv -y lv_asm2 asmvg 8
mklv -y lv_asm3 asmvg 8
mklv -y lv_asm4 asmvg 8
# mklv -y lv_asm4 asmvg 8
lv_asm1
# mklv -y lv_asm2 asmvg 8
lv_asm2
# mklv -y lv_asm3 asmvg 8
lv_asm3
# mklv -y lv_asm4 asmvg 8
lv_asm4
修改权限
chown oracle.dba /dev/rlv_asm1 chown oracle.dba/dev/rlv_asm2 chown oracle.dba/dev/rlv_asm3 chown oracle.dba/dev/rlv_asm4
查看ASM设备
$
kfod status=TRUE asm_diskstring='/dev/rlv*' disk=all
--------------------------------------------------------------------------------
Disk Size Header Path
================================================================================
1: 256 Mb CANDIDATE /dev/rlv_asm1
2: 256 Mb CANDIDATE /dev/rlv_asm2
3: 256 Mb CANDIDATE /dev/rlv_asm3
4: 256 Mb CANDIDATE /dev/rlv_asm4
--------------------------------------------------------------------------------
ORACLE_SID ORACLE_HOME
================================================================================
+ASM /oracle/product/10.2.0/+ASM
创建磁盘组：
create diskgroup data external redundancy disk '/dev/rlv_asm1','/dev/rlv_asm2','/dev/rlv_asm3','/dev/rlv_asm4';
SQL> create diskgroup data external redundancy disk '/dev/rlv_asm1','/dev/rlv_asm2','/dev/rlv_asm3','/dev/rlv_asm4';
create diskgroup data external redundancy disk '/dev/rlv_asm1','/dev/rlv_asm2','/dev/rlv_asm3','/dev/rlv_asm4'
*
ERROR at line 1:
ORA-15018: diskgroup cannot be created
ORA-15031: disk specification '/dev/rlv_asm4' matches no disks
ORA-15014: location '/dev/rlv_asm4' is not in the discovery set
ORA-15031: disk specification '/dev/rlv_asm3' matches no disks
ORA-15014: location '/dev/rlv_asm3' is not in the discovery set
ORA-15031: disk specification '/dev/rlv_asm2' matches no disks
ORA-15014: location '/dev/rlv_asm2' is not in the discovery set
ORA-15031: disk specification '/dev/rlv_asm1' matches no disks
ORA-15014: location '/dev/rlv_asm1' is not in the discovery set
create diskgroup data external redundancy disk '/dev/rlv_asm*';
SQL> create diskgroup data external redundancy disk '/dev/rlv_asm*';
create diskgroup data external redundancy disk '/dev/rlv_asm*'
*
ERROR at line 1:
ORA-15018: diskgroup cannot be created
ORA-15031: disk specification '/dev/rlv_asm*' matches no disks
ORA-15014: location '/dev/rlv_asm4' is not in the discovery set
ORA-15014: location '/dev/rlv_asm3' is not in the discovery set
ORA-15014: location '/dev/rlv_asm2' is not in the discovery set
ORA-15014: location '/dev/rlv_asm1' is not in the discovery set
SQL>
alter system set asm_diskstring='/dev/rlv_asm*';
System altered.
SQL>
create diskgroup data external redundancy disk '/dev/rlv_asm*';
Diskgroup created.
查看alter日志：
Wed May 21 10:08:57 GMT+08:00 2014SQL> create diskgroup data external redundancy disk '/dev/rlv_asm1','/dev/rlv_asm2',' |