Re: Cloning a database/Instance

Since I started this thread, maybe I can terminate it. FWIW - I learned the following by submitting an iTAR.

The oraInventory is necessary but NOT sufficient to have OUI properly identify what is installed. At least on Solaris, I needed /var/opt/oracle/oraInst.loc to be copied onto the new system. Without the oraInst.loc file, the Oracle Universal Installer did not recognized the fact that a V8.1.7 was resident on the system.

HTH & YMMV! "Anderson, Brian" wrote:
>
> 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
> > also send the HELP command for other information (like subscribing).
> >
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Anderson, Brian
> INET: andersob_at_mail.dartnet.peachnet.edu
>
> 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).

-- 
Charlie Mengler               Maintenance Warehouse  
charliem_at_mwh.com              10641 Scripps Summit Ct