RE: Access/dump datafile (no alter system/database, e.g. AWS RDS)

From: Reen, Elizabeth <"Reen,>
Date: Fri, 27 Jul 2018 14:57:22 +0000
Message-ID: <258575162B63424EB58DAE3A5475B6ED0130E55F5B_at_EXNJMB25.nam.nsroot.net>

                Yes, this is how we do it now, but it is a real pain and assumes that we have the required extra space free.

Liz

Elizabeth Reen
CPB Database Group Manager
718.248.9930 (Office)
Service Now Group: CPB-ORACLE-DB-SUPPORT

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Ruel, Chris Sent: Friday, July 27, 2018 10:23 AM
To: vit.spinka_at_vitspinka.cz; Oracle-l Subject: RE: Access/dump datafile (no alter system/database, e.g. AWS RDS)

Have you tried creating a directory to the file location and then using DBMS_FILE_TRANSFER? This is how you can move DataPump files into/out of RDS. Not sure if it would work with a datafile. They may have some constraints/intelligence in place to prevent this.

---

Chris Ruel * Oracle Database Administrator * Lincoln Financial Group cruel_at_lfg.com<mailto:cruel_at_lfg.com> * Desk:317.759.2172 * Cell 317.523.8482

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of vit.spinka Sent: Friday, July 27, 2018 6:54 AM
To: Oracle-l <oracle-l_at_freelists.org> Subject: Access/dump datafile (no alter system/database, e.g. AWS RDS)

***This email is from an external source. Only open links and attachments from a Trusted Sender.*** Hi all,

I wonder if there is a way how to get to the datafiles in say Amazon RDS, as there is no filesystem access. And the users cannot have alter system or alter database grants, so I can't even dump contents of a data block. The backups are file system snapshots, but these don't seem to be accessible, either.

Or am I missing somethings, is there a way how to access an arbitrary datafile block?

Thanks for all ideas!

Vit

Notice of Confidentiality: **This E-mail and any of its attachments may contain Lincoln National Corporation proprietary information, which is privileged, confidential, or subject to copyright belonging to the Lincoln National Corporation family of companies. This E-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this E-mail, you are hereby notified that any dissemination, distribution, copying, or action taken in relation to the contents of and attachments to this E-mail is strictly prohibited and may be unlawful. If you have received this E-mail in error, please notify the sender immediately and permanently delete the original and any copy of this E-mail and any printout. Thank You.**

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Jul 27 2018 - 16:57:22 CEST