CODEWITHSUNDEEP
oracle-databaseamazon-web-servicesamazon-s3amazon-rdssnapshot
Krishna Moorthy
Krishna Moorthy

Reputation: 113

Amazon RDS Oracle DB snapshot restore in different account

Want to restore DB Snapshot of Oracle from one account(prd) to another account(non-prd) in same region. Could you please suggest the ways how can i achieve the DB restore for oracle in RDS?

whether i can store the DB snapshot in Amazon S3 and try to restore it or is there any alternate method to try it?

I have seen samples for storing the SQL snapshot in S3 and restoring it but whether its possible for oracle. And do we need to create profiles/users/tablespaces in rds oracle before importing the data or it will be taken care of when we restoring it from S3.

Upvotes: 1

Views: 532

Answers (1)

John Rotenstein
John Rotenstein

Reputation: 269881

The flow would be:

All these operations are managed by Amazon RDS. There is no need to create tables or use Amazon S3. The new database will contain exactly the same data as the source database.

Upvotes: 1

Related Questions