Message-Id: <10709.124506@fatcity.com> From: "Kevin Kostyszyn" Date: Wed, 13 Dec 2000 17:15:39 -0500 Subject: Re: Cloning a database/Instance Ooo, interesting, you sort of got me on this one. I would definately need more info on this subject, but I am sure by the time that happened one of these experts will have solved it already. But if your talking I am listening. Kev ----- Original Message ----- From: Anderson, Brian To: Multiple recipients of list ORACLE-L Sent: Wednesday, December 13, 2000 3:26 PM Subject: RE: Cloning a database/Instance > 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@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@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@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@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@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@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@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