Oracle RAC Administration Scripts via CRSCTL -3

Hi,

Hi, I will share Oracle RAC Administration Scripts in this post.

 

 

Read previous article before this.

 

 

Oracle DBA can administer Oracle Clusterware using the Oracle Clusterware Control (CRSCTL) utility.

I will continue to explain fundamental crsctl command.

 

 

To Query Voting disk location, execute following command. Set ASM profile before executing crsctl command.

[oracle@MehmetSalih ~]$ crsctl query css votedisk
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
1. ONLINE bd81ab8e27a64fbebf7b6b326c5f614d (/dev/mapper/HDD_E0_S03_1418288932p1) [DATA]
2. ONLINE 450684e276874ff9bff52d481befa809 (/dev/mapper/HDD_E0_S15_1420185788p1) [DATA]
3. ONLINE fd1efd6de5204f6bbfe9793a480c517f (/dev/mapper/HDD_E0_S06_1423843312p1) [DATA]
Located 3 voting disk(s).

 

To find OCR files location, execute following command.

[root@MehmetSalih ~]# cat /etc/oracle/ocr.loc
#Device/file +DATA getting replaced by device +DATA/Deveci-c/OCRFILE/registry.255.923150247
ocrconfig_loc=+DATA/Deveci-c/OCRFILE/registry.255.923150247
local_only=false

[root@MehmetSalih ~]#
[root@MehmetSalih ~]#

 

 

To check the status of the Oracle Cluster registry , execute following command.

[root@MehmetSalih ~]# ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 4
Total space (kbytes) : 409568
Used space (kbytes) : 2412
Available space (kbytes) : 407156
ID : 2022573354
Device/File Name : +DATA
Device/File integrity check succeeded

Device/File not configured

Device/File not configured

Device/File not configured

Device/File not configured

Cluster registry integrity check succeeded

Logical corruption check succeeded

[root@MehmetSalih ~]#