and most importantly of all, if you don't want to have to repeat (and repeat) this exercise...
BACKUP THE NEW DATABASE --- "Mercadante, Thomas F" <[EMAIL PROTECTED]> wrote: > Fred, > > Either method works fine. You have the same amount of data editing > in both > methods (Either issue "alter database rename" commands, or edit the > "create > controlfile" file. > > The other consideration is that in Rachel's method, you are simply > opening > the database afterword. > > With the re-creation of the control file, you must (I think) "alter > database > open resetlogs". > > A minor difference. > > Whichever way you decide to do it would be fine. The end result is a > ton of > typing. > > Something to consider is, on your production box, create disk > directories > based on a Unix soft link, and place your database files into these > directories. This would facilitate your moving of the database in > the > future, as your "soft links" are at the operating system level, and > can be > changed more easily than issuing the "alter database" commands. > > Hope this helps. > > Tom Mercadante > Oracle Certified Professional > > > -----Original Message----- > Sent: Wednesday, January 23, 2002 2:40 PM > To: Multiple recipients of list ORACLE-L > > > Would I be better off doing that or doing a "backup controlfile to > trace" > from server A, moving the datfiles & logfiles to server B, and then > editing > the newly created trace file into a script that creates a new > controlfile > with the new datafile/logfile locations? > > > > > >From: Rachel Carmichael <[EMAIL PROTECTED]> > >Reply-To: [EMAIL PROTECTED] > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > >Subject: Re: Backup/Recovery questions ... > >Date: Wed, 23 Jan 2002 11:00:36 -0800 > > > >First load all the datafiles and logfiles to server B in the > locations > >you want them. Load the controlfiles as well, they aren't useless. > > > >Now..... > > > >edit the init.ora file on server B to point to where the control > files > >are. > > > >create a sql script file that contains (for every datafile and > logfile) > > > >alter database rename file '<original file name>' to '<new file > name>'; > > > >the file names should include the full path specification. > > > >now > >go into svrmgrl: > > > >connect internal > >startup mount > ><run the script> > >alter database open; > >exit > > > > > >and you have moved the database and files to the new server > > > >--- Fred Smith <[EMAIL PROTECTED]> wrote: > > > List, > > > > > > I am attempting to verify the validity/integrity of a full cold > > > backup I > > > did off of my production server. I backed up the > datafiles,logfiles,& > > > > > > controlfiles. The production server (server A) is much larger > with > > > dozens of > > > drives. I now wish to apply this backup to another server (server > B). > > > Server > > > B does not have the same drive configurations as server A. Based > on > > > this > > > I'm assuming that my controlfiles from Server A are useless. > > > How can I bring this database up on server B now? > > > There are over 100 datafiles. > > > > > > OS: SunOS 5.6 > > > Oracle8 Enterprise Edition Release 8.0.4.4.0 - Production > > > > > > Thank you, > > > -Fred S. > > > > > > _________________________________________________________________ > > > Chat with friends online, try MSN Messenger: > http://messenger.msn.com > > > > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > -- > > > Author: Fred Smith > > > INET: [EMAIL PROTECTED] > > > > > > 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: [EMAIL PROTECTED] (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). > > > > > >__________________________________________________ > >Do You Yahoo!? > >Send FREE video emails in Yahoo! Mail! > >http://promo.yahoo.com/videomail/ > >-- > >Please see the official ORACLE-L FAQ: http://www.orafaq.com > >-- > >Author: Rachel Carmichael > > INET: [EMAIL PROTECTED] > > > >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: [EMAIL PROTECTED] (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). > > > _________________________________________________________________ > Join the world's largest e-mail service with MSN Hotmail. > http://www.hotmail.com > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Fred Smith > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: Mercadante, Thomas F > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). __________________________________________________ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
