IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial
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.
[[email protected] ~]$ 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.
[[email protected] ~]# 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 [[email protected] ~]# [[email protected] ~]#
To check the status of the Oracle Cluster registry , execute following command.
[[email protected] ~]# 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 [[email protected] ~]#
1,078 views last month, 1 views today
