What is the MOST effective method to minimize the recovery time objective (RTO) for a BaseDB database in the event of a complete DB system failure, assuming both cost and complexity are important considerations?
A.
Relying solely on regular full database backups.
B.
Using Oracle Data Guard with synchronous replication to a remote region.
C.
Using Oracle Data Guard with asynchronous replication to a different availability domain within the same region.
D.
Performing frequent incremental backups with block change tracking enabled.
E.
Implementing a custom script to regularly copy data files to a secondary block volume.
C. Using Oracle Data Guard with asynchronous replication to a different availability domain within the same region.
Asynchronous Replication:
Minimizes performance impact while ensuring data protection.
Placing standby in the same region reduces latency and cost.
Fast switchover reduces RTO.
Why the other options are less effective:
A. Full backups:Time-consuming for recovery.
B. Synchronous to a remote region:Increases latency and cost.
D. Incremental backups:Slower recovery process.
E. Custom script:Complex and less reliable than Data Guard.
[References:, Oracle Data Guard Documentation:High Availability, , ]
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit