Backup and Restore Oracle RDS Cross Account at Schema and Table Level

For backing up and restoring Oracle RDS instances incrementally, cross-account, at the schema and tables level, without using AWS Data Migration Service (DMS), Oracle GoldenGate, RDS snapshots, or RMAN, consider the following options:

• Quest Foglight for Databases or Quest SharePlex: Offers real-time data replication and may support the required cross-account, incremental backups at a granular level.
• Dbvisit Standby: Specializes in Oracle databases for disaster recovery with real-time replication capabilities that could be adapted for specific backup scenarios.

It's vital to evaluate these solutions against your specific backup and restore requirements, considering factors like recovery objectives, acceptable downtime, and operational complexity.

Hello,

Please note, RDS Oracle backup for schema & table which is logical backups and it can be taken using Oracle datapump utility [1]. But note, this will not be incremental backups.

Furthermore, backups can be stored in S3 and cross account bucket policy can be set to access datapump backups and later can perform datapump import using s3 integration with RDS Oracle [2].

References

[1] https://repost.aws/knowledge-center/rds-oracle-instant-client-datapump [2] https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/oracle-s3-integration.html : Amazon S3 integration

I hope this helps.