RE: Oracle Exadata - Clone for test/uat
Date: Wed, 13 Dec 2017 10:03:17 +1100
Message-ID: <07f101d3739d$66bf9e50$343edaf0$_at_westnet.com.au>
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] On Behalf Of Fairlie Rego
Sent: Wednesday, December 13, 2017 09:08 AM
To: jack_at_vanzanen.com
Cc: 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
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
https://fairlierego.wordpress.com/
Twitter _at_fairlierego
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Dec 13 2017 - 00:03:17 CET