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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Tim Gorman
*Sent:* Saturday, April 23, 2016 5:28 PM
*To:* Mladen Gogala <gogala.mladen@xxxxxxxxx>; Andrew Kerber <andrew.kerber@xxxxxxxxx>
*Cc:* David Green <thump@xxxxxxxxxxxxxxxx>; oracle-l@xxxxxxxxxxxxx
*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
