A company runs an Oracle database on premises. As part of the company’s migration to AWS, the company wants to upgrade the database to the most recent available version. The company also wants to set up disaster recovery (DR) for the database. The company needs to minimize the operational overhead for normal operations and DR setup. The company also needs to maintain access to the database's underlying operating system.
Which solution will meet these requirements?
The best solution for this company's requirements is to migrate the Oracle database to Amazon RDS Custom for Oracle and create a read replica in another AWS Region. Amazon RDS Custom allows the company to maintain access to the database's underlying operating system, which is a specific need outlined in the question. Additionally, it provides a managed service that minimizes operational overhead, as regular database maintenance tasks like backups, patching, and monitoring are handled automatically. Although direct cross-region read replicas are not currently supported, this setup allows for robust disaster recovery options while maintaining access to the OS.
Option C since RDS Custom has access to the underlying OS and it provides less operational overhead. Also, a read replica in another Region can be used for DR activities. https://aws.amazon.com/blogs/database/implementing-a-disaster-recovery-strategy-with-amazon-rds/
You can't create cross-Region replicas in RDS Custom for Oracle: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/custom-rr.html#custom-rr.limitations
It should be C: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/rds-custom.html and https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/working-with-custom-oracle.html
how it is C when the read replica is not meant for DR
If the source DB instance fails, you can promote your Read Replica to a standalone source server.
Its straight forward guys, only D provides the DR solution and no other options do, so D is the right answer
RDS Custom is the only DB that provides access to the underlying OS
A. Migrate the Oracle database to an Amazon EC2 instance. Set up database replication to a different AWS Region. Explanation: Migrating the Oracle database to an Amazon EC2 instance allows the company to maintain full control over the database, including access to the underlying operating system. Setting up database replication to a different AWS Region ensures disaster recovery with minimal operational overhead.
Option C and B Do Not provide disaster recovery which is part of question. Overall, option D provides a managed solution with minimal operational overhead, automated backups, disaster recovery capabilities, and high availability while meeting the requirement of maintaining access to the underlying operating system. Create a standby database in another Availability Zone.
Has to be C, since they need access to the OS: “ require access to the underlying OS and DB environment” https://aws.amazon.com/about-aws/whats-new/2021/10/amazon-rds-custom-oracle/
Only A and C will provide the access to the underlying infrastructure. C is the best option as it is the managed service from AWS.
RDS Custom makes it possible for you as a database administrator to access and customize your database environment and operating system. With RDS Custom, you can customize to meet the requirements of legacy, custom, and packaged applications. Amazon RDS Custom for Oracle supports read replicas that are built on Data Guard technology, and you can use these replicas to offload reads from the primary and for disaster recovery
Vote C https://aws.amazon.com/blogs/database/part-2-implement-multi-master-replication-with-rds-custom-for-oracle-high-availability-disaster-recovery/ The second node can be used as read replica and serve for DR
option B
Option B: By activating Cross-Region automated backups, Amazon RDS will automatically back up the database and replicate the snapshots to another AWS Region. This provides disaster recovery capabilities, ensuring data availability even in the event of a Region-wide outage.
"The company also needs to maintain access to the database's underlying operating system"
(A) goes too far with EC2, increasing operational overhead for normal operations. (C) with RDS Custom for Oracle is better. see f761d0e post for link.
C. Migrate the Oracle database to Amazon RDS Custom for Oracle. Create a read replica for the database in another AWS Region. Explanation: Amazon RDS Custom for Oracle: Amazon RDS Custom for Oracle allows the company to run Oracle databases on managed instances in the AWS Cloud. It provides managed services for tasks such as backups, patching, and monitoring, minimizing operational overhead for normal operations. Read Replica in Another AWS Region: By creating a read replica for the database in another AWS Region, the company can set up disaster recovery (DR) with minimal operational overhead. Amazon RDS automatically handles replication between the primary database and the read replica, ensuring data consistency and minimizing management tasks for DR setup.
RDS Custom
Answer C is not correct as cross-Region replicas in RDS Custom for Oracle are not allowed as stated by a previous answe. Correct answer: B https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ReplicateBackups.html Low operational overhead since the backup is automated.
B doesnt give you access to the underlying OS
C for sure
Defintely not C. You cannot create a read replica of RDS custom for Oracle in a different region: https://aws.amazon.com/blogs/database/build-high-availability-for-amazon-rds-custom-for-oracle-using-read-replicas/