25、集群中所有正在运行的实例 — (SQL)

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 racdb1 YES OPEN ACTIVE NORMAL rac1

2 2 racdb2 YES OPEN ACTIVE NORMAL rac2

26、所有数据库文件及它们所在的 ASM 磁盘组 — (SQL)

select name from v$datafile

union

select member from v$logfile

union

select name from v$controlfile

union

select name from v$tempfile;

27、ASM 磁盘卷 — (SQL) 
SELECT path
FROM   v$asm_disk;
PATH
----------------------------------
ORCL:CRSVOL1
ORCL:DATAVOL1
ORCL:FRAVOL1
28、关闭特定集群资源
启动ora.rac1.ons：
[grid@rac1 ~]$ crs_stop ora.rac1.ons
Attempting to stop `ora.ons` on member `rac1`
Stop of `ora.ons` on member `rac1` succeeded.
启动ora.rac1.ons：
[grid@rac1 ~]$ crs_start ora.rac1.ons
Attempting to start `ora.ons` on member `rac1`
Start of `ora.ons` on member `rac1` succeeded.
29、同时停掉和启动所有集群资源:
[grid@rac1 ~]$ crs_stop –all
[grid@rac1 ~]$ crs_start –all
30、停止和启动当前节点所有CRS资源
[grid@rac1 ~]$crsctl stop resources
[grid@rac1 ~]$crsctl start resources
31、使用srvctl停止和启动节点应用
[grid@rac1 ~]$ srvctl stop nodeapps -n rac1
[grid@rac1 ~]$ srvctl start nodeapps -n rac1