- Newest
- Most votes
- Most comments
Howdy Russell,
It looks like you are trying to use Data Pump to import an RMAN backup, which won't work. Data Pump can only import from dump files created by Data Pump. The RDSADMIN_RMAN_UTIL creates standard RMAN backupsets for restore on a customer-managed instance using RMAN (RMAN restore isn't supported for Amazon RDS for Oracle DB instances).
To use your import.sql, you would need to use dump files creates using DBMS_DATAPUMP or expdp.
Hope this helps. Thanks!
Michael
Hi MichaelB@AWS,
Thank you for the fast reply. :)
Thanks for clearing up the RMAN/data pump confusion I had. I'm now using expdp instead of the RMAN util. For anyone who comes across this post and needs a little more help, this is what I'm running from my EC2 instance which has a configured tnsnames.ora file:
expdp <user>/<pass>@<database> directory=data_pump_dir dumpfile=<tablespace_name>.dmp tablespaces=<tablespace_name>
In the above, <database> is a net_service_name defined in tnsnames.ora:
https://docs.oracle.com/database/121/NETRF/tnsnames.htm#NETRF260
- RussG
Relevant content
- asked 4 months ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 6 months ago
- AWS OFFICIALUpdated a year ago