RE: Clone a database

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Wed, 09 Jan 2002 13:35:36 -0800
Message-ID: <F001.003EB79C.20020109130200@fatcity.com>

>From my point of view, exp/imp time is linear with the size of the database
and cloning is nearly linear except for the time to copy the files. For a small database, I could do exp/imp much faster. I gave up creating test databases using exp/imp on our largest production database when it grew past 50-gig. That was when I learned how to clone it.

I noticed that RMAN doesn't like you to clone your databases, because it identifies databases by the DBID and that remains unchanged when you clone the database. However, I notice RMAN has a feature to duplicate a database and it does change the DBID then. I'm looking forward to learning this technique. If anyone has found a pitfall with duplicate, please let me know.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Wednesday, January 09, 2002 10:45 AM To: Multiple recipients of list ORACLE-L

With all my respect, this is not always the case Best regards,
Serge

-----Original Message-----
Sent: Wednesday, January 09, 2002 10:15 AM

To:     Multiple recipients of list ORACLE-L
Subject:        RE: Clone a database

easier perhaps only if you have the exact same disk layouts and space available.

and certainly MUCH more time to create -- an import takes anywhere from 2-4 times as long as the export did.

"Babich , Sergey" <SBabich_at_handexmail.com> wrote:
> Hi, Beatriz,
> If you want to create an identical copy of your production (that's my
> understanding), it is a lot easier to export it (FULL=Y) and then
> import the
> dump file into your new database. Let me know if you need more info.
> Regards,
> Sergey Babich, Oracle DBA
>
> -----Original Message-----
> Sent: Wednesday, January 09, 2002 4:50 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Clone a database
>
> Hello list,
> I new to clone a database for changing between test to production.
> The new database is going to be in a different host.
> I have the copy obtained through the enterprise manager (I suppose
> it´s
> a cold backup).
> Which are the steps I should follow?
> A lot of thanks
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Beatriz =?iso-8859-1?Q?Mart=EDnez=20Jim=E9nez?=
> INET: beamar_at_cidaut.es
>
> 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: Babich , Sergey
> INET: SBabich_at_handexmail.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).

Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: wisernet100_at_yahoo.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: Babich , Sergey
  INET: SBabich_at_handexmail.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).

Received on Wed Jan 09 2002 - 15:35:36 CST