open a file on a remote server amazon rds oracle

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.
Focker513Asked:
Who is Participating?
 
Focker513Connect With a Mentor Author Commented:
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
 
Abhimanyu SuriSr Database EngineerCommented:
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
 
Focker513Author Commented:
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
 
Focker513Author Commented:
Found the issue myself
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.