Managing Oracle RAC 19c involves dynamic scalability and configuration changes to meet business needs. Whether you’re scaling up by adding an instance or scaling down by deleting one, here’s a step-by-step guide for DBAs to handle these tasks effectively. 💡
🔧 Steps to Add an Instance in Oracle RAC 19c:
1️⃣ Check the Existing Instances and Database Status
Run the following command to verify the current setup:
srvctl status database -d
2️⃣ Prepare the Node for the New Instance
Ensure the new RAC node is properly configured with Grid Infrastructure and ASM.
3️⃣ Add the New Instance
Use the srvctl add instance command:
srvctl add instance -d -i -n
: Name of the RAC database.
: Name of the new instance.
: Name of the node where the instance will be added.
4️⃣ Start the New Instance
After adding the instance, start it using:
srvctl start instance -d -i
5️⃣ Verify the Configuration
Check the status to confirm that the instance is running:
srvctl status database -d
❌ Steps to Delete an Instance in Oracle RAC 19c:
1️⃣ Stop the Instance to Be Deleted
First, stop the instance on the node:
srvctl stop instance -d -i
2️⃣ Remove the Instance Configuration
Run the following command to delete the instance:
srvctl remove instance -d -i
3️⃣ Verify the Deletion
Confirm the instance has been removed:
srvctl config database -d
4️⃣ Clean Up the Environment
Remove any related data files, traces, or audit logs from the node if necessary..
check out the complete steps here :
Feel free to reach out to our WhatsApp community: https://lnkd.in/gydEisDp
✅ Things to Keep in Mind:
Always perform these tasks in a planned maintenance window to minimize service disruption.
Take a backup of the database before adding or deleting an instance.
Ensure proper listener configuration for the new or updated instance.