Re: services on windows?????
Not exactly. Someone else has already pointed out that registry entries can be created to gracefully shutdown the database: Doc ID 136214.1 If these are not setup properly, then stopping the services without first shutting down the database is actually harsher than a shutdown abort. This is also detailed somewhere on MetaLink, but I don't have the doc #. Jared Yechiel Adar [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/21/2002 08:08 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: services on windows? If you stop the service you perform shutdown abort which is not recommended for cold backup. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L Sent: Monday, October 21, 2002 4:19 PM Joe, You can stop the services, which should shutdown the database (for cold backup). But, that's not the only option. You can leave services running, and just shutdown the database (using svrmgrl, or sqlplus), and then do the cold backup. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L Sent: Monday, October 21, 2002 9:28 AM My partner sent me a question about services on windows. when doing a cold backup is it necessary to shutdown the windows services?, I have no idea as I've not had the nightmare of dealing with oracle on windoze. joe -- 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).
RE: services on windows?????
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).
Re: services on windows?????
No, Even under Oracle8 it's enough to shutdown the database to do cold backup. Services themselves, when the database is shutdown, do not hold on to the database files. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, October 21, 2002 10:43 AM It seems I was completely wrong, is it the same as for Oracle 8 and 8i? Last time I've worked with Windows it was on Oracle 8 and I thought that you had to stop the services because Windows was not letting you copy the database files. --- Igor Neyman [EMAIL PROTECTED] a écrit : Joe, You can stop the services, which should shutdown the database (for cold backup). But, that's not the only option. You can leave services running, and just shutdown the database (using svrmgrl, or sqlplus), and then do the cold backup. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - From: JOE TESTA To: Multiple recipients of list ORACLE-L Sent: Monday, October 21, 2002 9:28 AM Subject: services on windows? My partner sent me a question about services on windows. when doing a cold backup is it necessary to shutdown the windows services?, I have no idea as I've not had the nightmare of dealing with oracle on windoze. joe = Stéphane Paquette DBA Oracle et DB2, consultant entrepôt de données Oracle and DB2 DBA, datawarehouse consultant [EMAIL PROTECTED] __ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= 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: Igor Neyman 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).
Re: services on windows?????
Not necessarily, shutdown mode (when you stop services)depends on registry setting: ORA_SID_SHUTDOWNTYPE I - for immediate a - for abort Igor Neyman, OCP DBA[EMAIL PROTECTED] - Original Message - From: Yechiel Adar To: Multiple recipients of list ORACLE-L Sent: Monday, October 21, 2002 11:08 AM Subject: Re: services on windows? If you stop the service you perform shutdown abort which is not recommended for cold backup. Yechiel AdarMehish - Original Message - From: Igor Neyman To: Multiple recipients of list ORACLE-L Sent: Monday, October 21, 2002 4:19 PM Subject: Re: services on windows? Joe, You can stop the services, which should shutdown the database (for cold backup). But, that's not the only option. You can leave services running, and just shutdown the database (using svrmgrl, or sqlplus), and then do the cold backup. Igor Neyman, OCP DBA[EMAIL PROTECTED] - Original Message - From: JOE TESTA To: Multiple recipients of list ORACLE-L Sent: Monday, October 21, 2002 9:28 AM Subject: services on windows? My partner sent me a question about services on windows. when doing a cold backup is it necessary to shutdown the windows services?, I have no idea as I've not had the nightmare of dealing with oracle on windoze. joe
RE: services on windows?????
Not sure, but here we do net stop service_name_goes_here_without_brackets and net start xxx. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J 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).
RE: services on windows?????
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).
RE: services on windows?????
I use Oracle 7.3.4, 8.0.5 and 8.1.7 on windoze and none of them require that the windoze service to be stopped. You can but it is not necessary. Dave -Original Message- Sent: Monday, October 21, 2002 9:44 AM To: Multiple recipients of list ORACLE-L It seems I was completely wrong, is it the same as for Oracle 8 and 8i? Last time I've worked with Windows it was on Oracle 8 and I thought that you had to stop the services because Windows was not letting you copy the database files. --- Igor Neyman [EMAIL PROTECTED] a écrit : Joe, You can stop the services, which should shutdown the database (for cold backup). But, that's not the only option. You can leave services running, and just shutdown the database (using svrmgrl, or sqlplus), and then do the cold backup. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - From: JOE TESTA To: Multiple recipients of list ORACLE-L Sent: Monday, October 21, 2002 9:28 AM Subject: services on windows? My partner sent me a question about services on windows. when doing a cold backup is it necessary to shutdown the windows services?, I have no idea as I've not had the nightmare of dealing with oracle on windoze. joe = Stéphane Paquette DBA Oracle et DB2, consultant entrepôt de données Oracle and DB2 DBA, datawarehouse consultant [EMAIL PROTECTED] __ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= 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: Farnsworth, Dave 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).
Re: services on windows?????
It seems I was completely wrong, is it the same as for Oracle 8 and 8i? Last time I've worked with Windows it was on Oracle 8 and I thought that you had to stop the services because Windows was not letting you copy the database files. --- Igor Neyman [EMAIL PROTECTED] a écrit : Joe, You can stop the services, which should shutdown the database (for cold backup). But, that's not the only option. You can leave services running, and just shutdown the database (using svrmgrl, or sqlplus), and then do the cold backup. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - From: JOE TESTA To: Multiple recipients of list ORACLE-L Sent: Monday, October 21, 2002 9:28 AM Subject: services on windows? My partner sent me a question about services on windows. when doing a cold backup is it necessary to shutdown the windows services?, I have no idea as I've not had the nightmare of dealing with oracle on windoze. joe = Stéphane Paquette DBA Oracle et DB2, consultant entrepôt de données Oracle and DB2 DBA, datawarehouse consultant [EMAIL PROTECTED] __ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= 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).