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

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_at_freelists.org> 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_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
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

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