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

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Sun, 29 Jul 2018 21:55:07 -0400
Message-ID: <48b4ad46-870b-ce47-d155-466787ac2da2_at_gmail.com>



Hi Elizabeth,

The answer is that you do not. RDS is database as a service. You populate it using data pump. There is a class of databases for which that can be used: smaller, in house databases, like an HR database, RMAN catalog or OEM database. RDS is not the right solution if you have a 100TB OLTP database. For that, you'll have to use an EC2 instance or on-premises hardware.  Also, be aware that somebody else, outside your organization, has the SYSDBA privilege and can see all your data. That sort of limits what you can put into the RDS.

Regards

On 7/27/2018 9:36 AM, Reen, Elizabeth (Redacted sender elizabeth.reen for DMARC) wrote:
>
> We have a similar cloud here.  My question is how do I restore a table
> in dev?  Or refresh a testing database from Prod?  It’s not the best
> answer in the world.
>
> Liz
>
> Elizabeth Reen
> CPB Database GroupManager
>
> Service Now Group: CPB-ORACLE-DB-SUPPORT
>
> *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
> *Subject:* Access/dump datafile (no alter system/database, e.g. AWS RDS)
>
> 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
>

-- 
Mladen Gogala Database Consultant Tel: (347) 321-1217

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jul 30 2018 - 03:55:07 CEST

Original text of this message