Copy snapshot to Europe (Milan)

0

Hi all.

I'm trying to copy a snapshot from EU (Frankfurt) to Milan but I receive the following error:

An internal error has occurred. Please try your query again at a later time. (Service: AmazonRDS; Status Code: 500; Error Code: InternalFailure; Request ID: af9c2f07-30ea-4f92-8609-a6b598adc685)

If this is not supported, is there another way to move my Oracle instance to the new region?

Thanks.

Alessandro

asked 4 years ago346 views
10 Answers
0
Accepted Answer

Please take a look at https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Oracle.Procedural.Importing.html

Many of the techniques described could be used to move a database between RDS Oracle in different regions.

HalTemp
answered 4 years ago
profile picture
EXPERT
reviewed 2 months ago
0

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

AWS
answered 4 years ago
0

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?

answered 4 years ago
0

Backup & Restore!

GF7
answered 4 years ago
0

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.

answered 4 years ago
0

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.

GF7
answered 4 years ago
0

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.

answered 4 years ago
0

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

answered 4 years ago
0

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:

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

Alessandro

answered 4 years ago
0

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

Thanks again to all who have responded.

Alessandro

answered 4 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions