| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Cloning a database/Instance
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: root_at_fatcity.com [mailto:root_at_fatcity.com]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.
TIA & HAND!
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Charlie Mengler
INET: charliem_at_mwh.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: 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 Dec 13 2000 - 10:59:21 CST
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |