Any solutions to upgrade RDS Oracle zerodowntime

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 :

1. https://aws.amazon.com/blogs/database/upgrading-amazon-rds-for-oracle-database-engine-with-minimal-downtime-using-aws-dms/
2. https://aws.amazon.com/blogs/database/achieve-minimal-downtime-for-major-and-minor-version-upgrades-of-amazon-rds-for-oracle-using-oracle-goldengate/
3. https://aws.amazon.com/blogs/database/best-practices-for-upgrading-amazon-rds-for-oracle-db-instances-from-12c-to-19c/