Re: Oracle Exadata - Clone for test/uat

Oh, why stop there? It is also possible to clone the database using storage snapshots, like EMC, Hitachi or NetApp. These days Pure storage and XTREM_IO are also very popular. Depending on the storage type, various licenses may be required: TimeFinder, FlexClone, SnapVault, HUR or something similar.

On 12/12/2017 06:24 PM, Kellyn Pot'Vin-Gorman wrote:
> And to just add a little fire under this-  With all the flavors
> available from just Oracle and the confusion in some of the current
> docs about virtualization, it may be pertinent to discuss the
> differences between the following:
>
> * Sparse Clone with Exadata
> * Snap clone copy with multitenant
> * Snap clone with ZFS
> * gDBClone
> * AND EM12/13c with thin clone features
>
> Different management packs are required for some of these, as well as
> hardware or products....  :)
>
> Kellyn
>
> Kellyn Pot'Vin on about.me
>
> Kellyn Pot'Vin-Gorman
> about.me/dbakevlar
>
> <http://about.me/dbakevlar>
>
> On Tue, Dec 12, 2017 at 4:06 PM, Kellyn Pot'Vin-Gorman
> <dbakevlar_at_gmail.com <mailto:dbakevlar_at_gmail.com>> wrote:
>
> Yeah, what that Pete guy said... :)
>
> Kellyn
>
> Kellyn Pot'Vin on about.me
>
> Kellyn Pot'Vin-Gorman
> about.me/dbakevlar
>
> <http://about.me/dbakevlar>
>
> On Tue, Dec 12, 2017 at 4:03 PM, Pete Sharman
> <peter.sharman_at_westnet.com.au
> <mailto:peter.sharman_at_westnet.com.au>> wrote:
>
> As always, Oracle has about 15 zillion ways to do the same
> thing. There’s not enough information here to know which is
> the best option for what you want to do, but you might want to
> look at the snapshot database command in 12c, Snap Clone from
> EM, or Delphix in addition to Fairlie’s comment to do what you
> want.  Which one is best depends on your requirements.
>
> Pete
>
> *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 *Fairlie
> Rego
> *Sent:* Wednesday, December 13, 2017 09:08 AM
> *To:* jack_at_vanzanen.com <mailto:jack_at_vanzanen.com>
> *Cc:* oracle-l_at_freelists.org <mailto:oracle-l_at_freelists.org>
> *Subject:* Re: Oracle Exadata - Clone for test/uat
>
> Hi Jack
>
> I have used the sparse grid disk feature on Exadata to clone
> environments and haven't seen any major issues
>
> Perhaps the below documents will help
>
> http://www.oracle.com/technetwork/database/exadata/learnmore/exadata-database-copy-twp-2543083.pdf
> <http://www.oracle.com/technetwork/database/exadata/learnmore/exadata-database-copy-twp-2543083.pdf>
>
> https://docs.oracle.com/cd/E80920_01/SAGUG/exadata-storage-server-snapshots.htm#SAGUG20386
> <https://docs.oracle.com/cd/E80920_01/SAGUG/exadata-storage-server-snapshots.htm#SAGUG20386>
>
> Ta
>
> Fairlie
>
> On Wed, Dec 13, 2017 at 8:43 AM, Jack van Zanen
> <jack_at_vanzanen.com <mailto:jack_at_vanzanen.com>> wrote:
>
> Hi All,
>
> in about 6 months we will be moving from regular Oracle 11
> to Exadata and oracle 12.
>
> Currently we simply use rman to clone prod to test/uat and
> while this works relatively fine I am interested what
> options become available in oracle 12 and Exadata to make
> cloning faster.
>
> Any third party tools that can do something that
> Oracle/Exadata can not?
>
>
> 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
>
>
>
> --
>
> Fairlie Rego
> Executive Database Architect
>
> www.technoconsulting.com.au <http://www.technoconsulting.com.au>
>
> http://www.linkedin.com/in/fairlierego
> <http://www.linkedin.com/in/fairlierego>
> https://fairlierego.wordpress.com/
> <https://fairlierego.wordpress.com/>
>
> Twitter _at_fairlierego
>
>
>

-- 
Mladen Gogala
Oracle DBA
http://mgogala.freehostia.com


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