Re: Backup/Recovery questions ...
Fred, one of the easier ways is this: 1. on ur prod take a control file backup to trace 2. copy the trace to server b and edit the path/drives 3. copy init file from prod to server b 4. set the env vars in server b and startup nomount 5. create the control file using edited trace on B 6. restore database {rman} 7. recover database {rman} 8. open resetlogs alternate method: all steps are similar except 1,2,5 instead u can restore controlfile (rman backup) and then manualkly rename the file before u mount and restore your database. let me know if this still does not answer your q Thx Deepak --- 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: Deepak Thapliyal 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).
Re: Backup/Recovery questions ...
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 '' to ''; the file names should include the full path specification. now go into svrmgrl: connect internal startup mount 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).
Re: Backup/Recovery questions ...
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 '' to ''; > >the file names should include the full path specification. > >now >go into svrmgrl: > >connect internal >startup mount > >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 worlds 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).
RE: Backup/Recovery questions ...
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 '' to ''; > >the file names should include the full path specification. > >now >go into svrmgrl: > >connect internal >startup mount > >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
RE: Backup/Recovery questions ...
> With the re-creation of the control file, you must (I think) "alter database > open resetlogs". > A minor difference. But one worth noting. If this method is chosen and the database must be opened with resetlogs, you must take a cold backup before allowing the database to be used. As to the reasons why, they can be found in the archives at www.fatcity.com. Jared "Mercadante, Thomas F" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 01/23/02 12:37 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: Backup/Recovery questions ... 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 '' to ''; > >the file names should include the full path specification. > >now >go into svrmgrl: > >connect internal >startup mount > >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/
RE: Backup/Recovery questions ...
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 '' to ' name>'; > > > >the file names should include the full path specification. > > > >now > >go into svrmgrl: > > > >connect internal > >startup mount > > > >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