- Newest
- Most votes
- Most comments
Hello,
From your query, I can understand that you are trying to restore a database in your instance using DATAPUMP and need to create multiple databases in the same instance using that backup. However you are getting some errors in performing the same.
As you have mentioned that you are facing the following errors:
ORA-39001: invalid argument value
ORA-06512: in "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4929
ORA-06512: at "SYS.DBMS_DATAPUMP", line 5180
ORA-06512: in line 5
I would like to mention that these errors are quite generic errors and can happen due to even a minor syntax error. This error does not give much information about what actually is going wrong, hence, I would suggest raising a support case with AWS Premium Support so that the issue can be troubleshooted further. You can refer the following article to raise a case with the AWS Technical Support team:
[+] Contact AWS: https://aws.amazon.com/contact-us/
Furthermore, you can refer the following documentation which mentions how you can use the DATAPUMP Utility for RDS Oracle while importing your backups:
[+] Importing using Oracle Data Pump: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Oracle.Procedural.Importing.DataPump.html
Hi, An ORA-39001 error indicates that a parameter in the calls to DBMS_DATAPUMP is invalid. In your case, The error stack indicates that the error occurs on line 5 of the PL/SQL block, indicating that one of the parameters in below line is incorrect
DBMS_DATAPUMP.ADD_FILE( handle => hdnl, filename => 'exp_dbsystem.dmp', directory => 'DATA_PUMP_DIR', filetype => dbms_datapump.ku$_file_type_dump_file);
Please check the dump file referenced in the DBMS_DATAPUMP.ADD_FILE is correct and accessible, no permission issues etc.
Relevant content
- AWS OFFICIALUpdated 7 months ago
- AWS OFFICIALUpdated 4 years ago
- AWS OFFICIALUpdated 8 months ago
- AWS OFFICIALUpdated 6 months ago