Re: sending a copy of database to vendor

That is done quite regularly, using appliances alike AWS Snowball or Azure Data Box for Azure cloud. Oracle also has an appliance to facilitate fast data transfer to the cloud:

https://cloud.oracle.com/storage/data-transfer/features

I like Oracle SaaS offering better than any other because Oracle doesn't restrict the use of SYS or access to the underlying VM. And that is how you give access to the database to the vendor: you put the database into a cloud of your choice and give the vendor access. Which cloud to chose. that's a business decision, not a technical one. Having been a techie all my life, I am trying to stay out of such decisions.

On 6/24/19 4:07 PM, Tefft, Michael J wrote:
>
> You should be able to
>
>             DBMS_DATAPUMP.set_parameter (handle   => h1,
>
> name     => 'ENCRYPTION',
>
> VALUE    => 'NONE');
>
> See
> https://docs.oracle.com/en/database/oracle/oracle-database/12.2/sutil/oracle-data-pump-export-utility.html#GUID-16EEA783-A7E8-4FD3-A7B1-C92428C94C66
>
> Mike Tefft
>
> *From:*oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] *On Behalf Of *Mark Burgess
> *Sent:* Thursday, June 20, 2019 5:07 AM
> *To:* oracle-l_at_freelists.org; Jack van Zanen <jack_at_vanzanen.com>
> *Subject:* Re: sending a copy of database to vendor
>
> ***CAUTION: This email originated from outside of Snap-on. Use caution
> when clicking on links or opening attachments. Contact the sender by
> phone to validate the contents. ***
>
> Yes fairly sure that was the case.
>
> There is a note on MOS that describes the problem as well.
>
> On 20 Jun 2019, 5:05 PM +1000, Jack van Zanen <jack_at_vanzanen.com
> <mailto:jack_at_vanzanen.com>>, wrote:
>
> Are you sure about that?
>
> On Thu, 20 Jun. 2019, 16:44 Mark Burgess,
> <mark_at_burgess-consulting.com.au
> <mailto:mark_at_burgess-consulting.com.au>> wrote:
>
> Jack if the tablespace you have exported from is encrypted you
> will need the wallet to impdp on the destination.
>
> Clone the db - decrypt the tablespace and then expdp again and
> you should be ok to imp on the destination without needing the
> wallet.
>
> On 20 Jun 2019, 3:51 PM +1000, Jack van Zanen
> <jack_at_vanzanen.com <mailto:jack_at_vanzanen.com>>, wrote:
>
> Hi All
>
> Oracle 12C RAC Exadata (Cloud at customer)
>
> We need to send a copy of our database to the vendor so
> they can troubleshoot issues .
>
> I send them a compressed datapump export but they are
> having issues with loading this.
>
> They want an RMAN backup but our databases are encrypted
> so if we send them RMAN backup we also need to send them 
> the KEYS which we do not want to do.
>
> Is there a way around this ?
>
>
> Jack van Zanen
>
>
> -------------------------
> This e-mail and any attachments may contain confidential
> material for the sole use of the intended recipient. If
> you are not the intended recipient, please be aware that
> any disclosure, copying, distribution or use of this
> e-mail or any attachment is prohibited. If you have
> received this e-mail in error, please contact the sender
> and delete all copies.
> Thank you for your cooperation
>

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


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