Re: Delphix deployment?

From: Kellyn Pot'Vin-Gorman <dbakevlar_at_gmail.com>
Date: Wed, 28 Jun 2017 19:32:33 +0000
Message-ID: <CAN6wuX3v1G5kiN0AAv=D3O14HQ8NJN0nR1r0jhDNxLoBqfOw0w_at_mail.gmail.com>



Yeah, what he^ said!! :)

On Wed, Jun 28, 2017 at 1:35 PM Steve Karam <oraclealchemist_at_gmail.com> wrote:

> Chris,
>
> Disclaimer: I’m a Delphix employee.
>
> So this statement seems to imply that we hookup the non production
> databases to this appliance. An RMAN restore is done “against” the
> appliance and like a standby database it accepts logs from the production
> database? And then the non-production databases can be “refreshed” from
> production with a click of a button as required by developers/testers?
>
>
> Very close! Delphix links to your source database (whatever that might
> be), and creates what is called a “dSource” inside Delphix with an
> initial full backup taken directly into Delphix and compressed. Over time,
> block changes and redo get applied inside the dSource (on Delphix) to
> establish a “Timeflow” which is basically change data over time.
>
> Once you have your dSource, you can select a point in time (by time or
> SCN), and provision to a target non-prod system. Delphix automates the
> building of the virtual datafiles from snapshot/log data and presents them
> to the target host, which opens them. The result is a rapidly provisioned
> virtual database (VDB) cloned as of a point in time, shared from Delphix to
> the target, and opened like any other database even though technically the
> VDB doesn’t use any storage when first created. From there, you can
> refresh, rewind, or enable self-service features for end users while they
> use it like any other database. You can also mask the data using the
> masking tool if required to build a secure golden image, and then create a
> VDB from that VDB for your end users. Lots of possibilities and I don’t
> want to go into anything that seems like a pitch here, so I’ll leave it
> at that.
>
> If you have any questions about the technical details I’d be glad to help… several
> other members of oracle-l are also technical specialists here at Delphix.
>
> Thanks!
>
> Steve Karam
>
> On Jun 28, 2017, at 2:25 PM, Chris Grabowy <cgrabowy_at_gmail.com> wrote:
>
> Ryan, Jeremy, Steve…thanks for taking the time to respond.
>
> >> For Oracle, it uses an RMAN backup to build the first copy and then
> applies block changes after that point.
>
> So this statement seems to imply that we hookup the non production
> databases to this appliance. An RMAN restore is done “against” the
> appliance and like a standby database it accepts logs from the production
> database? And then the non-production databases can be “refreshed” from
> production with a click of a button as required by developers/testers?
>
> I believe we are also looking at the data masking piece too since Security
> has been poking around looking for such a capability.
>
> Again thanks for the responses.
>
> Chris
>
>
> *From:* Givens, Steven [mailto:sgivens_at_fnni.com <sgivens_at_fnni.com>]
> *Sent:* Wednesday, June 28, 2017 2:14 PM
> *To:* 'rjanuary_at_gmail.com'; 'cgrabowy_at_gmail.com'
> *Cc:* 'oracle-l_at_freelists.org'
> *Subject:* RE: Re: Delphix deployment?
>
> Yes, it’s engine sits on VMware and provides a mechanism to virtualize
> your databases so that copies of the data can be distributed on other
> servers using minimal disk space. Ultimately app teams could have a
> self-service model to “spin up” test databases on their own. Delphix
> supports multiple databases. For Oracle, it uses an RMAN backup to build
> the first copy and then applies block changes after that point.
>
> It also has a data masking tool we are looking at. We are just in the
> “browsing” stage right now.
>
> Thanks,
>
> Steve Givens
> Lead Database Administrator
> First National Bank
> 201 N 16th St, Stop Code 2252
> Omaha, NE 68197
> Office: 402-602-7812
> sgivens_at_fnni.com
>
>
>
> *From:* oracle-l-bounce_at_freelists.org [
> mailto:oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org>] *On
> Behalf Of *Ryan January
> *Sent:* Wednesday, June 28, 2017 1:05 PM
> *To:* cgrabowy_at_gmail.com
> *Cc:* oracle-l_at_freelists.org
> *Subject:* [External] Re: Delphix deployment?
>
>
> If I recall correctly it's basically an appliance that sits between your
> storage and database servers. It exposes itself as storage and abstracts
> away the underlying complexity.
>
>
> On Jun 28, 2017, at 12:57 PM, Chris Grabowy <cgrabowy_at_gmail.com> wrote:
>
> My manager is suddenly asking about the size of our non-production
> databases.
>
> I asked why and finally got an answer that they are coming up with numbers
> for the purchase of Delphix.
>
> I have heard of Delphix and I poked around their website. Looks pretty
> cool.
>
> I am wondering if anyone can provide me a quick high level one or two
> sentence description of how this product is deployed?
>
> Thanks,
> Chris
>
>
> --

[image: Kellyn Pot'Vin on about.me]

Kellyn Pot'Vin-Gorman
about.me/dbakevlar
  <http://about.me/dbakevlar>

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jun 28 2017 - 21:32:33 CEST

Original text of this message