如何将oracle转储文件上传到oracle数据库:AWS RDS [英] How to upload oracle dump file to oracle database: AWS RDS

问题描述

我的AWS ec2实例中有oracle转储文件，我想将此转储文件导入AWS RDS中的Oracle数据库.

I have oracle dump file in my AWS ec2 instance, I want to import this dump file to Oracle database in AWS RDS.

我尝试与Oracle SQL Developer以及Perl脚本一起使用.

I tried using with Oracle SQL developer and also using Perl script.

https://docs.aws.amazon .com/AmazonRDS/latest/UserGuide/Oracle.Procedural.Importing.html

如何导入oracle转储从ec2实例到AWS中的RDS

使用Oracle SQL Developer方法，未启用数据库复制"选项. 使用Perl，在运行脚本时会出现很多错误.

Using Oracle SQL Developer method, the 'Database Copy' option is not enabled. Using Perl, getting a lot of error while running the script.

[root@ip-172-28-1-70 oracle]# perl dump_exp.pl     
install_driver(Oracle) failed: Can't locate DBD/Oracle.pm in @INC (@INC contains: /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .) at (eval 4) line 3.
    Perhaps the DBD::Oracle perl module hasn't been fully installed,
    or perhaps the capitalisation of 'Oracle' isn't right.
    Available drivers: DBM, ExampleP, File, Gofer, Mem, Proxy, SQLite, Sponge.
     at dump_exp.pl line 23.

这两种方法都不适合我，并且不了解Perl.

this both methods are not working for me, and am not aware of Perl.

请告诉我是否有更好的方法.

Please suggest me if have any better method.

推荐答案

AWS RDS不允许目录访问.

AWS RDS does not allow directory access.

1. 您需要在Amazon EC2上安装Oracle XE.
2. 在Oracle XE和Oracle RDS之间的Oracle XE EC2上创建db_link.
3. 在Oracle XE和Oracle RDS之间使用db_link传输文件 使用过程DBMS_FILE_TRANSFER.

1. You need install Oracle XE on Amazon EC2.
2. Create db_link on Oracle XE EC2 between Oracle XE and Oracle RDS.
3. Use a db_link between Oracle XE and Oracle RDS to transfer files using the procedure DBMS_FILE_TRANSFER.

如果可以使用原始导出exp进行导出， 您可以使用oracle客户端和原始导入实用程序imp从任何工作站导入.

If you can export using the original export exp, you can import from any workstation with oracle client and the original import utility imp.

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