RE: DB copying : Attack of the Clones!

Kirti

        Have you looked into the RMAN DUPLICATE DATABASE feature?

Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Friday, July 19, 2002 9:18 AM
To: Multiple recipients of list ORACLE-L

Hello Dale,
  Unfortunately, the current requirement demands full size copies. We will also be looking into subsets of data down the road and will certainly look at your tool. In fact, I will forward your e-mail to the Team Leader handling this project.

 Thanks for the information.

• Kirti

> -----Original Message-----
> From: Dale_at_DataBee.com [SMTP:Dale_at_DataBee.com]
> Sent: Friday, July 19, 2002 4:33 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: DB copying : Attack of the Clones!
>
> Hi Kirti
>
> Do you absolutely need full size copies? If small referentially correct
> subsets were suitable you could use our DataBee software to "re-create and
> re-load" the test databases as necessary.
>
> In other words, you would not need to back up and restore full size
> databases. You simply press the button and regenerate the subsets when
> required. Depending on the size of the subset, the refresh would not take
> more than an hour or two. The load process is quite straight forward -
> many
> of our customers just create the initial subset databases and then off
> load
> the "truncate and reload" work to the developers and testers themselves.
> The
> DBA's are removed from the loop and because the databases are small the
> create process is very quick - the developers and testers can refresh
> their
> databases whenever they want.
>
> Actually, DataBee would clone the full size databases just fine - its just
> not really designed for that purpose in mind.
>
> DataBee: http://www.DataBee.com
>
> In any event, you should have a look at our freeware DBATool. It contains
> (among other things) a rule based schema adjuster that should take care of
> your requirements to modify the DDL in the test schemas
> http://www.DataBee.com
>
> Thanks
> Dale Edgar
> Net 2000 Ltd.
> Dale_at_DataBee.com
>
>
> > I was 'volunteered' to participate in a task force charged with finding
> > quick solutions (in less than 2 weeks) to support following Dgmt
> decision:
> > Clone 14 production databases in their entirety for ongoing code
> testing,
> > recreating production problems etc.
> >
> > BTW, if we decided on any 3rd party tools, then Dgmt wants it installed
> > within the next 4-5 weeks. Any Vendor types lurking on the list? This is
> > your chance :)
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: Dale_at_DataBee.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: kirti.deshpande_at_verizon.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.COM

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).