RAC日常监控

所有实例和服务的状态

$ srvctl status database -d racdb
Instance orcl1 is running on node linux1
Instance orcl2 is running on node linux2

特定节点上节点应用程序的状态

$ srvctl status nodeapps -n linux1
VIP is running on node: linux1
GSD is running on node: linux1
Listener is running on node: linux1
ONS daemon is running on node: linux1

ASM 实例的状态

$ srvctl status asm -n linux1
ASM instance +ASM1 is running on node linux1.

列出配置的所有数据库

$ srvctl config database
racdb

集群中所有正在运行的实例

SELECT
inst_id
, instance_number inst_no
, instance_name inst_name
, parallel
, status
, database_status db_status
, active_state state
, host_name host
FROM gv$instance
ORDER BY inst_id;

INST_ID INST_NO INST_NAME PAR STATUS DB_STATUS STATE HOST
-------- -------- ---------- --- ------- ------------ --------- -------
1 1 orcl1 YES OPEN ACTIVE NORMAL rac1
2 2 orcl2 YES OPEN ACTIVE NORMAL rac2

位于磁盘组中的所有数据文件

select name from v$datafile
union
select member from v$logfile
union
select name from v$controlfile
union
select name from v$tempfile;

属于“ORCL_DATA1”磁盘组的所有 ASM 磁盘

SELECT path
FROM v$asm_disk
WHERE group_number IN (select group_number
from v$asm_diskgroup
where name = 'ORCL_DATA1');

PATH
----------------------------------
ORCL:VOL1
ORCL:VOL2

检查集群节点

/opt/ora10g/product/10.2.0/crs_1/bin/olsnodes -n

linux1 1

linux2 2

配置 Oracle 集群件功能

/opt/ora10g/product/10.2.0/crs_1/bin/crs_stat -t –v

检查 CRS 状态

/opt/ora10g/product/10.2.0/crs_1/bin/crsctl check crs

查看监听器

ps -ef | grep lsnr | grep -v 'grep' | grep -v 'ocfs' | awk '{print $9}'

[@more@]