Solved

open a file on a remote server amazon rds oracle

Posted on 2016-08-06
4
314 Views
Last Modified: 2016-08-11
I ran an export on an RDS server and am using the DBMS_FILE_TRANSFER.GET_FILE method to pull the dump file through the database link. I am also trying to pull the associated log file but I get errors:" ORA-19505: failed to identify file "/rdsdbdata/datapump/Export.LOG"
ORA-27046: file size is not a multiple of logical block size"

This is going from an Amazon RDS oracle instance to a Microsoft server so I get the block size mismatch, except that the dump files come across okay. My question is there a way to read the export log on a remote server into sqlplus or spool it on my end via stored procedure?
I queried the directory on the remote server and it does list export log file.
Source is Amazon RDS Oracle 11.2.0.4 and Destination is MS Oracle 12c.
0
Comment
Question by:Focker513
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 5

Expert Comment

by:Abhimanyu Suri
ID: 41745847
I don't have too much experience with RDS, but recently did an export over database link.

RDS user usually has EXP_FULL_DATABASE privilege, so if you create a DB link on local server to RDS connecting via RDS_USER and use it as an input for NETWORK_LINK in expdp,
Export dmp and log files will be created at local server but export will be run against RDS.

What I learnt from your question is another solution, but have to use it on RDS.
0
 

Author Comment

by:Focker513
ID: 41745866
exporting through a db_link takes too long so that will not be an option. And again, I can pull the dump file over without issue so need a way to copy the log file or read it.
Thanks
0
 

Accepted Solution

by:
Focker513 earned 0 total points
ID: 41745890
Found that it is an AWS bug: https://forums.aws.amazon.com/message.jspa?messageID=695006

And to read it run this command from the above link:
select * from table(RDSADMIN.RDS_FILE_UTIL.READ_TEXT_FILE('DATA_PUMP_DIR','filename.log'));
1
 

Author Closing Comment

by:Focker513
ID: 41751806
Found the issue myself
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the wake of AWS' S3 outage, we want to discuss the importance of storage and data diversification in the event of a hack, crash, or system disruption. We spoke with Experts Exchange’s COO Gene Richardson for a deeper understanding.
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question