🚀 Oracle RAC Database: Must-Know Daily Commands for Every DBA 🛠️
As a DBA working with Oracle RAC (Real Application Clusters), managing and maintaining a high-availability environment is critical. Here are some essential commands that every DBA should have in their toolkit for daily operations.
🔍 Instance and Cluster Monitoring
1️⃣ Check Cluster Status:
crsctl check cluster
2️⃣ Check Clusterware Components:
crsctl stat res -t
3️⃣ Check ASM Instance Status:
sqlplus / as sysasm
SQL> select instance_name, status from v$instance;
💾 Database and Instance Management
4️⃣ Verify Instance Status:
srvctl status database -d
5️⃣ Start or Stop a Database:
srvctl start database -d
srvctl stop database -d
6️⃣ Start or Stop a Specific Instance:
srvctl start instance -d -i
srvctl stop instance -d -i
🧹 Log and Performance Analysis
7️⃣ Check Alert Logs:
adrci
adrci> show alert -tail -f
8️⃣ Check Cluster Log File:
cat /u01/app/grid/diag/crs//crs/trace/alert.log
9️⃣ Check Active Sessions and Locks:
sqlplus / as sysdba
SQL> select sid, serial#, username, machine, status from v$session;
SQL> select * from dba_lock;
🛠️ Resource and Node Management
🔟 Check Node Status:
olsnodes -n
1️⃣1️⃣ List All Resources:
crsctl stat res -t
1️⃣2️⃣ Relocate a Service to Another Instance:
srvctl relocate service -d -s -i -t