RE: Access/dump datafile (no alter system/database, e.g. AWS RDS)
Date: Fri, 27 Jul 2018 14:56:37 +0000
Message-ID: <258575162B63424EB58DAE3A5475B6ED0130E55F4F_at_EXNJMB25.nam.nsroot.net>
No because the restore is all or nothing. We need to spin up another instance and do an export. This would not be a problem if we had somewhere to put the dump.
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 niall.litchfield_at_gmail.com
Sent: Friday, July 27, 2018 9:50 AM
To: dmarc-noreply_at_freelists.org
Cc: vit.spinka_at_vitspinka.cz; ORACLE-L
Subject: 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<https://urldefense.proofpoint.com/v2/url?u=https-3A__docs.aws.amazon.com_AmazonRDS_latest_UserGuide_USER-5FPIT.html&d=DwMFaQ&c=j-EkbjBYwkAB4f8ZbVn1Fw&r=yWMFosURAngbt8VLeJtKLVJGefQxustAZ9UxecV7xpc&m=-iE-mUkYfiC_p7D1IoYXgKouPO7n-A7ZFzvzqCUGbz0&s=5HGhUyabF8EjBorS3Z-rSo8oCJj-L_TQj0vim4dn_8I&e=>
On Fri, Jul 27, 2018 at 2:38 PM Reen, Elizabeth <dmarc-noreply_at_freelists.org<mailto: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> [mailto: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<https://urldefense.proofpoint.com/v2/url?u=http-3A__www.orawin.info&d=DwMFaQ&c=j-EkbjBYwkAB4f8ZbVn1Fw&r=yWMFosURAngbt8VLeJtKLVJGefQxustAZ9UxecV7xpc&m=-iE-mUkYfiC_p7D1IoYXgKouPO7n-A7ZFzvzqCUGbz0&s=NvYSBgfM8WkhytJdusoePeKvKV_S9TgN3UzV34vnYx0&e=>
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Jul 27 2018 - 16:56:37 CEST