James and list: You can backup the database without stopping the services. Just shut it down. If you are going to attempt a restore and blow away the control files, etc., then by all means stop the services first. The services would need the control files to be present if it is to be restarted or the registry would have to be changed. A simple rule would be to stop the services if a restore needed to be done or if the configuration and control files were going to be wiped. Otherwise leave the services up.
Now can we move on? I think this issue has been debated enough. RWB "James Damiano" <[EMAIL PROTECTED]>@fatcity.com on 10/21/2002 10:24:46 AM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Dear List, I had a situation on a lone Windows/NT system a couple of years ago, where I had installed 8i and was testing a number of facilities prior to going online with an application. Since I wasn't familiar with NT, I played around a bit, the final step of which was to test recovery with a cold backup. So I did a "shutdown immediate" and took a cold backup of the database (while having left the Oracle services up). Frankly I didn't **purposely** leave the services up because it didn't enter my mind that I had to do so or not. All I know is that when I blew away the existing database control, data, and log files, and restored them with the cold backup for a test of recovery, the database would not start back up. (I didn't note what the specific error messages were because I was in a big hurry at the time and could't mess around with it.) I DO know that I was stunned at this because on UNIX and Netware, I never had such a thing occur. So, I rebuilt the database from scratch, reloaded, and then tried the recovery scenario again. This time I did the "shutdown immediate" and then shut down the Windows Oracle service for the database before doing the cold backup, took the backup, blew away the existing database, restored the cold backup database files, and restarted the database successfully without incident. Having been in a hurry, maybe originally I did something illogical or idiotic which was the reason for my obtaining the results I did (when in reality it had nothing to do with Window services, I don't know.) I always meant to go back and revisit that whole issue but haven't had the time or inclination I guess. Given what is being said in this discussion, I would like to do so in a methodical manner to see if I can get down to the fact of the matter. Jim Damiano -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Damiano INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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: INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).
