[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 671
  • Last Modified:

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.
0
Focker513
Asked:
Focker513
  • 3
1 Solution
 
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 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
 
Focker513Author Commented:
Found the issue myself
0

Featured Post

Managing Security Policy in a Changing Environment

The enterprise network environment is evolving rapidly as companies extend their physical data centers to embrace cloud computing and software-defined networking. This new reality means that the challenge of managing the security policy is much more dynamic and complex.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now