Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Cloning a database/Instance

RE: Cloning a database/Instance

From: Kevin Kostyszyn <>
Date: Wed, 13 Dec 2000 11:59:21 -0500
Message-Id: <>

When I want to make a backup copy(functional and running) of one of our instances, I basically do a copy. If it's the same version I would do the folling:
Have oracle create a new instance on the other machine and call it the same name as the instance you want to copy.
Once created shut it down.
Go to the original instance, shutdown immediate Copy all datafiles to the other machine. For example, if it is an NT machine the file structure will be Oracle home\oradata\instance name Delete all of the files that oracle created and put your in there place. Copy over the pfile and init file for the original into there proper locations.
If the new database copy is going to be on a different hard disk, you will have to run a script that alters the datafiles and points to the correct ones.
For example, alter database rename file 'old path' to 'new path',

You have to do this for every datafile, not the control files. I fire this script off in server manager, I don't know of any other way to do it other than connecting internal.
However, I have had some difficulty with it in the past, in order to connect internal the service has to be running, I usually start it from NT services, shut it down and restart it no mount mode and the script works.

Sorry this is so long, but I think it might be what you are looking for. Kev
-----Original Message-----

From: []On Behalf Of Charlie Mengler
Sent: Wednesday, December 13, 2000 10:41 AM To: Multiple recipients of list ORACLE-L Subject: Cloning a database/Instance

On one system I went through the process of running runInstaller to get a V8.1.7 database installed & created. All went well & I have a operational V8.1.7 instance.

Since I dislike poking at the GUI installer & because I wanted some practice with "disaster recovery", I restored onto a different system all the files that I thought were necessary to reproduce a working copy on this new system. I've had almost 100% success.

The minor problem that I'm trying to resolve is that when I invoke runInstaller on the new system & ask it to report which Oracle products are installed, all that gets reported is the previous V7.3.4 instance and does NOT show anything about the V8.1.7; which is in fact operational on this system.

Apparently I need to restore one or more files from the original host, but I have no idea which ones.

Any assistance or suggestions would be welcomed.


Please see the official ORACLE-L FAQ:

Author: Charlie Mengler

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: (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 Dec 13 2000 - 10:59:21 CST

Original text of this message