HA, DR and monitoring for RDS Custom for Oracle

Question

Hi Team,
I am looking for HA within same AZ and DR across region options using RDS Custom for Oracle.
Also need to setup monitoring for HA and DR like replication lag and availability. 
Appreciate your help.

Thanks

anish_g · Accepted Answer

Hi,

You can achieve high availability for Amazon RDS Custom for Oracle instances using read replicas built on Oracle Data Guard technology.

With RDS Custom for Oracle, you can create up to five read replicas, which are managed physical standby databases using Data Guard configuration, however currently restricted to same region.

Please be informed that Cross-Region disaster recovery can be achieved using self-managed standby databases.

Sharing the below blogs with the details on RDS Custom read replica high availability solution,

* [Build high availability for Amazon RDS Custom for Oracle using read replicas](https://aws.amazon.com/blogs/database/build-high-availability-for-amazon-rds-custom-for-oracle-using-read-replicas/)

* [Automate high availability setup in Amazon RDS Custom for Oracle](https://aws.amazon.com/blogs/database/automate-high-availability-setup-in-amazon-rds-custom-for-oracle/)

You can refer to the below AWS Documentation for high availability for RDS Custom for Oracle for further details,

* [Working with high availability features for RDS Custom for Oracle](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/custom-managing.ha.html)

RDS Custom detects high replication lag and produces a "Replication has stopped" event. The replication status can be monitored using the describe-db-instances AWS CLI command, though there might be a delay in status updates. 
Reference Documentation,
* [External replica limitations for RDS Custom for Oracle](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/custom-rr.reqs-limitations.html#custom-rr.external-replica-reqs)

You can refer to the below different monitoring option available for RDS Custom for Oracle in comparison to RDS for Oracle,

* [Performance monitoring](https://docs.aws.amazon.com/prescriptive-guidance/latest/replatform-oracle-database-options/performance-monitoring.html)

Since RDS Custom for Oracle provides access to EC2 instance hosting the Oracle database, custom monitoring can be enabled as well, sharing sample custom monitoring solutions not specifically to read replica though which can be customized to your requirements,

* [Monitor Amazon RDS Custom for Oracle using Amazon CloudWatch](https://www.youtube.com/watch?v=buefWb4b2BY)

* [Using StatsD for monitoring Oracle databases running on Amazon RDS or Amazon EC2](https://aws.amazon.com/blogs/database/using-statsd-for-monitoring-oracle-databases-running-on-amazon-rds-or-amazon-ec2/)

Sharing below Oracle Vendor blog to setup OEM to monitor RDS Custom for Oracle to monitor different database metrics including replication status,

* [Monitoring Oracle Databases in AWS with Enterprise Manager](https://blogs.oracle.com/observability/post/monitoring-oracle-databases-in-aws-with-enterprise-manager)

anish_g · Answer

RDS provides automation for creating read replica for RDS Custom for Oracle with similar limitation of 5 read replicas.

Creating an RDS Custom for Oracle replica is similar to creating an RDS for Oracle replica, but with important differences. For general information about creating and managing Oracle replicas, see [Working with DB instance read replicas ](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ReadRepl.html) and [Working with read replicas for Amazon RDS for Oracle](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/oracle-read-replicas.html).

Reference Documentation : https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/custom-rr.html

You can follow the steps as mentioned in the blog post
[Create a read replica for an existing RDS Custom for Oracle instance](https://aws.amazon.com/blogs/database/build-high-availability-for-amazon-rds-custom-for-oracle-using-read-replicas/#:~:text=RDS_CUSTOM_ORCL_B-,Create%20a%20read%20replica%20for%20an%20existing%20RDS%20Custom%20for%20Oracle%20instance,-You%20can%20create)

HA, DR and monitoring for RDS Custom for Oracle

Add your answer

Relevant content