|
Size: 4418
Comment:
|
← Revision 22 as of 2024-03-20 07:16:34 ⇥
Size: 1885
Comment:
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 1: | Line 1: |
| ## page was renamed from désert/Oracle/Collectioin <<TableOfContents()>> |
|
| Line 2: | Line 4: |
| = 前期准备工作 = == 查看ASM磁盘组信息 == * login in as grid user $ asmcmd lsdg |
= 本文目的 = 在执行存储迁移之前, 收集Oracle RAC环境相关信息, 主要为ASM存储方面的内容. 在开始之前请打开putty或其它ssh远程工具的日志记录, 以便保存相关输出, 并把结果文件拷贝出来. = RHEL6 Linux = Linux Login as '''root''' user == 检查多路径状态 == |
| Line 7: | Line 15: |
| 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/ |
# multipath -ll 或者(如果使用EMC存储的PowerPath则使用如下命令) # powermt display dev=all |
| Line 12: | Line 22: |
| == 查看ASM 磁盘空间使用情况 == * login in as grid user $ asmcmd lsdsk -k |
* 查看 powerpath 版本 |
| Line 16: | Line 25: |
| 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 |
powermt version |
| Line 27: | Line 28: |
| $ sqlplus / as sysasm | == 查看磁盘的分区和挂载情况 == |
| Line 29: | Line 31: |
| 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. |
# blkid; lsblk -o +fstype,label,uuid |
| Line 55: | Line 34: |
| == 检查多路径状态 == multipath –ll |
== 收集sosreport(如果可能) == 收集完之后的日志文件将打包在/tmp目录 {{{ # sosreport }}} 示例文件 ''/tmp/sosreport-rac01-20221121153948.tar.xz'' |
| Line 58: | Line 41: |
| = mcposdb数据库存储迁移步骤 = | = GRID = Linux Login as '''grid''' user == 查看ASM磁盘组信息 == {{{ $ asmcmd lsdg }}} == 查看ASM 磁盘空间使用情况 == Linux Login as '''grid''' user {{{ $ asmcmd lsdsk -k }}} |
| Line 60: | Line 53: |
| == 查看磁盘的分区和挂载情况 == lsblk |
== 确认ASM磁盘相关属性 == {{{ $ sqlplus / as sysasm }}} 以下为SQL代码 SQL> {{{ set linesize 300 column PATH format a60 column NAME format a16 SELECT group_number,disk_number,header_status,mode_status,mount_status,state,total_mb,free_mb,name,path FROM v$asm_disk; }}} == 查看Cluster相关状态 == {{{ crsctl status resource -t ocrcheck crsctl query css votedisk }}} = ORACLE = Linux Login as '''oracle''' user == 查看数据库状态 == {{{ $ sqlplus / as sysdba }}} 以下为SQL代码 SQL> {{{ SET linesize 200 COLUMN HOST_NAME FORMAT a30 SELECT name DB_NAME,INSTANCE_NAME,HOST_NAME,OPEN_MODE,version DB_VERSION,DATABASE_STATUS,DATABASE_ROLE,LOGINS,to_char(STARTUP_TIME,'DD-MON-YYYY HH24:MI:SS') "DB UP TIME" FROM v$database,gv$instance; }}} |
Contents
本文目的
在执行存储迁移之前, 收集Oracle RAC环境相关信息, 主要为ASM存储方面的内容.
在开始之前请打开putty或其它ssh远程工具的日志记录, 以便保存相关输出, 并把结果文件拷贝出来.
RHEL6 Linux
Linux Login as root user
检查多路径状态
# multipath -ll 或者(如果使用EMC存储的PowerPath则使用如下命令) # powermt display dev=all
* 查看 powerpath 版本
powermt version
查看磁盘的分区和挂载情况
# blkid; lsblk -o +fstype,label,uuid
收集sosreport(如果可能)
收集完之后的日志文件将打包在/tmp目录
# sosreport
示例文件 /tmp/sosreport-rac01-20221121153948.tar.xz
GRID
Linux Login as grid user
查看ASM磁盘组信息
$ asmcmd lsdg
查看ASM 磁盘空间使用情况
Linux Login as grid user
$ asmcmd lsdsk -k
确认ASM磁盘相关属性
$ sqlplus / as sysasm
以下为SQL代码
SQL>
set linesize 300 column PATH format a60 column NAME format a16 SELECT group_number,disk_number,header_status,mode_status,mount_status,state,total_mb,free_mb,name,path FROM v$asm_disk;
查看Cluster相关状态
crsctl status resource -t ocrcheck crsctl query css votedisk
ORACLE
Linux Login as oracle user
查看数据库状态
$ sqlplus / as sysdba
以下为SQL代码
SQL>
SET linesize 200 COLUMN HOST_NAME FORMAT a30 SELECT name DB_NAME,INSTANCE_NAME,HOST_NAME,OPEN_MODE,version DB_VERSION,DATABASE_STATUS,DATABASE_ROLE,LOGINS,to_char(STARTUP_TIME,'DD-MON-YYYY HH24:MI:SS') "DB UP TIME" FROM v$database,gv$instance;