|
Size: 700
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 | |
| Line 2: | Line 3: |
= 本文目的 = 在执行存储迁移之前, 收集Oracle RAC环境相关信息, 主要为ASM存储方面的内容. 在开始之前请打开putty或其它ssh远程工具的日志记录, 以便保存相关输出, 并把结果文件拷贝出来. |
|
| Line 3: | Line 10: |
| Linux Login as root user | Linux Login as '''root''' user |
| Line 5: | Line 12: |
| == 检查多路径状态 == {{{ # multipath -ll 或者(如果使用EMC存储的PowerPath则使用如下命令) # powermt display dev=all }}} * 查看 powerpath 版本 {{{ powermt version }}} == 查看磁盘的分区和挂载情况 == {{{ # blkid; lsblk -o +fstype,label,uuid }}} == 收集sosreport(如果可能) == 收集完之后的日志文件将打包在/tmp目录 |
|
| Line 8: | Line 39: |
| 示例文件 ''/tmp/sosreport-rac01-20221121153948.tar.xz'' | |
| Line 9: | Line 41: |
| = Oracle = | = GRID = Linux Login as '''grid''' user |
| Line 11: | Line 44: |
| Linux Login as grid user | |
| Line 16: | Line 48: |
| Linux Login as grid user | Linux Login as '''grid''' user |
| Line 21: | Line 53: |
| == 确认ASM磁盘相关属性 == | |
| Line 36: | Line 69: |
| == 检查多路径状态 == | == 查看Cluster相关状态 == |
| Line 38: | Line 71: |
| multipath -ll | crsctl status resource -t ocrcheck crsctl query css votedisk |
| Line 40: | Line 75: |
| == 查看磁盘的分区和挂载情况 == | = ORACLE = Linux Login as '''oracle''' user == 查看数据库状态 == |
| Line 43: | Line 82: |
| blkid; lsblk -o +fstype,label,uuid | $ sqlplus / as sysdba |
| Line 45: | Line 84: |
| 以下为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;