RAC语句常识
RAC语句常识
1,查看CRS状态
crsctl check crs
crsctl check has
crsctl check cluster
crsctl check cluster -all
crsctl stat res -t
crsctl stat res -t -init
2,VOT磁盘查询
crsctl query css votedisk
3,Verify the integrity of OCR:
ocrcheck
4,查看资源状态
crsctl stat res -t
crsctl stat res -t -init
5,启动
crsctl start has
crsctl start cluster
crsctl start cluster -all
crsctl start cluster -n cqracdb1
[启动整个集群,包括OHASD在一个节点]
crsctl start crs
6,停止
crsctl stop cluster -n cqracdb1
crsctl stop cluster [-f]
crsctl stop cluster -all
crsctl stop has
[全部停止包括OHASD]
crsctl stop crs -all -f
7,查看数据库状态
srvctl status database -d cqdb
查看节点资源状态
srvctl status nodeapps
查看数据库的配置
srvctl config database -d cqdb
查看asm的配置
srvctl config asm -a
查看TNS配置
srvctl config listener -a
查看SCAN
srvctl status scan
停止数据库
srvctl stop instance -d cqdb -i "orcl3,orcl4" -o immediate
查询crs状态:
crsctl config crs
crsctl config has