如何将Oracle转储文件传输到AWS RDS实例? [英] How to transfer Oracle dump file to AWS RDS instance?

问题描述

我在EC2实例上已有一个.dmp文件，该文件可以访问在AWS上运行Oracle 11g的RDS实例.

I have an existing .dmp file on EC2 instance which has access to RDS instance running Oracle 11g on AWS.

我已阅读在AWS RDS中导入数据，看来AWS不支持这种直接转移.

I have read Importing Data in AWS RDS, it seems that AWS does not support this kind of direct transfer.

它确实需要有一个Source Oracle DB，您必须在其中创建/导出.dmp文件，然后可以通过建立数据库链接将其传输到destination RDS instance.

It does require to have a Source Oracle DB from where you have to create/export a .dmp file which you can then transfer to destination RDS instance by establishing a db link.

我的问题是，有什么方法可以将我现有的.dmp文件传输/导入到RDS实例上的DATA_DUMP_DIR吗?

My question is, is there a way I can transfer/import my existing .dmp file to the DATA_DUMP_DIR on RDS Instance?

有什么建议吗?

推荐答案

最终，我不得不启动另一个AWS实例，在其上安装Oracle XE，然后将转储文件放在DATA_PUMP_DIR&然后按照AWS RDS Data Import指南进行操作.

Eventually, I had to spin up another AWS Instance, Install Oracle XE on it, then place my dump file in the DATA_PUMP_DIR & then follow the AWS RDS Data Import guide.

很烦人的是，没有其他方法可以做到这一点.而且，没有SSH访问RDS实例的能力就等于加了！ 另外，AWS Doc尚不清楚细节.

It's pretty annoying that there is no other way to do this. And having no SSH access to the RDS instace just adds up to that! Also, the AWS Doc is not clear about the particulars.

这篇关于如何将Oracle转储文件传输到AWS RDS实例?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！