Modifying the Database Deployment Architecture for Minimal Cost and Downtime
Question
A large London based eCommerce company is running Oracle DB Systems Virtual Machine RAC database on Oracle Cloud Infrastructure (OCI) for their eCommerce application in the uk-london-1 region.
They are currently taking automatic backups of the database, as configured during the database provisioning activity.
They are launching a new product soon, which is expected to sell in large quantities all over the world.
The application architecture should have minimal cost, no data loss, no performance impacts during the database backup windows and should have minimal downtime.
What is the most efficient and cost-effective mechanism of modifying the database deployment architecture to meet these application goals? (Choose the best answer.)
Answers
Explanations
Click on the arrows to vote for the correct answer
A. B. C. D.D.
The objective of the eCommerce company is to modify their database deployment architecture in order to minimize cost, eliminate data loss, avoid performance impacts during the database backup windows, and minimize downtime. To achieve this, we need to consider the various options available and choose the best answer based on the requirements.
Option A: Launch a new VM RAC database in another availability domain, launch a compute instance, deploy Oracle GoldenGate on it and then configure it to replicate the data from the eCommerce Database over to the new VM RAC database using GoldenGate. Take backups from the new VM RAC database.
This option involves launching a new VM RAC database in another availability domain, deploying Oracle GoldenGate on a compute instance, and configuring it to replicate the data from the eCommerce database to the new VM RAC database. The backups will be taken from the new VM RAC database. While this solution could provide minimal downtime and no performance impacts during the database backup windows, it could be costly and complex to set up and maintain.
Option B: Turn off automatic backups from the eCommerce database, implement Oracle Active Data Guard with the standby database deployed on another availability domain, and take backups from the standby database.
This option involves turning off automatic backups from the eCommerce database and implementing Oracle Active Data Guard with the standby database deployed on another availability domain. The backups will be taken from the standby database. This solution could provide minimal downtime, no performance impacts during the database backup windows, and could be cost-effective, but it would still involve some data loss if the standby database has not caught up with the primary database.
Option C: Launch a new VM RAC database in another availability domain, launch a compute instance, deploy Oracle GoldenGate on it and then configure bi-directional replication from the eCommerce Database over to the new VM RAC database using GoldenGate. Take backup from the new VM RAC database.
This option is similar to option A, but instead of replicating data only in one direction, it involves bi-directional replication using GoldenGate. This solution could provide minimal downtime, no performance impacts during the database backup windows, and could be cost-effective. However, it could still be complex to set up and maintain.
Option D: Turn off automatic backups from the eCommerce database, implement Oracle Data Guard with the standby database deployed on another availability domain, take backups from the standby database.
This option is similar to option B, but instead of implementing Oracle Active Data Guard, it involves implementing Oracle Data Guard. This solution could provide minimal downtime, no performance impacts during the database backup windows, and could be cost-effective. It could also eliminate data loss by ensuring that the standby database is always up-to-date with the primary database.
Based on the requirements, the best answer is option D. It provides the most efficient and cost-effective mechanism of modifying the database deployment architecture to meet the application goals.
