Does the automated snapshot capability meet those requirements?
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PIT.html
On Fri, Jul 27, 2018 at 2:38 PM Reen, Elizabeth <dmarc-noreply@xxxxxxxxxxxxx>
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 Group Manager
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