Re: Clone tool

From: Tim Gorman <tim_at_evdbt.com>
Date: Mon, 25 Apr 2016 18:16:50 -0600
Message-ID: <873d81fd-16e4-1aca-9591-38cafb672810_at_evdbt.com>



Robert,

An example of what you're discussing is Oracle E-Business Suites (EBS), which consists of one or more instances of the EBS appsTier (i.e. a file-system), one or more instances of the EBS dbTechStack (i.e. another file-system), and one or more instances of the EBS database. Each EBS component can be multi-instance, and each instance of each component includes calls to standard Oracle Perl programs and SQL*Plus scripts.

A JetStream container
<https://docs.delphix.com/display/DOCS50/Jet+Stream+Data+Concepts#JetStreamDataConcepts-UnderstandingDataContainers> can hold all instances of all three EBS components, with the calls to the Perl and SQL*Plus scripts included. You can refresh or restore all cloned copies as one unit, in minutes. Even cooler is that this uses the JetStream UI for non-DBAs (a.k.a. the extremely simplistic to-the-point-of-silliness self-service stuff) so developers and testers can do this on their own.

Hope this helps!

-Tim
Delphix

On 4/25/16 16:41, Robert Freeman wrote:
>
> What I find of particular interest is the notion (from what I’ve read,
> this seems possible) of packaging a database and the associated
> web/app components together.
>
> For example, if I want to restore a database backup from a year ago,
> it’s incredibly useful to also be able to restore the associated
> application version at the same time.
>
> To have one tool that manages this would be very nice and it sounds
> like Delphix would be able to support these kinds of associations.
>
> Add to that the need to manage external resources such as external
> file shares (ie: the files pointed to by your bfiles or perhaps the
> XML in your database) and keep them all synchronized to specific
> points in time that I could restore too, would make for a very
> powerful tool for companies who routinely have to look at “how things
> were” at some point in the past, for whatever reason.
>
> Being able to flash a database back in time is great… but all too
> often the entire application layer needs to go with it, along with
> other stores.
>
> Cheers!
>
> RF
>
> *From:*oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] *On Behalf Of *Tim Gorman
> *Sent:* Saturday, April 23, 2016 5:28 PM
> *To:* Mladen Gogala <gogala.mladen_at_gmail.com>; Andrew Kerber
> <andrew.kerber_at_gmail.com>
> *Cc:* David Green <thump_at_cosmiccooler.org>; oracle-l_at_freelists.org
> *Subject:* Re: Clone tool
>
> To get closer to a useful answer, how about if instead we just discuss
> a specific scenario? Let's start with a scenario similar to that the
> original poster had posed?
>
> Let's say someone has a 10 TB production database from which they want
> to create 10 non-production databases for development, testing,
> training, etc.
>
> Here's the first question: how much storage must be provisioned to
> the non-production target server(s) to accommodate the 10 new databases?
>
> Here are some answers that I can provide confidently...
>
> 1. Using RMAN DUPLICATE TARGET DATABASE, they need 100 TB for the
> target server(s)
> 2. Using Delphix, they need 10 TB for the Delphix appliance and 0 TB
> for the target server(s), totaling 10 TB
>
>
> I'm not certain how much storage would be needed using solutions from
> CommVault, NetBackup, TSM, Actifio, Oracle Snapclone, Oracle12c PDB
> clone, Exadata, and other solutions, because I am not as familiar with
> them, so I'm hoping others will fill in?
>
>
>
> On 4/23/16 10:56, Mladen Gogala wrote:
>
> On 04/23/2016 12:13 PM, Andrew Kerber wrote:
>
> I don't have a dog in this fight, but frankly Commvault and
> Delphix are two different solutions to two different problems.
> I know of several places that use both. Commvault is a backup
> solution, Delphix is a cloning and masking solution.
>
>
> Hi Andrew,
> Cloning is done by storage snapshots. I reacted because Commvault
> can do cloning and does it for supported storage for a long time.
> Data masking is something that Commvault doesn't do, that is true.
> In the modern world, the notion of what exactly is backup is
> blurred. I must say that Oracle has been very slow with adopting
> snapshots for backup purposes. IBM, for instance, has ACS
> (advanced copy services) which does support taking snapshots. RMAN
> doesn't support storage snapshots. So, "traditional" backup
> solutions like Commvault, NetBackup and TSM are all doing the
> same thing as Delphix and ActifIO, when it comes to using storage
> snapshots to clone a DB. Of course, as is the case with many
> modern trends in the IT, there is a flood of buzzwords:
> "virtualization", "data as a service" (my particular favorite) ,
> "infrastructure as a service", "software as a service" and many more.
> Delphix positions itself as a new way of doing backup and has
> somewhat privileged position on this list. It is heavily promoted
> by what I consider a pure and unadulterated marketing. I didn't
> react until there was too much of "Delphix is web-scale" message
> for my taste on this group.
> Regards
>
>
>
> --
>
> Mladen Gogala
>
> Oracle DBA
>
> http://mgogala.freehostia.com
>

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Apr 26 2016 - 02:16:50 CEST

Original text of this message