Solved

open a file on a remote server amazon rds oracle

Posted on 2016-08-06
4
179 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
  • 3
4 Comments
 
LVL 4

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Security is one of the biggest concerns when moving and migrating your data from your on-premise location to the Public Cloud.  Where is your data? Who can access it? Will it be safe from accidental deletion?  All of these questions and more are imp…
Or at least that’s the word according to a new blog from Tech Target on AWS’s new Managed Services (MS) offering. According to the blog, AWS is launching their AWS MS program to expedite the adoption of cloud by Fortune 1000 and Global 2000 companie…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

828 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