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 '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).
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 '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 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 '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
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 '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
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 '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