Yes it is quite possible to do just that.
The only thing is that you have to generate a "CREATE DATABASE" command
from the source DB by "ALTER DATABASE BACKUP CONTROLFILE TO TRACE" command.
Note the "CONTROLFILE" does not have a space in it !
You then alter the contents of the Trace file to SET the Database Name to
the new name that you require. In addition you make any necessary changes
to the file locations that have been generated.
You then have a CREATE DATABASE command that will create the cloned
database.
NB: DO NOT copy the Control files - they will be created as part of the
CREATE DATABASE command.
DO NOT Copy the Online Redo Logs - they will be created as part of the
CREATE DATABASE command.
Martin - Oracle-Rescue.com
-----Original Message-----
Martínez Jiménez
Sent: 10 January 2002 11:20
To: Multiple recipients of list ORACLE-L
Hello again,
thanks all that have replied.
I have another question. Is it possible to clone a database just only
through
OS operations? For example, is it possible to overwrite the files related
with one database (.dbf, .ctl..) with the one related with the database to
'clone'?
Maybe it sounds crazy...
.
Ruth Gramolini ha escrito:
> Have a look at None:73974.1 on Metalink. It give the step for cloning a
> database from backups.
>
> HTH,
> Ruth
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Wednesday, January 09, 2002 4:50 AM
>
> 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: Ruth Gramolini
> 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: 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: Martin Kendall
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).
