前期准备工作
查看ASM磁盘组信息
- login in as grid user
$ asmcmd lsdg
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name MOUNTED EXTERN N 512 4096 1048576 5812280 665666 0 665666 0 N DATAVG/ MOUNTED EXTERN N 512 4096 1048576 204796 161066 0 161066 0 N REDOVG/
查看ASM 磁盘空间使用情况
- login in as grid user
$ asmcmd lsdsk -k
Total_MB Free_MB OS_MB Name Failgroup Failgroup_Type Library Label UDID Product Redund Path 1048586 120095 1048586 DATAVG_0003 DATAVG_0003 REGULAR System UNKNOWN /dev/oracleasm/disks/AFFDATA01p1 1048586 120095 1048586 DATAVG_0004 DATAVG_0004 REGULAR System UNKNOWN /dev/oracleasm/disks/AFFDATA02p1 1048586 120094 1048586 DATAVG_0005 DATAVG_0005 REGULAR System UNKNOWN /dev/oracleasm/disks/AFFDATA03p1 1048586 120092 1048586 DATAVG_0006 DATAVG_0006 REGULAR System UNKNOWN /dev/oracleasm/disks/AFFDATA04p1 808968 92644 808968 DATAVG_0007 DATAVG_0007 REGULAR System UNKNOWN /dev/oracleasm/disks/AFFDATA05p1 808968 92646 808968 DATAVG_0008 DATAVG_0008 REGULAR System UNKNOWN /dev/oracleasm/disks/AFFDATA06p1 102398 80534 102398 REDOVG_0002 REDOVG_0002 REGULAR System UNKNOWN /dev/oracleasm/disks/AFFREDO01p1 102398 80532 102398 REDOVG_0003 REDOVG_0003 REGULAR System UNKNOWN /dev/oracleasm/disks/AFFREDO02p1
$ sqlplus / as sysasm
SQL> set linesize 300
column path format a50
column NAME format a15;
select GROUP_NUMBER,DISK_NUMBER,HEADER_STATUS,MODE_STATUS,MOUNT_STATUS,STATE,total_mb,free_mb,NAME,PATH from v$asm_disk;
GROUP_NUMBER DISK_NUMBER HEADER_STATU MODE_ST MOUNT_S STATE TOTAL_MB FREE_MB NAME PATH
------------ ----------- ------------ ------- ------- -------- ---------- ---------- --------------- ----------------------------------------
0 0 CANDIDATE ONLINE CLOSED NORMAL 0 0 /dev/oracleasm/disks/EF570-REDO01p1
0 1 CANDIDATE ONLINE CLOSED NORMAL 0 0 /dev/oracleasm/disks/EF570-DATA05p1
0 2 CANDIDATE ONLINE CLOSED NORMAL 0 0 /dev/oracleasm/disks/EF570-DATA03p1
0 3 CANDIDATE ONLINE CLOSED NORMAL 0 0 /dev/oracleasm/disks/EF570-DATA01p1
3 2 MEMBER ONLINE CACHED NORMAL 102398 80534 REDOVG_0002 /dev/oracleasm/disks/AFFREDO01p1
2 4 MEMBER ONLINE CACHED NORMAL 1048586 120095 DATAVG_0004 /dev/oracleasm/disks/AFFDATA02p1
2 8 MEMBER ONLINE CACHED NORMAL 808968 92646 DATAVG_0008 /dev/oracleasm/disks/AFFDATA06p1
2 6 MEMBER ONLINE CACHED NORMAL 1048586 120092 DATAVG_0006 /dev/oracleasm/disks/AFFDATA04p1
2 7 MEMBER ONLINE CACHED NORMAL 808968 92644 DATAVG_0007 /dev/oracleasm/disks/AFFDATA05p1
3 3 MEMBER ONLINE CACHED NORMAL 102398 80532 REDOVG_0003 /dev/oracleasm/disks/AFFREDO02p1
2 5 MEMBER ONLINE CACHED NORMAL 1048586 120094 DATAVG_0005 /dev/oracleasm/disks/AFFDATA03p1
GROUP_NUMBER DISK_NUMBER HEADER_STATU MODE_ST MOUNT_S STATE TOTAL_MB FREE_MB NAME PATH
------------ ----------- ------------ ------- ------- -------- ---------- ---------- --------------- ----------------------------------------
2 3 MEMBER ONLINE CACHED NORMAL 1048586 120095 DATAVG_0003 /dev/oracleasm/disks/AFFDATA01p1
12 rows selected.
检查多路径状态
multipath –ll
mcposdb数据库存储迁移步骤
查看磁盘的分区和挂载情况
lsblk