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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] *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