Any solutions to upgrade RDS Oracle zerodowntime
Dear guys I checked the document, it looks like it requires the downtime when we upgrade RDS Oracle. Do we have any solutions to avoid the downtime when we upgrade DB?
- 新しい順
- 投票が多い順
- コメントが多い順
When you upgrade an RDS for Oracle DB instance, this is an in-place upgrade and requires downtime for your applications during the upgrade process. The duration of the outage varies based on your engine version and the DB instance class. If the duration of the outage isn’t desirable for your application, an alternative approach is to use logical replication with AWS Database Migration Service (AWS DMS) to minimize downtime during the upgrade process. AWS DMS makes it easy to migrate data from a source data store to a target data store and replicate ongoing changes to keep sources and targets in sync. You can do a POC for the same.
References :
- https://aws.amazon.com/blogs/database/upgrading-amazon-rds-for-oracle-database-engine-with-minimal-downtime-using-aws-dms/
- https://aws.amazon.com/blogs/database/achieve-minimal-downtime-for-major-and-minor-version-upgrades-of-amazon-rds-for-oracle-using-oracle-goldengate/
- https://aws.amazon.com/blogs/database/best-practices-for-upgrading-amazon-rds-for-oracle-db-instances-from-12c-to-19c/
