Dear Customer - Thanks for reaching out to us via AWS re:Post. First of all, allow me the opportunity to apologize for the delay in response to this post. I checked it just now and started working on it. I see that you wanted advice on copying database from one account to another when there is option group with persistent or permanent options attached - As a workaround you can create new instance without TDE option and copy data using EXPDP/IMPDP and then take snapshot of new instance and share it in different AWS account.
Below are the high level steps required for this workaround .
- Create a new RDS instance with similar configuration but without any persistent/permanent options
- Take a export backup using datapump and copy the dump files to S3 using S3 integration
- Download the dump files in newly created instance and perform import using datapump.
- Now take snapshot of new instance having data imported
- Share this snapshot with any AWS account (as per your requirement)
Kindly refer below document [B] for S3 integration, [C] for importing data in RDS Oracle. Stay safe and have a nice day ahead !
[A] Limitation on TDE Snapshots. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_Tutorials.RestoringFromSnapshot.html https://aws.amazon.com/premiumsupport/knowledge-center/rds-snapshots-share-account/
[D] Import data from the dump created. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Oracle.Procedural.Importing.html#Oracle.Procedural.Importing.DataPump.DBLink
RDS PostgreSQL snapshot and restore to a different accountAccepted Answerasked 3 years ago
RDS Database Option for Customer Dataasked 2 months ago
AWS RDS Oracle: How to import database dump?asked 2 months ago
How to copy RDS database from Account A to Account Basked 8 months ago
How to restrict database users for RDS Postgres using AWS Managed AD trusted with customer on-prem ADAccepted Answerasked 2 years ago
Trying to copy a postgres instance from a local postgres server to an RDS instance via DMSasked 3 months ago
RDS custom stop temporarilyasked 20 days ago
Move postgres on EC2 to RDS in a different accountasked a year ago
Copying RDS Snapshot to another accountAccepted Answerasked 2 years ago
RDS Oracle EE optionsAccepted Answerasked 4 years ago