asm disk replace
[root@asm ~]# multipath -ll
mpathe (14f504e46494c45524874693033372d70366d462d4e746773) dm-3 OPNFILER,VIRTUAL-DISK
size=5.0G features='0' hwhandler='0' wp=rw
`-+- policy='round-robin 0' prio=1 status=active
`- 35:0:0:6 sdh 8:112 active ready running
asm-4 (14f504e46494c455274586b3178522d427434452d33766970) dm-2 OPNFILER,VIRTUAL-DISK
size=5.0G features='0' hwhandler='0' wp=rw
`-+- policy='round-robin 0' prio=1 status=active
`- 35:0:0:3 sde 8:64 active ready running
asm-3 (14f504e46494c45526763516767782d596d6e342d6469376a) dm-5 OPNFILER,VIRTUAL-DISK
size=5.0G features='0' hwhandler='0' wp=rw
`-+- policy='round-robin 0' prio=1 status=active
`- 35:0:0:1 sdc 8:32 active ready running
asm-2 (14f504e46494c45527343435876352d6b4573622d57476871) dm-8 OPNFILER,VIRTUAL-DISK
size=5.0G features='0' hwhandler='0' wp=rw
`-+- policy='round-robin 0' prio=1 status=active
`- 35:0:0:2 sdd 8:48 active ready running
asm-1 (14f504e46494c45524c61687330622d6d7976762d38366436) dm-9 OPNFILER,VIRTUAL-DISK
size=5.0G features='0' hwhandler='0' wp=rw
`-+- policy='round-robin 0' prio=1 status=active
`- 35:0:0:0 sdb 8:16 active ready running
mpathh (14f504e46494c45524c57657150642d6a4a31692d6b34706b) dm-7 OPNFILER,VIRTUAL-DISK
size=5.0G features='0' hwhandler='0' wp=rw
`-+- policy='round-robin 0' prio=1 status=active
`- 35:0:0:4 sdf 8:80 active ready running
mpathg (14f504e46494c455263507a354d4a2d447778732d59526c42) dm-6 OPNFILER,VIRTUAL-DISK
size=5.0G features='0' hwhandler='0' wp=rw
`-+- policy='round-robin 0' prio=1 status=active
`- 35:0:0:5 sdg 8:96 active ready running
mpathf (14f504e46494c45523775516558502d6a7755432d6741787a) dm-4 OPNFILER,VIRTUAL-DISK
size=5.0G features='0' hwhandler='0' wp=rw
`-+- policy='round-robin 0' prio=1 status=active
`- 35:0:0:7 sdi 8:128 active ready running
multipaths {
multipath {
wwid 14f504e46494c45524c61687330622d6d7976762d38366436
alias asm-1
}
multipath {
wwid 14f504e46494c45527343435876352d6b4573622d57476871
alias asm-2
}
multipath {
wwid 14f504e46494c45526763516767782d596d6e342d6469376a
alias asm-3
}
multipath {
wwid 14f504e46494c455274586b3178522d427434452d33766970
alias asm-4
}
multipath {
wwid 14f504e46494c45524874693033372d70366d462d4e746773
alias asmtest-1
}
multipath {
wwid 14f504e46494c45523775516558502d6a7755432d6741787a
alias asmtest-2
}
multipath {
wwid 14f504e46494c455263507a354d4a2d447778732d59526c42
alias asmtest-3
}
multipath {
wwid 14f504e46494c45524c57657150642d6a4a31692d6b34706b
alias asmtest-4
}
}
[root@asm ~]# vi /etc/udev/rules.d/12-dm-permissions.rules
###test udev,fuck udev
ENV{DM_NAME}=="asm-1",NAME="disk1", OWNER:="grid", GROUP:="asmadmin", MODE:="660"
ENV{DM_NAME}=="asm-2",NAME="disk2", OWNER:="grid", GROUP:="asmadmin", MODE:="660"
ENV{DM_NAME}=="asm-3",NAME="disk3", OWNER:="grid", GROUP:="asmadmin", MODE:="660"
ENV{DM_NAME}=="asm-4",NAME="disk4", OWNER:="grid", GROUP:="asmadmin", MODE:="660"
ENV{DM_NAME}=="asmtest-1",NAME="disk5", OWNER:="grid", GROUP:="asmadmin", MODE:="660"
ENV{DM_NAME}=="asmtest-2",NAME="disk6", OWNER:="grid", GROUP:="asmadmin", MODE:="660"
ENV{DM_NAME}=="asmtest-3",NAME="disk7", OWNER:="grid", GROUP:="asmadmin", MODE:="660"
ENV{DM_NAME}=="asmtest-4",NAME="disk8", OWNER:="grid", GROUP:="asmadmin", MODE:="660"
[root@asm ~]# vi /etc/udev/rules.d/99-oracle-asmdevices.rules
###test udev fuck udev
KERNEL=="sd*", SUBSYSTEM=="block", ENV{DEVTYPE}=="disk", ENV{ID_SERIAL}=="14f504e46494c45524c61687330622d6d7976762d38366436", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*", SUBSYSTEM=="block", ENV{DEVTYPE}=="disk", ENV{ID_SERIAL}=="14f504e46494c45527343435876352d6b4573622d57476871", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*", SUBSYSTEM=="block", ENV{DEVTYPE}=="disk", ENV{ID_SERIAL}=="14f504e46494c45526763516767782d596d6e342d6469376a", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*", SUBSYSTEM=="block", ENV{DEVTYPE}=="disk", ENV{ID_SERIAL}=="14f504e46494c455274586b3178522d427434452d33766970", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*", SUBSYSTEM=="block", ENV{DEVTYPE}=="disk", ENV{ID_SERIAL}=="14f504e46494c45524874693033372d70366d462d4e746773", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*", SUBSYSTEM=="block", ENV{DEVTYPE}=="disk", ENV{ID_SERIAL}=="14f504e46494c45523775516558502d6a7755432d6741787a", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*", SUBSYSTEM=="block", ENV{DEVTYPE}=="disk", ENV{ID_SERIAL}=="14f504e46494c455263507a354d4a2d447778732d59526c42", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*", SUBSYSTEM=="block", ENV{DEVTYPE}=="disk", ENV{ID_SERIAL}=="14f504e46494c45524c57657150642d6a4a31692d6b34706b", OWNER="grid", GROUP="asmadmin", MODE="0660"
[root@asm ~]# start_udev
Starting udev: [ OK ]
grid用户
[grid@asm ~]$ export ORACLE_SID=+ASM
[grid@asm ~]$ sqlplus / as sysasm #以sysasm登陆
SQL> select group_number,name,type,total_mb,free_mb from v$asm_diskgroup; 查询
GROUP_NUMBER NAME TYPE TOTAL_MB FREE_MB
------------ ---------- ------------ ---------- ----------
1 DATA EXTERN 10240 7958
SQL> select NAME,PATH,total_mb,free_mb from v$asm_disk; 查询
NAME PATH TOTAL_MB FREE_MB
---------- -------------------- ---------- ----------
DATA_0000 /dev/disk1 5120 3979
DATA_0001 /dev/disk2 5120 3979
/dev/disk4 0 0
/dev/disk3 0 0
/dev/disk6 0 0
/dev/disk5 0 0
/dev/disk7 0 0
/dev/disk8 0 0
8 rows selected.
SQL> alter diskgroup DATA add disk '/dev/disk5' rebalance power 11; #加入新盘
Diskgroup altered.
SQL> alter diskgroup DATA add disk '/dev/disk6' rebalance power 11; #加入新盘
Diskgroup altered.
SQL> select * from v$asm_operation;
GROUP_NUMBER OPERA STAT POWER ACTUAL SOFAR EST_WORK EST_RATE EST_MINUTES ERROR_CODE
------------ ----- ---- ---------- ---------- ---------- ---------- ---------- ----------- -----------
1 REBAL RUN 11 11 637 840 1202 0
SQL> select * from v$asm_operation;
no rows selected
SQL> select NAME,PATH,total_mb,free_mb from v$asm_disk;
NAME PATH TOTAL_MB FREE_MB
---------- -------------------- ---------- ----------
/dev/disk8 0 0
/dev/disk7 0 0
/dev/disk3 0 0
/dev/disk4 0 0
DATA_0002 /dev/disk5 5120 4550
DATA_0003 /dev/disk6 5120 4550
DATA_0000 /dev/disk1 5120 4547
DATA_0001 /dev/disk2 5120 4547
8 rows selected.
SQL> select group_number,name,type,total_mb,free_mb from v$asm_diskgroup;
GROUP_NUMBER NAME TYPE TOTAL_MB FREE_MB
------------ ---------- ------ ---------- ----------
1 DATA EXTERN 20480 18194
SQL> alter diskgroup DATA drop disk 'DATA_0000' rebalance power 11; #删除旧盘
Diskgroup altered.
SQL> alter diskgroup DATA drop disk 'DATA_0001' rebalance power 11; #删除旧盘
Diskgroup altered.
SQL> select name,path,state from v$asm_disk; #查询
NAME PATH STATE
---------- -------------------- --------
/dev/disk8 NORMAL
/dev/disk7 NORMAL
/dev/disk3 NORMAL
/dev/disk4 NORMAL
DATA_0002 /dev/disk5 NORMAL
DATA_0003 /dev/disk6 NORMAL
DATA_0000 /dev/disk1 DROPPING
DATA_0001 /dev/disk2 DROPPING
8 rows selected.
SQL> select * from v$asm_operation;
GROUP_NUMBER OPERA STAT POWER ACTUAL SOFAR EST_WORK EST_RATE EST_MINUTES ERROR_CODE
------------ ----- ---- ---------- ---------- ---------- ---------- ---------- ----------- ----------
1 REBAL RUN 11 11 826 1029 945 0
SQL> select * from v$asm_operation;
no rows selected
[grid@asm ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE asm
ora.LISTENER.lsnr
ONLINE ONLINE asm
ora.asm
ONLINE ONLINE asm Started
ora.ons
OFFLINE OFFLINE asm
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
1 ONLINE ONLINE asm
ora.diskmon
1 OFFLINE OFFLINE
ora.evmd
1 ONLINE ONLINE asm
ora.orcl.db
1 ONLINE ONLINE asm Open
SQL> select name,path,state from v$asm_disk;
NAME PATH STATE
---------- -------------------- --------
/dev/disk8 NORMAL
/dev/disk7 NORMAL
/dev/disk1 NORMAL
/dev/disk2 NORMAL
/dev/disk4 NORMAL
/dev/disk3 NORMAL
DATA_0002 /dev/disk5 NORMAL
DATA_0003 /dev/disk6 NORMAL
8 rows selected.
SQL> select group_number,name,type,total_mb,free_mb from v$asm_diskgroup;
GROUP_NUMBER NAME TYPE TOTAL_MB FREE_MB
------------ ---------- ------ ---------- ----------
1 DATA EXTERN 10240 7958
删除完旧盘后,修改udev相关配置文件,修改multipath.conf配置文件,重启iscsi和multipath服务,
重启主机后,旧存储即可移除。
SQL> select name,path,state from v$asm_disk;
NAME PATH STATE
---------- -------------------- --------
/dev/disk8 NORMAL
/dev/disk7 NORMAL
DATA_0003 /dev/disk6 NORMAL
DATA_0002 /dev/disk5 NORMAL
SQL> select name from v$datafile;
NAME
---------------------------------------------
+DATA/orcl/datafile/system.256.948366147
+DATA/orcl/datafile/sysaux.257.948366147
+DATA/orcl/datafile/undotbs1.258.948366149
+DATA/orcl/datafile/users.259.948366149
+DATA/orcl/datafile/example.269.948366277
SQL> select member from v$logfile;
MEMBER
--------------------------------------------
+DATA/orcl/onlinelog/group_3.266.948366249
+DATA/orcl/onlinelog/group_3.267.948366249
+DATA/orcl/onlinelog/group_2.264.948366245
+DATA/orcl/onlinelog/group_2.265.948366247
+DATA/orcl/onlinelog/group_1.262.948366243
+DATA/orcl/onlinelog/group_1.263.948366243
6 rows selected.
SQL> select name from v$controlfile;
NAME
---------------------------------------------
+DATA/orcl/controlfile/current.261.948366239
+DATA/orcl/controlfile/current.260.948366239
[root@asm ~]# multipath -ll
mpathe (14f504e46494c45524874693033372d70366d462d4e746773) dm-3 OPNFILER,VIRTUAL-DISK
size=5.0G features='0' hwhandler='0' wp=rw
`-+- policy='round-robin 0' prio=1 status=active
`- 35:0:0:6 sdh 8:112 active ready running
asm-4 (14f504e46494c455274586b3178522d427434452d33766970) dm-2 OPNFILER,VIRTUAL-DISK
size=5.0G features='0' hwhandler='0' wp=rw
`-+- policy='round-robin 0' prio=1 status=active
`- 35:0:0:3 sde 8:64 active ready running
asm-3 (14f504e46494c45526763516767782d596d6e342d6469376a) dm-5 OPNFILER,VIRTUAL-DISK
size=5.0G features='0' hwhandler='0' wp=rw
`-+- policy='round-robin 0' prio=1 status=active
`- 35:0:0:1 sdc 8:32 active ready running
asm-2 (14f504e46494c45527343435876352d6b4573622d57476871) dm-8 OPNFILER,VIRTUAL-DISK
size=5.0G features='0' hwhandler='0' wp=rw
`-+- policy='round-robin 0' prio=1 status=active
`- 35:0:0:2 sdd 8:48 active ready running
asm-1 (14f504e46494c45524c61687330622d6d7976762d38366436) dm-9 OPNFILER,VIRTUAL-DISK
size=5.0G features='0' hwhandler='0' wp=rw
`-+- policy='round-robin 0' prio=1 status=active
`- 35:0:0:0 sdb 8:16 active ready running
mpathh (14f504e46494c45524c57657150642d6a4a31692d6b34706b) dm-7 OPNFILER,VIRTUAL-DISK
size=5.0G features='0' hwhandler='0' wp=rw
`-+- policy='round-robin 0' prio=1 status=active
`- 35:0:0:4 sdf 8:80 active ready running
mpathg (14f504e46494c455263507a354d4a2d447778732d59526c42) dm-6 OPNFILER,VIRTUAL-DISK
size=5.0G features='0' hwhandler='0' wp=rw
`-+- policy='round-robin 0' prio=1 status=active
`- 35:0:0:5 sdg 8:96 active ready running
mpathf (14f504e46494c45523775516558502d6a7755432d6741787a) dm-4 OPNFILER,VIRTUAL-DISK
size=5.0G features='0' hwhandler='0' wp=rw
`-+- policy='round-robin 0' prio=1 status=active
`- 35:0:0:7 sdi 8:128 active ready running
multipaths {
multipath {
wwid 14f504e46494c45524c61687330622d6d7976762d38366436
alias asm-1
}
multipath {
wwid 14f504e46494c45527343435876352d6b4573622d57476871
alias asm-2
}
multipath {
wwid 14f504e46494c45526763516767782d596d6e342d6469376a
alias asm-3
}
multipath {
wwid 14f504e46494c455274586b3178522d427434452d33766970
alias asm-4
}
multipath {
wwid 14f504e46494c45524874693033372d70366d462d4e746773
alias asmtest-1
}
multipath {
wwid 14f504e46494c45523775516558502d6a7755432d6741787a
alias asmtest-2
}
multipath {
wwid 14f504e46494c455263507a354d4a2d447778732d59526c42
alias asmtest-3
}
multipath {
wwid 14f504e46494c45524c57657150642d6a4a31692d6b34706b
alias asmtest-4
}
}
[root@asm ~]# vi /etc/udev/rules.d/12-dm-permissions.rules
###test udev,fuck udev
ENV{DM_NAME}=="asm-1",NAME="disk1", OWNER:="grid", GROUP:="asmadmin", MODE:="660"
ENV{DM_NAME}=="asm-2",NAME="disk2", OWNER:="grid", GROUP:="asmadmin", MODE:="660"
ENV{DM_NAME}=="asm-3",NAME="disk3", OWNER:="grid", GROUP:="asmadmin", MODE:="660"
ENV{DM_NAME}=="asm-4",NAME="disk4", OWNER:="grid", GROUP:="asmadmin", MODE:="660"
ENV{DM_NAME}=="asmtest-1",NAME="disk5", OWNER:="grid", GROUP:="asmadmin", MODE:="660"
ENV{DM_NAME}=="asmtest-2",NAME="disk6", OWNER:="grid", GROUP:="asmadmin", MODE:="660"
ENV{DM_NAME}=="asmtest-3",NAME="disk7", OWNER:="grid", GROUP:="asmadmin", MODE:="660"
ENV{DM_NAME}=="asmtest-4",NAME="disk8", OWNER:="grid", GROUP:="asmadmin", MODE:="660"
[root@asm ~]# vi /etc/udev/rules.d/99-oracle-asmdevices.rules
###test udev fuck udev
KERNEL=="sd*", SUBSYSTEM=="block", ENV{DEVTYPE}=="disk", ENV{ID_SERIAL}=="14f504e46494c45524c61687330622d6d7976762d38366436", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*", SUBSYSTEM=="block", ENV{DEVTYPE}=="disk", ENV{ID_SERIAL}=="14f504e46494c45527343435876352d6b4573622d57476871", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*", SUBSYSTEM=="block", ENV{DEVTYPE}=="disk", ENV{ID_SERIAL}=="14f504e46494c45526763516767782d596d6e342d6469376a", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*", SUBSYSTEM=="block", ENV{DEVTYPE}=="disk", ENV{ID_SERIAL}=="14f504e46494c455274586b3178522d427434452d33766970", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*", SUBSYSTEM=="block", ENV{DEVTYPE}=="disk", ENV{ID_SERIAL}=="14f504e46494c45524874693033372d70366d462d4e746773", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*", SUBSYSTEM=="block", ENV{DEVTYPE}=="disk", ENV{ID_SERIAL}=="14f504e46494c45523775516558502d6a7755432d6741787a", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*", SUBSYSTEM=="block", ENV{DEVTYPE}=="disk", ENV{ID_SERIAL}=="14f504e46494c455263507a354d4a2d447778732d59526c42", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*", SUBSYSTEM=="block", ENV{DEVTYPE}=="disk", ENV{ID_SERIAL}=="14f504e46494c45524c57657150642d6a4a31692d6b34706b", OWNER="grid", GROUP="asmadmin", MODE="0660"
[root@asm ~]# start_udev
Starting udev: [ OK ]
grid用户
[grid@asm ~]$ export ORACLE_SID=+ASM
[grid@asm ~]$ sqlplus / as sysasm #以sysasm登陆
SQL> select group_number,name,type,total_mb,free_mb from v$asm_diskgroup; 查询
GROUP_NUMBER NAME TYPE TOTAL_MB FREE_MB
------------ ---------- ------------ ---------- ----------
1 DATA EXTERN 10240 7958
SQL> select NAME,PATH,total_mb,free_mb from v$asm_disk; 查询
NAME PATH TOTAL_MB FREE_MB
---------- -------------------- ---------- ----------
DATA_0000 /dev/disk1 5120 3979
DATA_0001 /dev/disk2 5120 3979
/dev/disk4 0 0
/dev/disk3 0 0
/dev/disk6 0 0
/dev/disk5 0 0
/dev/disk7 0 0
/dev/disk8 0 0
8 rows selected.
SQL> alter diskgroup DATA add disk '/dev/disk5' rebalance power 11; #加入新盘
Diskgroup altered.
SQL> alter diskgroup DATA add disk '/dev/disk6' rebalance power 11; #加入新盘
Diskgroup altered.
SQL> select * from v$asm_operation;
GROUP_NUMBER OPERA STAT POWER ACTUAL SOFAR EST_WORK EST_RATE EST_MINUTES ERROR_CODE
------------ ----- ---- ---------- ---------- ---------- ---------- ---------- ----------- -----------
1 REBAL RUN 11 11 637 840 1202 0
SQL> select * from v$asm_operation;
no rows selected
SQL> select NAME,PATH,total_mb,free_mb from v$asm_disk;
NAME PATH TOTAL_MB FREE_MB
---------- -------------------- ---------- ----------
/dev/disk8 0 0
/dev/disk7 0 0
/dev/disk3 0 0
/dev/disk4 0 0
DATA_0002 /dev/disk5 5120 4550
DATA_0003 /dev/disk6 5120 4550
DATA_0000 /dev/disk1 5120 4547
DATA_0001 /dev/disk2 5120 4547
8 rows selected.
SQL> select group_number,name,type,total_mb,free_mb from v$asm_diskgroup;
GROUP_NUMBER NAME TYPE TOTAL_MB FREE_MB
------------ ---------- ------ ---------- ----------
1 DATA EXTERN 20480 18194
SQL> alter diskgroup DATA drop disk 'DATA_0000' rebalance power 11; #删除旧盘
Diskgroup altered.
SQL> alter diskgroup DATA drop disk 'DATA_0001' rebalance power 11; #删除旧盘
Diskgroup altered.
SQL> select name,path,state from v$asm_disk; #查询
NAME PATH STATE
---------- -------------------- --------
/dev/disk8 NORMAL
/dev/disk7 NORMAL
/dev/disk3 NORMAL
/dev/disk4 NORMAL
DATA_0002 /dev/disk5 NORMAL
DATA_0003 /dev/disk6 NORMAL
DATA_0000 /dev/disk1 DROPPING
DATA_0001 /dev/disk2 DROPPING
8 rows selected.
SQL> select * from v$asm_operation;
GROUP_NUMBER OPERA STAT POWER ACTUAL SOFAR EST_WORK EST_RATE EST_MINUTES ERROR_CODE
------------ ----- ---- ---------- ---------- ---------- ---------- ---------- ----------- ----------
1 REBAL RUN 11 11 826 1029 945 0
SQL> select * from v$asm_operation;
no rows selected
[grid@asm ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE asm
ora.LISTENER.lsnr
ONLINE ONLINE asm
ora.asm
ONLINE ONLINE asm Started
ora.ons
OFFLINE OFFLINE asm
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
1 ONLINE ONLINE asm
ora.diskmon
1 OFFLINE OFFLINE
ora.evmd
1 ONLINE ONLINE asm
ora.orcl.db
1 ONLINE ONLINE asm Open
SQL> select name,path,state from v$asm_disk;
NAME PATH STATE
---------- -------------------- --------
/dev/disk8 NORMAL
/dev/disk7 NORMAL
/dev/disk1 NORMAL
/dev/disk2 NORMAL
/dev/disk4 NORMAL
/dev/disk3 NORMAL
DATA_0002 /dev/disk5 NORMAL
DATA_0003 /dev/disk6 NORMAL
8 rows selected.
SQL> select group_number,name,type,total_mb,free_mb from v$asm_diskgroup;
GROUP_NUMBER NAME TYPE TOTAL_MB FREE_MB
------------ ---------- ------ ---------- ----------
1 DATA EXTERN 10240 7958
删除完旧盘后,修改udev相关配置文件,修改multipath.conf配置文件,重启iscsi和multipath服务,
重启主机后,旧存储即可移除。
SQL> select name,path,state from v$asm_disk;
NAME PATH STATE
---------- -------------------- --------
/dev/disk8 NORMAL
/dev/disk7 NORMAL
DATA_0003 /dev/disk6 NORMAL
DATA_0002 /dev/disk5 NORMAL
SQL> select name from v$datafile;
NAME
---------------------------------------------
+DATA/orcl/datafile/system.256.948366147
+DATA/orcl/datafile/sysaux.257.948366147
+DATA/orcl/datafile/undotbs1.258.948366149
+DATA/orcl/datafile/users.259.948366149
+DATA/orcl/datafile/example.269.948366277
SQL> select member from v$logfile;
MEMBER
--------------------------------------------
+DATA/orcl/onlinelog/group_3.266.948366249
+DATA/orcl/onlinelog/group_3.267.948366249
+DATA/orcl/onlinelog/group_2.264.948366245
+DATA/orcl/onlinelog/group_2.265.948366247
+DATA/orcl/onlinelog/group_1.262.948366243
+DATA/orcl/onlinelog/group_1.263.948366243
6 rows selected.
SQL> select name from v$controlfile;
NAME
---------------------------------------------
+DATA/orcl/controlfile/current.261.948366239
+DATA/orcl/controlfile/current.260.948366239