RHEL6 Linux

Linux Login as root user

检查多路径状态

# multipath -ll

或者(如果使用EMC存储的PowerPath则使用如下命令)

# powermt display dev=all

查看磁盘的分区和挂载情况

# blkid; lsblk -o +fstype,label,uuid

收集sosreport(如果可能)

# sosreport

收集完之后的日志文件打包在/tmp目录 示例文件 /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;