>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.
[EMAIL PROTECTED]
-----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" <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
