- Newest
- Most votes
- Most comments
Short answer: No.
Oracle DataGuard Maximum Protection mode relies on a Logwriter that write to the local and remote instance at the same time and keeps blocking until both DBs commited that the change is written. If there is no way to write at least two copies of the data the database just does not allow any changes anymore.
In RDS however there can be situation where data is not written at two locations at the same time anymore, even if that are mostly edge cases, like a switchover to the standby instance because primary one is lost. You will be able to write to the promoted standby even if the primary is not yet up and in sync again.
From my personal experience most of the DG setups in Maximum Protection I have seen did rely on 3 nodes, to be able to still write even if one node goes down. And such a setup is not possible with RDS. but you would be able to do that on EC2.
Relevant content
- asked 2 years ago
- Accepted Answerasked 9 months ago
- AWS OFFICIALUpdated 5 months ago
- AWS OFFICIALUpdated 23 days ago
- AWS OFFICIALUpdated 2 months ago
- AWS OFFICIALUpdated 6 months ago