Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

open a file on a remote server amazon rds oracle

Posted on 2016-08-06
4
Medium Priority
?
413 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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Happy holidays! Your Ops team can pack their bags. IT management and IT management tools are dead. Or at least that’s according to a new blog from Tech Target on AWS’s new Managed Services (MS) offering.
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 set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

670 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