Copy snapshot to Europe (Milan)

Hi,
Cross-Region snapshot copy isn't supported in the following opt-in AWS Regions:
Africa (Cape Town)
Asia Pacific (Hong Kong)
Europe (Milan)
Middle East (Bahrain)

Ref: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_CopySnapshot.html

Thanks for confirming.

Can you advise on how I can migrate an existing Oracle RDS instance to that region? Or is this operation not currently supported?

Backup & Restore!

I thought a database snapshot was exactly that: a backup of my instance.

Are you saying there's another method to backup a db through the AWS console that is portable across regions?

Apologies if this is a stupid question, I'm really no expert in db administration.

I'm not sure about Oracle, but for all others engine it is possible.

With MySql/MariaDB/Aurora MySql:
-> Power on an ec2 instance and run mysqldump command. You will get the dump in your ec2 instance.
-> Create the rds instance in other region and restore the dump you generated.

With Postgres:
-> The same as mysql: pg_dump and then restore.

With SqlServer:
-> You can connect with management studio and run a backup in two ways: A store procedure that uploads a native backup to S3 or backup directly from management studio.
-> To restore the data you have to upload the backup to S3 and then run a store procedure to import.

This is what I have tested personally. There is other ways that I didn't tried like the export of the snapshot to S3. Then you can move it and restore as you would fill the database the first time.

I guess oracle has something similar if not better. Data pum, some kind of management studio where to perform these actions etc.

Thank you very much for taking time to reply.

I'll have to check if/how this is doable with Oracle (I imagine it is, but never tried before).

Cheers.

Thank you.

I'm trying to follow those instruction (specifically the section "Importing Data with Oracle Data Pump and an Amazon S3 Bucket"), but I get an error on step 3 when uploading the dump to S3:

[ERROR] The DB instance doesn't have credentials to access the specified Amazon S3 bucket. To grant access, add the S3_INTEGRATION role to the DB instance.

But I did add that option to my db: https://i.gyazo.com/0347a2a84582b392556fc5fa0c6b1a80.png

I also added the IAM role: https://i.gyazo.com/006590bba853cf3dba5eda64310bf614.png

Don't know what else I can try: can you help me?

Edited by: alilomapa on Jun 5, 2020 4:33 PM

I tried again today and now it worked: not sure if it was en error on my part or I just had to wait a bit for the changes to propagate. Anyway, I have now successfully uploaded the backup file to a S3 bucket.

Unfortunately I'm now facing the same issue when uploading to the destination db:

[ERROR] The DB instance doesn't have credentials to access the specified Amazon S3 bucket. To grant access, add the S3_INTEGRATION role to the DB instance.

But, when I open this newly created db in the AWS console, the "Manage IAM roles" section is missing. Also the left side menu has fewer options. This is what I see:

• in eu-central-1: https://i.gyazo.com/378c443144f560a336b9d332e13b1d57.png
• in eu-south-1: https://i.gyazo.com/14e7c5901eb59925e6a193362f02ff02.png

Have I done something wrong on db creation or is this region somehow "different"?

Alessandro

Never mind, I did it with a db link: way easier than fiddling around with S3.

Thanks again to all who have responded.

Alessandro