Re: Clone Tool
Date: Fri, 22 Apr 2016 11:14:20 -0600
Message-ID: <583819a8-dcc2-1522-a232-ca00a69753e8_at_evdbt.com>
I'm mainly concerned about not having to sleep on the couch for the next week... :)
In comparing Delphix to Oracle's several different offerings in the same space, I have two immediate thoughts: 1) check references and 2) multi-platform.
On the first point, this email list is about all things Oracle, and just about every mechanism involving the administration of Oracle gets discussed here, so why haven't these mechanisms been discussed more widely on ORACLE-L? Clonedb has been available since 2010; why isn't it being adopted? PDB cloning has been around a few years as well, and there's no doubt it works quite well, but why isn't it discussed more widely either? Some of the EM12c and EM13c features seem newer, but the question remains: since they're available, are they being used? And if not, then why not? I agree that it's entirely possible that there is a sizable underworld using these features without discussing it on ORACLE-L, and it would be really cool to hear about it.
On the topic of "multi-platform" (i.e. cloning all database platforms),
I had posted to my blog some time ago
("http://evdbt.com/will-the-real-data-virtualization-please-stand-up/").
Long story short: in addition to Oracle, most IT shops have to support
MSSQL, not to mention MySQL and PostgreSQL, maybe Sybase and DB2 as
well. At Delphix, we're also getting hit hard on inquiries about
support for Hadoop and HANA as well (and we're working on it), so I know
there's interest in having a unified approach in handling this universal
and ubiquitous requirement in IT.
Finally, if you step back and look at all of this from a higher level, you'll want to handle entire application system stacks too, not just the database in isolation. Oracle E-Business Suites is a great example, and built in to the Delphix product automated cloning of the EBS appsTier, the EBS dbTier, as well as the EBS database in minutes, so as not to leave DBAs dangling 500 feet off the ground after getting just the EBS database cloned. Cloning the EBS dbTier is non-trivial, and cloning the EBS appsTier even more labor-intensive, with dozens of steps to perform and scripts to run and checks to make, all automated now in Delphix. While full-stack SAP, Peoplesoft, and Siebel are not yet automated completely within the product, there are customizable call-outs making that possible today.
I liken all of this to the dental industry. You don't see dentists doing the teeth cleaning, they do the stuff that is really important (and more fun). Database cloning is kind of like teeth cleaning, nobody wants to have their doctorate and keep doing the boring stuff.
On 4/22/16 10:21, Kellyn Pot'Vin-Gorman wrote:
> I'm going to try to answer this and still stand by my "husband/wife
> confidentiality agreement" that Tim and I have... :)
>
> You have the option via the EM13c CC to simply utilize Snapclone,
> which would simplify a lot of the issues a 10TB clone would run into
> by creating one test master database, then use snapclones to eliminate
> the time and space used by multiple clones. The Test Master would
> track the block changes ONLY on the numerous clones and so you would
> save space. The snapclones would speed up the clone itself, taking
> hour long clone processing down to just minutes.
>
> Delphix uses similar technology.
>
> Now, a tenant clone is still a clone, but only having to duplicate the
> PDB, saving time as it doesn't have to duplicate the container
> architecture and saving space along with it.
>
> Hope that explains this without going into too much detail. I have a
> new slide deck that's out there on slideshare, but I know the talking
> part of that session went into more of the detail in the session. The
> added benefit of EM13c with the DBLM and Cloud pack is that you can
> create a Self Service Portal to remove the DBA as the bottleneck in
> the process, making them responsible for their own clone requests,
> plus in EM13c, there are drop downs and pretty much five sections in
> the console wizard to fill out to perform a full clone. Seriously,
> it's that easy.
>
> Thanks,
> Kellyn
>
> Kellyn Pot'Vin on about.me
>
> Kellyn Pot'Vin-Gorman
> about.me/dbakevlar
>
> <http://about.me/dbakevlar>
>
> On Fri, Apr 22, 2016 at 10:00 AM, Robert Freeman
> <rfreeman_at_businessolver.com <mailto:rfreeman_at_businessolver.com>> wrote:
>
> So, how does this compare to the features present in Oracle
> Multitenant databases? What is the added value of Delphix
> contrasted to MT?
>
> *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 *Niall
> Litchfield
> *Sent:* Friday, April 22, 2016 9:41 AM
> *To:* Tim Gorman <tim_at_evdbt.com <mailto:tim_at_evdbt.com>>
> *Cc:* Phillip Jones <phil_at_phillip.im <mailto:phil_at_phillip.im>>;
> oracle-l_at_freelists.org <mailto:oracle-l_at_freelists.org>
> *Subject:* Re: Clone Tool
>
> Delphix is indeed a leader in this space.
>
> Oracle offer this capability licensed (snap clone) as part of the
> Cloud Management pack unless you are lucky enough to be on direct
> NFS in which case clonedb is available to you as part of the db
> license.
>
> Actifio offer a competitive product to Delphix.
>
> All of these products are full featured and effective you will,
> however, need a non-trivial budget for them.
>
> On Fri, Apr 22, 2016 at 1:37 PM, Tim Gorman <tim_at_evdbt.com
> <mailto:tim_at_evdbt.com>> wrote:
>
> Delphix makes database cloning fast, cheap, and easy, as well
> as data masking for security in non-production environments,
> database upgrades, database migrations from UNIX-to-Linux
> (U2L), data center migrations, database migration to hosting
> or cloud, and can clone an entire application stack, a good
> example being Oracle E-Business Suites. Currently supported
> databases include Oracle, MSSQL, MySQL, Sybase, PostgreSQL,
> and DB2.
>
> You can download a free trial at
> "https://www.delphix.com/products/free-trial-request"
> <https://www.delphix.com/products/free-trial-request> and
> product documentation is found at "https://docs.delphix.com"
> <https://docs.delphix.com>.
>
> It's fun stuff!
>
>
>
>
> On 4/22/16 05:39, Phillip Jones wrote:
>
> Hi,
>
> https://www.delphix.com/
>
> Ta,
>
> Phil
>
> On Fri, Apr 22, 2016 at 12:33 PM, walid kaakati
> <dmarc-noreply_at_freelists.org
> <mailto:dmarc-noreply_at_freelists.org>> wrote:
>
> Hallo List,
>
> I would like to Know from your experience what you do
> for cloning a large database(10TB) fastly ? iam using
> duplicate or restore with RMAN but it takes too much
> time !.
>
> IS thier any recommeded tool or idea ?
>
> Database 10g.
>
> RedHat Linux
>
> Best Wishes
>
>
>
> --
>
> Niall Litchfield
> Oracle DBA
> http://www.orawin.info
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Apr 22 2016 - 19:14:20 CEST