How to access the standby RDS

Question

Is there a way to access the multi-AZ Oracle RDS using the AWS management console or Oracle Sql Developer similar to the primary RDS or not?

If the Primary DB fails, does AWS automatically switch over to standby RDS or not? How can I test this switch?

Accepted Answer

Amazon RDS for Oracle Multi-AZ has one standby https://aws.amazon.com/rds/features/multi-az/#Comparison_Table where the standby DB instance is only a passive failover target for high availability. The standby copy is not considered an active database, and can't be queried by applications.

If the primary database instance becomes unavailable the endpoint DNS name that you connect to is redirected to the secondary (which will be now have been promoted to become the new primary) https://aws.amazon.com/blogs/aws/multi-az-option-for-amazon-rds-oracle/

if you want to test this you can reboot the database and that will force a failover event to occur https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_RebootInstance.html

Answer

Hello.  
> Is there a way to access the multi-AZ Oracle RDS using the AWS management console or Oracle Sql Developer similar to the primary RDS or not?

For multi-AZ DB instances, it is not possible to connect to standby.  
Multi-AZ clusters can be connected to the lead replica.  
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/multi-az-db-clusters-concepts.html

> If the Primary DB fails, does AWS automatically switch over to standby RDS or not? How can I test this switch?

Yes, in case of failure, the system automatically switches to standby.  
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Concepts.MultiAZSingleStandby.html

It is possible to failover on reboot.  
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_RebootInstance.html

How to access the standby RDS

Relevant content