Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

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

RE: Cloning a database/Instance

From: Anderson, Brian <andersob_at_mail.dartnet.peachnet.edu>
Date: Wed, 13 Dec 2000 15:11:07 -0500
Message-Id: <10709.124479@fatcity.com>


There is an oracle inventory directory, I believe it goes under program files.

This is where the installed products for NT comes from.

> -----Original Message-----
> From: Kevin Kostyszyn [mailto:kevin_at_dulcian.com]
> Sent: Wednesday, December 13, 2000 12:16 PM
> To: Multiple recipients of list ORACLE-L
> Subject: 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-----
> Mengler
> Sent: Wednesday, December 13, 2000 10:41 AM
> To: Multiple recipients of list ORACLE-L
>
>
> 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 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: Kevin Kostyszyn
> INET: kevin_at_dulcian.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
Received on Wed Dec 13 2000 - 14:11:07 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US