# 數據庫整體
srvctl status database -d zwc
# 單實例
srvctl status instance -d zwc -i zwc1
# 節點應用
srvctl status nodeapps -n vzwc1
# ASM 實例
srvctl status asm -n vzwc1
srvctl config database -d zwc
srvctl config nodeapps -n vzwc1 -a -g -s -l # VIP/GSD/ONS/Listener
srvctl config asm -n vzwc1
-- 實例運行狀態
SELECT inst_id, instance_number, instance_name, parallel, status, database_status, active_state, host_name
FROM gv$instance;
-- 所有數據文件/日志/控制文件/臨時文件 (ASM 路徑)
SELECT name FROM v$datafile
UNION SELECT member FROM v$logfile
UNION SELECT name FROM v$controlfile
UNION SELECT name FROM v$tempfile;
# OCR 位置與完整性
ocrcheck
# Voting Disk
crsctl query css votedisk
# Clusterware 版本
crsctl query crs activeversion
# 所有資源狀態
crs_stat -t
export ORACLE_SID=zwc1
emctl stop dbconsole
srvctl stop instance -d zwc -i zwc1
srvctl stop asm -n vzwc1
srvctl stop nodeapps -n vzwc1
export ORACLE_SID=zwc1
srvctl start nodeapps -n vzwc1
srvctl start asm -n vzwc1
srvctl start instance -d zwc -i zwc1
emctl start dbconsole
srvctl start database -d zwc
srvctl stop database -d zwc
停:DB → ASM → NodeApps;啟:NodeApps → ASM → DB,EM 最後停最先啟。