DR Drill in Oracle RAC 19c

 Successfully Completed DR Drill in Oracle RAC 19c! 
Performing a Disaster Recovery (DR) Drill is a crucial step in ensuring business continuity and validating our DR strategy. Recently, I had the opportunity to execute a DR drill in an Oracle RAC 19c environment, and I wanted to share some key steps and commands used during the process.

Key Steps in DR Drill:
 Check Primary Database & Standby Readiness
 Simulate Failover & Switchover Scenarios
 Perform Role Transition (Primary <-> Standby)
 Validate Data Integrity & Performance
 Reinstate Original Primary (if required)

Key Oracle Commands Used in DR Drill:

 Check Data Guard Configuration:

DGMGRL> show configuration;
DGMGRL> show database primary_db;
DGMGRL> show database standby_db;

 Perform Switchover to Standby (Planned Activity):

DGMGRL> switchover to standby_db;
 Perform Failover (Unplanned Disaster Recovery):

DGMGRL> failover to standby_db;
 Convert Standby Back to Primary (After Failover):

DGMGRL> reinstate database primary_db;
 Verify Redo Apply & Sync Status:

DGMGRL> show database standby_db status;
 Start Managed Recovery in Standby (If Required):

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
The DR drill was a great success, ensuring that the standby database can seamlessly take over in case of a failure. Regular DR drills help organizations stay prepared for high availability and disaster recovery challenges.