Amazon RDS for Oracle now provides an automatic reconnection mechanism for applications to failover to a read replica promoted as the new primary database during a disaster recovery scenario, reducing recovery time and effort.

<div>
<p>This article discusses automatic reconnection to Amazon RDS for Oracle read replicas during disaster recovery scenarios like failover or switchover.</p>
<p>Specifically, the article covers:</p>
<ul>
<li>Solution overview and prerequisites</li>
<li>Steps to implement automatic reconnection by creating an Oracle service and trigger</li>
<li>Testing the solution with managed Oracle Data Guard switchover</li>
<li>Manually promoting a read replica to primary</li>
<li>Handling errors and cleaning up resources</li>
<li>Advantages of using this approach with Amazon RDS for Oracle</li>
</ul>
</div>


Automatic reconnection to Amazon RDS for Oracle read replicas during disaster recovery

Related articles

Related articles

Oct 7
2024
Load balancing strategies for Amazon RDS for SQL Server read replicas to scale read workloads and reduce latency

Nov 12
2025
Using delayed read replicas for Amazon RDS for PostgreSQL disaster recovery

Sep 10
2024
Create self-managed replicas for an Amazon RDS for Db2 instance for read scaling and disaster recovery

Oct 24
2024
Amazon RDS for Oracle now supports Oracle Application Express (APEX) Version 24.1