RE: dbshut script - shutdown or shutdown immediate
instance recovery time is more manageable in 9i -- mttr_fast_start_target in the init.ora. For a time, in version 6, Oracle said you HAD to use shutdown abort, that a shutdown immediate could corrupt the database (that was an undocumented feature) I've had cases where the regular, automated backup procedure did a shutdown immediate. And because some programmer had left an ad hoc query running, the database did not shut down, the backup did not complete and when the users came in in the morning, they couldn't access the database. If you are going to use shutdown immediate, you need to be aware that it could hang, and leave your database in an half-life state -- neither shutdown nor started up. Make sure you have a process that monitors how long the shutdown immediate is taking and either alerts you that the time is excessive or kills the shutdown immediate and does a shutdown abort. And if you do a shutdown abort as standard practice, I'd suggest following it immediate with startup restrict and then shutdown for a clean shutdown --- Mark Richard [EMAIL PROTECTED] wrote: I don't think the issue is so much about whether Oracle recovery can handle a database crash or not. I think the issue is whether you want to spend the time of going through that process. I'm sure recovery can also handle the server being powered cycled but how many people do that without shutting down Oracle first? Since we had a car analogy already in this thread... I'm confident that the seat belts in my car work but I'm in no rush to test them out, and even if they do work I'm likely to end up bruised anyway. I guess the bruising my equate to overtime spent recovering the database... Oh, I hate trying to make really good analogies. Rachel Carmichael To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED] cc: ahoo.comSubject: RE: dbshut script - shutdown or shutdown immediate Sent by: [EMAIL PROTECTED] om 03/04/2003 12:33 Please respond to ORACLE-L yeah so? are you suggesting that Oracle instance recovery can't handle a database crash? If so, better pray your server never crashes. --- Pardee, Roy E [EMAIL PROTECTED] wrote: Well... my official oracle instructor in dba larva school said that it's tantamount to crashing the db--or so I recall anyway. This isn't so? Peace, -Roy Roy Pardee Programmer/Analyst SWFPAC Lockheed Martin IT Extension 8487 -Original Message- Sent: Wednesday, April 02, 2003 2:09 PM To: Multiple recipients of list ORACLE-L On Wed, 2 Apr 2003, Chris Berry wrote: Shutdown abort is pretty drastic, are you sure shutdown immediate didn't work? What is drastic about shutdown abort? Never one to opt out of a shutdown abort thread, -- Jeremiah Wilton http://www.speakeasy.net/~jwilton - Uses shutdown abort exclusively - successful shutdowns/startups: over 10,000 - problems with shutdown abort: 0 - versions used: 7.3.2.3 - 10.0 (yes I have a pre-beta) - still employed! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
RE: dbshut script - shutdown or shutdown immediate
Mark has hit on the crux of the issue. Most of us have expectations from users and management that we will have the databases available as much as possible. Downtime costs money and should be avoided. That said, we will eventually need downtime for one reason or another. The question becomes how do we minimize it. I use shutdown abort to increase availability. If you 'alter system checkpoint' before you shutdown abort, then automatic crash recovery is extremely fast, since only a few bytes of redo need to be applied. On the other hand, if you shutdown immediate, you may be waiting all day for those temp segments to get deallocated or for that large transaction to get rolled back. With abort, the deallocation doesn't have to happen (it was unnecessary anyway), and the rollback is deferred until after the database is open again and already available to users. So use your test systems, load them up like production, and try both. I bet in 9 out of 10 cases, checkpoint+abort+startup will be much faster than shutdown immediate+startup. Of course, there are cases when you need a consistent database while down. Switching to archivelog mode is one example. For those, checkpoint+abort+startup restict+shutdown immediate should do the trick. This may only be useful if you are running a system that is busy enough to have immediate take a long time. I don't know why I am such a tyrant on this issue. I guess I think it exposes fuzzy thinking. Yes I have driven to work many times without accidents, but comparing this to many succesful aborts is inaccurate. Cars are not designed in a fundamental way not to strike each other. People have to be careful when driving not to hit each other. Oracle, on the other hand, is fundamentally designed to start up after a shutdown abort. I have reason to expect that I may have an accident if I am not careful while driving. But so far, nobody has produced current bug numbers and issues or even solid reasoning that leads me to believe that using shutdown abort is dangerous or won't work consistently. If abort is more dangerous than immediate, can we get a list of other fully supported features of Oracle that are considered dangerous? We should call support and file a bug, no? It reminds me of instructions for doing something I once found on MetaLink: One of the steps read: Start up the database carefully. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Wed, 2 Apr 2003, Mark Richard wrote: I don't think the issue is so much about whether Oracle recovery can handle a database crash or not. I think the issue is whether you want to spend the time of going through that process. I'm sure recovery can also handle the server being powered cycled but how many people do that without shutting down Oracle first? Since we had a car analogy already in this thread... I'm confident that the seat belts in my car work but I'm in no rush to test them out, and even if they do work I'm likely to end up bruised anyway. I guess the bruising my equate to overtime spent recovering the database... Oh, I hate trying to make really good analogies. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton 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: dbshut script - shutdown or shutdown immediate
Chris, We hang on shutdown immediate, not startup. That's why I choose to use shutdown abort. Joan Chris Berry wrote: Schauss, Peter wrote: I have one Oracle instance which supports an application server which always maintains a database connection. The UNIX system administrator tells me that this instance always hangs when she tries to shut down the system. The other instances, which do not support a 24x7 process shut down properly. Looking at $ORACLE_HOME/bin/dbshut, I notice that the input to sqlplus is connect internal shutdown Should I modify the script to shutdown immediate so that it kills any connections? Environment is Oracle 8.1.7 /AIX 4.3.3. From: Joan Hsieh [EMAIL PROTECTED] Peter, I modified to shutdown abort, starup then shutdown immediate. Shutdown abort is pretty drastic, are you sure shutdown immediate didn't work? From: Joan Hsieh [EMAIL PROTECTED] At first, we do shutdown immediate, then startup. But we do have couple times hang there and couldn't do the cold backup. Since changed to shutdown abort, startup and shutdown immediate, we don't have any problem at all. our database is in archive mode. Since our production database has to refresh to reporting database nightly. I couldn't do checkpoint before shutdown abort. (some error, forgot on reporting database) otherwise, I will add to it. If it's hanging on the startup I recommend trying this: shutdown immediate startup nomount alter database mount alter database open You should get an error message at one of those steps that will lead you to the real problem. Chris Berry [EMAIL PROTECTED] Systems Administrator JM Associates Without change, something sleeps inside us, and seldom awakens. The sleeper must awaken. -- Duke Leto Atreides _ Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chris Berry 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.net -- Author: Joan Hsieh 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: dbshut script - shutdown or shutdown immediate
I am certainly not suggesting that recovery can't handle a crash--I'm just trying to make sure that I understand what shutdown abort does. Some posts have implied that it's no big deal, which is counter-intuitive to me. To me, crashing a program on purpose seems like a drastic measure. No doubt desperate times can call for desperate measures, but I would have guessed that optimally, you'd try immediate first then abort if immediate takes too long. But I'm just learning this stuff... Cheers, -Roy Roy Pardee Programmer/Analyst SWFPAC Lockheed Martin IT Extension 8487 -Original Message- Sent: Wednesday, April 02, 2003 6:34 PM To: Multiple recipients of list ORACLE-L yeah so? are you suggesting that Oracle instance recovery can't handle a database crash? If so, better pray your server never crashes. --- Pardee, Roy E [EMAIL PROTECTED] wrote: Well... my official oracle instructor in dba larva school said that it's tantamount to crashing the db--or so I recall anyway. This isn't so? Peace, -Roy Roy Pardee Programmer/Analyst SWFPAC Lockheed Martin IT Extension 8487 -Original Message- Sent: Wednesday, April 02, 2003 2:09 PM To: Multiple recipients of list ORACLE-L On Wed, 2 Apr 2003, Chris Berry wrote: Shutdown abort is pretty drastic, are you sure shutdown immediate didn't work? What is drastic about shutdown abort? Never one to opt out of a shutdown abort thread, -- Jeremiah Wilton http://www.speakeasy.net/~jwilton - Uses shutdown abort exclusively - successful shutdowns/startups: over 10,000 - problems with shutdown abort: 0 - versions used: 7.3.2.3 - 10.0 (yes I have a pre-beta) - still employed! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pardee, Roy E 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: dbshut script - shutdown or shutdown immediate
the problem is, if immediate hangs and you have automated the process... nothing happens. it doesn't time out so you sit. and sit and sit. and hope that whatever is keeping the database active will eventually end. In version 7 (7.3.2) I found that while using a third party monitoring package that had a job in the job queue that ran frequently enough (and you WANT monitoring software to monitor things!) that we could never use a shutdown immediate --- Pardee, Roy E [EMAIL PROTECTED] wrote: I am certainly not suggesting that recovery can't handle a crash--I'm just trying to make sure that I understand what shutdown abort does. Some posts have implied that it's no big deal, which is counter-intuitive to me. To me, crashing a program on purpose seems like a drastic measure. No doubt desperate times can call for desperate measures, but I would have guessed that optimally, you'd try immediate first then abort if immediate takes too long. But I'm just learning this stuff... Cheers, -Roy Roy Pardee Programmer/Analyst SWFPAC Lockheed Martin IT Extension 8487 -Original Message- Sent: Wednesday, April 02, 2003 6:34 PM To: Multiple recipients of list ORACLE-L yeah so? are you suggesting that Oracle instance recovery can't handle a database crash? If so, better pray your server never crashes. --- Pardee, Roy E [EMAIL PROTECTED] wrote: Well... my official oracle instructor in dba larva school said that it's tantamount to crashing the db--or so I recall anyway. This isn't so? Peace, -Roy Roy Pardee Programmer/Analyst SWFPAC Lockheed Martin IT Extension 8487 -Original Message- Sent: Wednesday, April 02, 2003 2:09 PM To: Multiple recipients of list ORACLE-L On Wed, 2 Apr 2003, Chris Berry wrote: Shutdown abort is pretty drastic, are you sure shutdown immediate didn't work? What is drastic about shutdown abort? Never one to opt out of a shutdown abort thread, -- Jeremiah Wilton http://www.speakeasy.net/~jwilton - Uses shutdown abort exclusively - successful shutdowns/startups: over 10,000 - problems with shutdown abort: 0 - versions used: 7.3.2.3 - 10.0 (yes I have a pre-beta) - still employed! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pardee, Roy E 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). __ Do you Yahoo!? Yahoo! Tax Center - File online, calculators, forms, and more http://tax.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael 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: dbshut script - shutdown or shutdown immediate
Oh, I wan't advocating a kill -9, just comparing it to a shutdown abort. AFAICT (as far as I can tell) there isn't a great deal of difference. I did, once on Oracle 7.3, have to shutdown the db with a shutdown abort and then just could never get it to open again. Could not recover it and eventually had to go to backups to get it back. I was very fortunate that it was a dev instance. Allan -Original Message- Sent: Wednesday, April 02, 2003 10:54 PM To: Multiple recipients of list ORACLE-L I think I would still prefer a shutdown abort over a kill -9. There might be even a slight level of control and error management in a shutdown abort but not in a kill -9 nothing and I repeat nothing can avoid a kill -9 and there is no cleanup by the process that is killed. Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Nelson, Allan [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 03/04/2003 09:14 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: dbshut script - shutdown or shutdown immediate Suppose you have a database with a sid of mydb running on unix. Shutdown abort is like doing the following from the unix command line: ps -ef | grep mydb | grep -v grep | xargs kill -9. All the processes that make up the instance or processes that are connected to that instance are killed. The database will require instance recovery on the next start. Allan -Original Message- Sent: Wednesday, April 02, 2003 4:29 PM To: Multiple recipients of list ORACLE-L Well... my official oracle instructor in dba larva school said that it's tantamount to crashing the db--or so I recall anyway. This isn't so? Peace, -Roy Roy Pardee Programmer/Analyst SWFPAC Lockheed Martin IT Extension 8487 -Original Message- Sent: Wednesday, April 02, 2003 2:09 PM To: Multiple recipients of list ORACLE-L On Wed, 2 Apr 2003, Chris Berry wrote: Shutdown abort is pretty drastic, are you sure shutdown immediate didn't work? What is drastic about shutdown abort? Never one to opt out of a shutdown abort thread, -- Jeremiah Wilton http://www.speakeasy.net/~jwilton - Uses shutdown abort exclusively - successful shutdowns/startups: over 10,000 - problems with shutdown abort: 0 - versions used: 7.3.2.3 - 10.0 (yes I have a pre-beta) - still employed! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton 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.net -- Author: Pardee, Roy E 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). __ This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email
Re: dbshut script - shutdown or shutdown immediate
Using immediate or abort is a matter of personal preference. Use whichever option that works for you. But I would not agree that using shutdown abort is risky or should be avoided. (I don't know of any bugs with shutdown abort. There could be, but then a lot of other things also could go wrong. The bug with the UNDO tablespace with 9.0.1 for instance. Can we be sure something similar will not happen again ? So do we stop using that feature altogether ?) My personal preference is to use shutdown abort and I have been using it ever since I can remember. Never had any problems. If I want the database in a consistent state for whatever reason, then I would rather start it up again and shut it down. Most of the times the databases are not shutdown manually. The shutdown scripts get called when the box is going down and immediate or normal would not be the right choice in this scenario. Of course it would not be a lot different if we don't shutdown the databases when the box is going down ;) But if I have the startup script in place as well have the shutdown script too. I am not suggesting one option should be used instead of the other. Its a question of personal preference. The point I am trying to make is if the situation demands shutdown abort, then it doesn't make sense jumping through hoops not to use it. Regards, Denny Quoting Daniel W. Fink [EMAIL PROTECTED]: Shutdown Immediate v. Shutdown abort (Tastes Great...Less Filling!) I'll admit to being in the Immediate camp. Why? I like the database to come down in a consistent state except in emergency circumstances. There have been bugs related to shutdown abort causing database problems. Do those in the Abort camp have valid reasons? Absolutely! Recovery is quicker and problems are extremely rare. I have a higher level of comfort in immediate. That is why I use it. Can I use abort/startup restrict/normal without incurring problems? Yes, except in rare cases. Almost certainly more rare than the times when the immediate takes longer than expected. I don't think this issue is one of black and white/right and wrong, but rather varying shades of gray. Okay, Connor...your turn! -- Daniel W. Fink http://www.optimaldba.com IOUG-A Live! April 27 - May 1, 2003 Orlando, FL Sunday, April 27 8:30am - 4:30pm - Problem Solving with Oracle 9i SQL Thursday, May 1 1:00pm - 2:00pm - Automatic Undo Internals -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Denny Koovakattu 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: dbshut script - shutdown or shutdown immediate
SQL*Server doesn't crash, it's a disorganized retreat. *-) Dick Goulet -Original Message- Sent: Wednesday, April 02, 2003 11:14 PM To: Multiple recipients of list ORACLE-L Oracle crash??? What's that :)??? Isn't that a bug in SQL Server only ? -Mensaje original- De: Rachel Carmichael [mailto:[EMAIL PROTECTED] Enviado el: Miércoles, 02 de Abril de 2003 22:34 Para: Multiple recipients of list ORACLE-L Asunto: RE: dbshut script - shutdown or shutdown immediate yeah so? are you suggesting that Oracle instance recovery can't handle a database crash? If so, better pray your server never crashes. --- Pardee, Roy E [EMAIL PROTECTED] wrote: Well... my official oracle instructor in dba larva school said that it's tantamount to crashing the db--or so I recall anyway. This isn't so? Peace, -Roy Roy Pardee Programmer/Analyst SWFPAC Lockheed Martin IT Extension 8487 -Original Message- Sent: Wednesday, April 02, 2003 2:09 PM To: Multiple recipients of list ORACLE-L On Wed, 2 Apr 2003, Chris Berry wrote: Shutdown abort is pretty drastic, are you sure shutdown immediate didn't work? What is drastic about shutdown abort? Never one to opt out of a shutdown abort thread, -- Jeremiah Wilton http://www.speakeasy.net/~jwilton - Uses shutdown abort exclusively - successful shutdowns/startups: over 10,000 - problems with shutdown abort: 0 - versions used: 7.3.2.3 - 10.0 (yes I have a pre-beta) - still employed! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton 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.net -- Author: Pardee, Roy E 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). __ Do you Yahoo!? Yahoo! Tax Center - File online, calculators, forms, and more http://tax.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael 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.net -- Author: Nelson Flores 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.net -- Author: Goulet, Dick 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: dbshut script - shutdown or shutdown immediate
Precisely. I am trying to propose the abort option, but I am not the majority around this place I call work.. :) On a more than dozen times in the last few months, I had to kill oracle processes to get the database to shutdown (with immediate), so the scheduled reboot of the machine will continue... And on a number of occasions, the Sunday reboot actually took the server down (and brought it up) on Monday mornings when users complained that they could not get to databases that were shutdown properly with 'shutdown immediate'. - Kirti -Original Message- Sent: Thursday, April 03, 2003 9:24 AM To: Multiple recipients of list ORACLE-L the problem is, if immediate hangs and you have automated the process... nothing happens. it doesn't time out so you sit. and sit and sit. and hope that whatever is keeping the database active will eventually end. In version 7 (7.3.2) I found that while using a third party monitoring package that had a job in the job queue that ran frequently enough (and you WANT monitoring software to monitor things!) that we could never use a shutdown immediate --- Pardee, Roy E [EMAIL PROTECTED] wrote: I am certainly not suggesting that recovery can't handle a crash--I'm just trying to make sure that I understand what shutdown abort does. Some posts have implied that it's no big deal, which is counter-intuitive to me. To me, crashing a program on purpose seems like a drastic measure. No doubt desperate times can call for desperate measures, but I would have guessed that optimally, you'd try immediate first then abort if immediate takes too long. But I'm just learning this stuff... Cheers, -Roy Roy Pardee Programmer/Analyst SWFPAC Lockheed Martin IT Extension 8487 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti 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: dbshut script - shutdown or shutdown immediate
Title: RE: dbshut script - shutdown or shutdown immediate -Original Message- From: Jeremiah Wilton [mailto:[EMAIL PROTECTED]] ... So use your test systems, load them up like production, and try both. I bet in 9 out of 10 cases, checkpoint+abort+startup will be much faster than shutdown immediate+startup. ... Is alter system checkpoint startup force restrict shutdown immediate any different than alter system checkpoint shutdown abort startup restrict shutdown immediate I am of the belief that the two are identical. I use the first three statements. TFM (8.1.7) says STARTUP FORCE: Shuts down the current Oracle instance (if it is running) with SHUTDOWN mode ABORT, before restarting it. If the current instance is running and FORCE is not specified, an error results. FORCE is useful while debugging and under abnormal circumstances. It should not normally be used. Why would there be a warning for STARTUP FORCE saying It should not normally be used when there is no such warning for SHUTDOWN ABORT?
RE: dbshut script - shutdown or shutdown immediate
Title: RE: dbshut script - shutdown or shutdown immediate -Original Message- From: Pardee, Roy E [mailto:[EMAIL PROTECTED]] I would have guessed that optimally, you'd try immediate first then abort if immediate takes too long. I've read that some people on the list have done this. I am curious as to how this is implemented. How long is too long? And how is this coded? I'm trying to think how you would write this with shell scripts for example.
RE: dbshut script - shutdown or shutdown immediate
Jacques - We have used SHUTDOWN IMMEDIATE for over 5 years now for cold backups, with zero problems. Weekend before last we had 3 production databases that didn't go down for backup (all of our databases scheduled for cold backups). When I checked the following morning they were just hanging. The problem hasn't occurred since. Naturally I'll be checking this weekend :-) We are running RMAN, just haven't gotten authorization to turn off cold backups. If you are doing it interactively, you can check the processes in Unix with ps to see if one of the Oracle processes is doing a lot of work. I've seen it take 20 minutes to clean everything up and shut down. When a problem has occurred, that can be a LONG 20 minutes. That is part of the DBA skill set -- how to divert the attention of the people standing around your desk while you wait :-) Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, April 03, 2003 1:24 PM To: Multiple recipients of list ORACLE-L -Original Message- From: Pardee, Roy E [ mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ] I would have guessed that optimally, you'd try immediate first then abort if immediate takes too long. I've read that some people on the list have done this. I am curious as to how this is implemented. How long is too long? And how is this coded? I'm trying to think how you would write this with shell scripts for example. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS 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: dbshut script - shutdown or shutdown immediate
Here's how we do it: We have 2 cron jobs, one of which runs 10 minutes after the first. The first does a shutdown immediate. The second checks if oracle is running and, if so, does a shutdown abort. -Original Message- Sent: Thursday, April 03, 2003 2:24 PM To: Multiple recipients of list ORACLE-L -Original Message- From: Pardee, Roy E [ mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ] I would have guessed that optimally, you'd try immediate first then abort if immediate takes too long. I've read that some people on the list have done this. I am curious as to how this is implemented. How long is too long? And how is this coded? I'm trying to think how you would write this with shell scripts for example. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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: dbshut script - shutdown or shutdown immediate
Here's one way to do it:
OS_USER=jkstill
USERNAME=jkstill
PASSWORD=$(pwc.pl -username $USERNAME -instance $ORACLE_SID)
echo $PASSWORD
unset SQLPATH
# emulating a 10 second shutdown
(
sqlplus -s /nolog EOF
connect $USERNAME/[EMAIL PROTECTED];
exec dbms_lock.sleep(10)
EOF
)
BG=$!
echo BG: $BG
# we only want to wait 5 seconds for shutdown
# we are very impatient
sleep 5
STILL_RUNNING=$(ps -flu${OS_USER}|awk '{print $4}'|grep ^${BG}$)
echo STILL_RUNNING: $STILL_RUNNING
[ -z $STILL_RUNNING ] || {
echo Took too long. You could run shutdown abort here
ps -flu${OS_USER}
kill -9 $BG
ps -flu${OS_USER}
}
Jacques Kilchoer [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
04/03/2003 11:23 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: dbshut script - shutdown or shutdown immediate
-Original Message-
From: Pardee, Roy E [mailto:[EMAIL PROTECTED]
I would
have guessed
that optimally, you'd try immediate first then abort if
immediate takes
too long.
I've read that some people on the list have done this. I am curious as to
how this is implemented.
How long is too long? And how is this coded? I'm trying to think how you
would write this with shell scripts for example.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
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: dbshut script - shutdown or shutdown immediate
Alas, I'm until recently a prisoner of windows so I can't speak to shell scripts. On windows I'd probably try a windows script host vbscript like so: warning = air code Option Explicit Dim WinShell Dim jobImmediate Dim StartTime Dim ImmediateFailed Const WaitMinutes = 15 Set WinShell = CreateObject(WScript.Shell) ImmediateFailed = False StartTime = Now Set jobImmediate = WinShell.Exec(call to sqlplus w/shutdown immediate script) Do While jobImmediate.Status = WSHRunning WScript.Sleep 5000 If DateDiff(n, StartTime, Now) WaitMinutes And Not ImmediateFailed Then jobImmediate.Terminate ImmediateFailed = True End If Loop If ImmediateFailed Then similar code attempts a shutdown abort script End If /warning = air code I would guess that you could do something similar w/perl... Cheers, -Roy Roy Pardee Programmer/Analyst SWFPAC Lockheed Martin IT Extension 8487 -Original Message- Sent: Thursday, April 03, 2003 11:24 AM To: Multiple recipients of list ORACLE-L -Original Message- From: Pardee, Roy E [mailto:[EMAIL PROTECTED] I would have guessed that optimally, you'd try immediate first then abort if immediate takes too long. I've read that some people on the list have done this. I am curious as to how this is implemented. How long is too long? And how is this coded? I'm trying to think how you would write this with shell scripts for example. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pardee, Roy E 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: dbshut script - shutdown or shutdown immediate
From: Joan Hsieh [EMAIL PROTECTED] Chris, We hang on shutdown immediate, not startup. That's why I choose to use shutdown abort. Well, in that case of course you'd use it, but personally, if it was me, I'd want to find out why it was hanging, and fix that instead. I'm not suggesting shutdown abort never be used, I'm just saying use the right tool for the right job when you have a choice. Chris Berry [EMAIL PROTECTED] Systems Administrator JM Associates Without change, something sleeps inside us, and seldom awakens. The sleeper must awaken. -- Duke Leto Atreides _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chris Berry 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).
dbshut script - shutdown or shutdown immediate
I have one Oracle instance which supports an application server which always maintains a database connection. The UNIX system administrator tells me that this instance always hangs when she tries to shut down the system. The other instances, which do not support a 24x7 process shut down properly. Looking at $ORACLE_HOME/bin/dbshut, I notice that the input to sqlplus is connect internal shutdown Should I modify the script to shutdown immediate so that it kills any connections? Environment is Oracle 8.1.7 /AIX 4.3.3. Thanks, Peter Schauss Northrop Grumman Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schauss, Peter 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: dbshut script - shutdown or shutdown immediate
Peter: One of the first things we do after installing Oracle is to modify dbshut to 'shutdown immediate'. We have had no side-effects from this change. Cheers, Mike -Original Message- Sent: Wednesday, April 02, 2003 7:04 AM To: Multiple recipients of list ORACLE-L I have one Oracle instance which supports an application server which always maintains a database connection. The UNIX system administrator tells me that this instance always hangs when she tries to shut down the system. The other instances, which do not support a 24x7 process shut down properly. Looking at $ORACLE_HOME/bin/dbshut, I notice that the input to sqlplus is connect internal shutdown Should I modify the script to shutdown immediate so that it kills any connections? Environment is Oracle 8.1.7 /AIX 4.3.3. Thanks, Peter Schauss Northrop Grumman Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schauss, Peter 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.net -- Author: Vergara, Michael (TEM) 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: dbshut script - shutdown or shutdown immediate
Peter, I modified to shutdown abort, starup then shutdown immediate. joan Schauss, Peter wrote: I have one Oracle instance which supports an application server which always maintains a database connection. The UNIX system administrator tells me that this instance always hangs when she tries to shut down the system. The other instances, which do not support a 24x7 process shut down properly. Looking at $ORACLE_HOME/bin/dbshut, I notice that the input to sqlplus is connect internal shutdown Should I modify the script to shutdown immediate so that it kills any connections? Environment is Oracle 8.1.7 /AIX 4.3.3. Thanks, Peter Schauss Northrop Grumman Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schauss, Peter 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.net -- Author: Joan Hsieh 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: dbshut script - shutdown or shutdown immediate
Peter, Shutdown immediate would be a better choice. Might also be a good idea to have the app server process stopped prior to the database instance being shutdown. I have seen apps that have left ghost connections or go nuts when the database disappeared (bad error handling I guess). david From: Schauss, Peter [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: dbshut script - shutdown or shutdown immediate Date: Wed, 02 Apr 2003 07:03:38 -0800 I have one Oracle instance which supports an application server which always maintains a database connection. The UNIX system administrator tells me that this instance always hangs when she tries to shut down the system. The other instances, which do not support a 24x7 process shut down properly. Looking at $ORACLE_HOME/bin/dbshut, I notice that the input to sqlplus is connect internal shutdown Should I modify the script to shutdown immediate so that it kills any connections? Environment is Oracle 8.1.7 /AIX 4.3.3. Thanks, Peter Schauss Northrop Grumman Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schauss, Peter 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). _ MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: david davis 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: dbshut script - shutdown or shutdown immediate
We do shutdown abort. But we do checkpoint before shutdown abort i.e, alter system checkpoint; shutdown abort; Then, while bringing up, we do startup restrict; shutdown immediate; startup Rao -Original Message- Sent: Wednesday, April 02, 2003 11:34 AM To: Multiple recipients of list ORACLE-L Peter, I modified to shutdown abort, starup then shutdown immediate. joan Schauss, Peter wrote: I have one Oracle instance which supports an application server which always maintains a database connection. The UNIX system administrator tells me that this instance always hangs when she tries to shut down the system. The other instances, which do not support a 24x7 process shut down properly. Looking at $ORACLE_HOME/bin/dbshut, I notice that the input to sqlplus is connect internal shutdown Should I modify the script to shutdown immediate so that it kills any connections? Environment is Oracle 8.1.7 /AIX 4.3.3. Thanks, Peter Schauss Northrop Grumman Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schauss, Peter 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.net -- Author: Joan Hsieh 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.net -- Author: [EMAIL PROTECTED] 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: dbshut script - shutdown or shutdown immediate
Yes, that should be a standard practice any time you perform an new Oracle install. Otherwise, that database will problably always hang waiting for all sessions to disconnect before completing the shutdown. I believe the latest versions of Oracle have corrected that issue in the dbshut script. -Original Message- Peter Sent: Wednesday, April 02, 2003 9:04 AM To: Multiple recipients of list ORACLE-L I have one Oracle instance which supports an application server which always maintains a database connection. The UNIX system administrator tells me that this instance always hangs when she tries to shut down the system. The other instances, which do not support a 24x7 process shut down properly. Looking at $ORACLE_HOME/bin/dbshut, I notice that the input to sqlplus is connect internal shutdown Should I modify the script to shutdown immediate so that it kills any connections? Environment is Oracle 8.1.7 /AIX 4.3.3. Thanks, Peter Schauss Northrop Grumman Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schauss, Peter 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.net -- Author: Gary W. Parker 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: dbshut script - shutdown or shutdown immediate
I also started doing this a couple months ago and have not had a shutdown hang since. Dave -Original Message- Sent: Wednesday, April 02, 2003 11:04 AM To: Multiple recipients of list ORACLE-L We do shutdown abort. But we do checkpoint before shutdown abort i.e, alter system checkpoint; shutdown abort; Then, while bringing up, we do startup restrict; shutdown immediate; startup Rao -Original Message- Sent: Wednesday, April 02, 2003 11:34 AM To: Multiple recipients of list ORACLE-L Peter, I modified to shutdown abort, starup then shutdown immediate. joan Schauss, Peter wrote: I have one Oracle instance which supports an application server which always maintains a database connection. The UNIX system administrator tells me that this instance always hangs when she tries to shut down the system. The other instances, which do not support a 24x7 process shut down properly. Looking at $ORACLE_HOME/bin/dbshut, I notice that the input to sqlplus is connect internal shutdown Should I modify the script to shutdown immediate so that it kills any connections? Environment is Oracle 8.1.7 /AIX 4.3.3. Thanks, Peter Schauss Northrop Grumman Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schauss, Peter 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.net -- Author: Joan Hsieh 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.net -- Author: [EMAIL PROTECTED] 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.net -- 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: dbshut script - shutdown or shutdown immediate
We replace the simple shutdown command with: shutdown immediate startup restrict alter system switch logfile; host sleep 10 shutdown immediate We recently installed 9.2.0.2-64bit on AIX. As of that release, Oracle is still shipping dbshut with simply shutdown normal. -- *--- * Stephen T. Murphy Manager, Database and Technical Support ITS - University Applications Development MSC-100 The University at Albany, S.U.N.Y Albany, New York1 Phone: (518) 437-4523 Fax: (518) 437-4540 MailTo: [EMAIL PROTECTED] AIM: SMurphy199 -Original Message- Sent: Wednesday, April 02, 2003 11:19 AM To: Multiple recipients of list ORACLE-L Yes, that should be a standard practice any time you perform an new Oracle install. Otherwise, that database will problably always hang waiting for all sessions to disconnect before completing the shutdown. I believe the latest versions of Oracle have corrected that issue in the dbshut script. -Original Message- Peter Sent: Wednesday, April 02, 2003 9:04 AM To: Multiple recipients of list ORACLE-L I have one Oracle instance which supports an application server which always maintains a database connection. The UNIX system administrator tells me that this instance always hangs when she tries to shut down the system. The other instances, which do not support a 24x7 process shut down properly. Looking at $ORACLE_HOME/bin/dbshut, I notice that the input to sqlplus is connect internal shutdown Should I modify the script to shutdown immediate so that it kills any connections? Environment is Oracle 8.1.7 /AIX 4.3.3. Thanks, Peter Schauss Northrop Grumman Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schauss, Peter 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.net -- Author: Gary W. Parker 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.net -- Author: Stephen Murphy 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: dbshut script - shutdown or shutdown immediate
On Wed, 2 Apr 2003, [EMAIL PROTECTED] wrote: Then, while bringing up, we do startup restrict; shutdown immediate; startup Why? Doesn't it start up fine the first time? -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton 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: dbshut script - shutdown or shutdown immediate
Schauss, Peter wrote: I have one Oracle instance which supports an application server which always maintains a database connection. The UNIX system administrator tells me that this instance always hangs when she tries to shut down the system. The other instances, which do not support a 24x7 process shut down properly. Looking at $ORACLE_HOME/bin/dbshut, I notice that the input to sqlplus is connect internal shutdown Should I modify the script to shutdown immediate so that it kills any connections? Environment is Oracle 8.1.7 /AIX 4.3.3. From: Joan Hsieh [EMAIL PROTECTED] Peter, I modified to shutdown abort, starup then shutdown immediate. Shutdown abort is pretty drastic, are you sure shutdown immediate didn't work? Chris Berry [EMAIL PROTECTED] Systems Administrator JM Associates Without change, something sleeps inside us, and seldom awakens. The sleeper must awaken. -- Duke Leto Atreides _ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chris Berry 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: dbshut script - shutdown or shutdown immediate
Also in the dbshut, change the connect internal to use sqlplus and / as sysdba as the connectivity string. This is the approved method for Oracle8i and Oracle9i. Reginald W. Bailey IBM Global Services - ETS SW GDSD - Database Management Your Friendly Neighborhood DBA 713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager) [EMAIL PROTECTED] Sent by: To: [EMAIL PROTECTED] [EMAIL PROTECTED] cc: om Subject: RE: dbshut script - shutdown or shutdown immediate 04/02/2003 10:19 AM Please respond to ORACLE-L Yes, that should be a standard practice any time you perform an new Oracle install. Otherwise, that database will problably always hang waiting for all sessions to disconnect before completing the shutdown. I believe the latest versions of Oracle have corrected that issue in the dbshut script. -Original Message- Peter Sent: Wednesday, April 02, 2003 9:04 AM To: Multiple recipients of list ORACLE-L I have one Oracle instance which supports an application server which always maintains a database connection. The UNIX system administrator tells me that this instance always hangs when she tries to shut down the system. The other instances, which do not support a 24x7 process shut down properly. Looking at $ORACLE_HOME/bin/dbshut, I notice that the input to sqlplus is connect internal shutdown Should I modify the script to shutdown immediate so that it kills any connections? Environment is Oracle 8.1.7 /AIX 4.3.3. Thanks, Peter Schauss Northrop Grumman Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schauss, Peter 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.net -- Author: Gary W. Parker 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.net -- 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
Re: dbshut script - shutdown or shutdown immediate
Shutdown abort is pretty drastic, are you sure shutdown immediate didn't work? Well said. This topic has been circulating in many DBA forums for a long time. Shutdown immediate does rollback and will take time if no.of users is high. On the otherside, shutdown abort simply takes the db down and does not bother about anything else. As per manual, if you do a shutdown abort then you WILL need the online redo logs for recovery just in case. Think twice if your db is in NOARCHIVELOG mode. If your db is in ARCHIVE mode make sure the logs are multiplexed. Though Oracle's recovery seems to be sturdy, double check your backup recovery strategies. Also, which option to use is influenced by how much downtime/shutdown time you can afford. HTH GovindanK -- |XXX| |You should treat others the way you want to be treated - Mahatma Gandhi| |XXX| __ Try AOL and get 1045 hours FREE for 45 days! http://free.aol.com/tryaolfree/index.adp?375380 Get AOL Instant Messenger 5.1 for FREE! Download Now! http://aim.aol.com/aimnew/Aim/register.adp?promo=380455 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: GovindanK 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: dbshut script - shutdown or shutdown immediate
Multiplexing redo logs has nothing to do with the archive mode. Logs are multiplexed so that an error writing to one of the members in a group does not cause the instance to terminate. Myth - If you use disk mirroring, you don't need to multiplex your redo logs. Reality - Mirroring only protects from hardware failure. It will not protect you from accidental deletion of the log (been there, had to fix it!). -- Daniel W. Fink http://www.optimaldba.com IOUG-A Live! April 27 - May 1, 2003 Orlando, FL Sunday, April 27 8:30am - 4:30pm - Problem Solving with Oracle 9i SQL Thursday, May 1 1:00pm - 2:00pm - Automatic Undo Internals GovindanK wrote: Shutdown abort is pretty drastic, are you sure shutdown immediate didn't work? Well said. This topic has been circulating in many DBA forums for a long time. Shutdown immediate does rollback and will take time if no.of users is high. On the otherside, shutdown abort simply takes the db down and does not bother about anything else. As per manual, if you do a shutdown abort then you WILL need the online redo logs for recovery just in case. Think twice if your db is in NOARCHIVELOG mode. If your db is in ARCHIVE mode make sure the logs are multiplexed. Though Oracle's recovery seems to be sturdy, double check your backup recovery strategies. Also, which option to use is influenced by how much downtime/shutdown time you can afford. HTH GovindanK
Re: dbshut script - shutdown or shutdown immediate
At first, we do shutdown immediate, then startup. But we do have couple times hang there and couldn't do the cold backup. Since changed to shutdown abort, startup and shutdown immediate, we don't have any problem at all. our database is in archive mode. Since our production database has to refresh to reporting database nightly. I couldn't do checkpoint before shutdown abort. (some error, forgot on reporting database) otherwise, I will add to it. Joan Chris Berry wrote: Schauss, Peter wrote: I have one Oracle instance which supports an application server which always maintains a database connection. The UNIX system administrator tells me that this instance always hangs when she tries to shut down the system. The other instances, which do not support a 24x7 process shut down properly. Looking at $ORACLE_HOME/bin/dbshut, I notice that the input to sqlplus is connect internal shutdown Should I modify the script to shutdown immediate so that it kills any connections? Environment is Oracle 8.1.7 /AIX 4.3.3. From: Joan Hsieh [EMAIL PROTECTED] Peter, I modified to shutdown abort, starup then shutdown immediate. Shutdown abort is pretty drastic, are you sure shutdown immediate didn't work? Chris Berry [EMAIL PROTECTED] Systems Administrator JM Associates Without change, something sleeps inside us, and seldom awakens. The sleeper must awaken. -- Duke Leto Atreides _ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chris Berry 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.net -- Author: Joan Hsieh 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: dbshut script - shutdown or shutdown immediate
This topic is getting interesting once more. Lets contribute. Multiplexing redo logs has nothing to do with the archive mode. Take a situation wherein the db is in NOARCH mode with only one member per group (default setup). The dba gives shutdown abort and upon starting for some reason the active log could not be read for recovery. How would one perform a complete recovery?. Let me know if you have a workaround. I am willing to learn. GovindanK -- |XXX| |You should treat others the way you want to be treated - Mahatma Gandhi| |XXX| Daniel W. Fink [EMAIL PROTECTED] wrote: Multiplexing redo logs has nothing to do with the archive mode. Logs are multiplexed so that an error writing to one of the members in a group does not cause the instance to terminate. Myth - If you use disk mirroring, you don't need to multiplex your redo logs. Reality - Mirroring only protects from hardware failure. It will not protect you from accidental deletion of the log (been there, had to fix it!). -- Daniel W. Fink http://www.optimaldba.com GovindanK wrote: Shutdown abort is pretty drastic, are you sure shutdown immediate didn't work? Well said. This topic has been circulating in many DBA forums for a long time. Shutdown immediate does rollback and will take time if no.of users is high. On the otherside, shutdown abort simply takes the db down and does not bother about anything else. As per manual, if you do a shutdown abort then you WILL need the online redo logs for recovery just in case. Think twice if your db is in NOARCHIVELOG mode. If your db is in ARCHIVE mode make sure the logs are multiplexed. Though Oracle's recovery seems to be sturdy, double check your backup recovery strategies. Also, which option to use is influenced by how much downtime/shutdown time you can afford. HTH GovindanK __ Try AOL and get 1045 hours FREE for 45 days! http://free.aol.com/tryaolfree/index.adp?375380 Get AOL Instant Messenger 5.1 for FREE! Download Now! http://aim.aol.com/aimnew/Aim/register.adp?promo=380455 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: GovindanK 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: dbshut script - shutdown or shutdown immediate
What does this have to do with archivelog mode? In the bizarre scenario in which you lose a log between the time you shut down and started up, you are screwed with or without archivelog mode. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Wed, 2 Apr 2003, GovindanK wrote: This topic is getting interesting once more. Lets contribute. Multiplexing redo logs has nothing to do with the archive mode. Take a situation wherein the db is in NOARCH mode with only one member per group (default setup). The dba gives shutdown abort and upon starting for some reason the active log could not be read for recovery. How would one perform a complete recovery?. Let me know if you have a workaround. I am willing to learn. GovindanK -- |XXX| |You should treat others the way you want to be treated - Mahatma Gandhi| |XXX| Daniel W. Fink [EMAIL PROTECTED] wrote: Multiplexing redo logs has nothing to do with the archive mode. Logs are multiplexed so that an error writing to one of the members in a group does not cause the instance to terminate. Myth - If you use disk mirroring, you don't need to multiplex your redo logs. Reality - Mirroring only protects from hardware failure. It will not protect you from accidental deletion of the log (been there, had to fix it!). -- Daniel W. Fink http://www.optimaldba.com GovindanK wrote: Shutdown abort is pretty drastic, are you sure shutdown immediate didn't work? Well said. This topic has been circulating in many DBA forums for a long time. Shutdown immediate does rollback and will take time if no.of users is high. On the otherside, shutdown abort simply takes the db down and does not bother about anything else. As per manual, if you do a shutdown abort then you WILL need the online redo logs for recovery just in case. Think twice if your db is in NOARCHIVELOG mode. If your db is in ARCHIVE mode make sure the logs are multiplexed. Though Oracle's recovery seems to be sturdy, double check your backup recovery strategies. Also, which option to use is influenced by how much downtime/shutdown time you can afford. HTH GovindanK __ Try AOL and get 1045 hours FREE for 45 days! http://free.aol.com/tryaolfree/index.adp?375380 Get AOL Instant Messenger 5.1 for FREE! Download Now! http://aim.aol.com/aimnew/Aim/register.adp?promo=380455 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: GovindanK 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.net -- Author: Jeremiah Wilton 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: dbshut script - shutdown or shutdown immediate
The scenario you describe would occur regardless of the archive mode. An active log cannot be archived. This would require that the ARCH process read the log while LGWR is writing it. Once a log switch occurs (automatic or manual), the previously active log can be archived. In this scenario, you cannot perform a complete recovery. You can recover up to the last log that can be read. If the active log cannot be read, the previous log is the end point of your recovery. -- Daniel W. Fink http://www.optimaldba.com IOUG-A Live! April 27 - May 1, 2003 Orlando, FL Sunday, April 27 8:30am - 4:30pm - Problem Solving with Oracle 9i SQL Thursday, May 1 1:00pm - 2:00pm - Automatic Undo Internals GovindanK wrote: This topic is getting interesting once more. Lets contribute. Multiplexing redo logs has nothing to do with the archive mode. Take a situation wherein the db is in NOARCH mode with only one member per group (default setup). The dba gives shutdown abort and upon starting for some reason the active log could not be read for recovery. How would one perform a complete recovery?. Let me know if you have a workaround. I am willing to learn. GovindanK
Re: dbshut script - shutdown or shutdown immediate
Schauss, Peter wrote: I have one Oracle instance which supports an application server which always maintains a database connection. The UNIX system administrator tells me that this instance always hangs when she tries to shut down the system. The other instances, which do not support a 24x7 process shut down properly. Looking at $ORACLE_HOME/bin/dbshut, I notice that the input to sqlplus is connect internal shutdown Should I modify the script to shutdown immediate so that it kills any connections? Environment is Oracle 8.1.7 /AIX 4.3.3. From: Joan Hsieh [EMAIL PROTECTED] Peter, I modified to shutdown abort, starup then shutdown immediate. Shutdown abort is pretty drastic, are you sure shutdown immediate didn't work? From: Joan Hsieh [EMAIL PROTECTED] At first, we do shutdown immediate, then startup. But we do have couple times hang there and couldn't do the cold backup. Since changed to shutdown abort, startup and shutdown immediate, we don't have any problem at all. our database is in archive mode. Since our production database has to refresh to reporting database nightly. I couldn't do checkpoint before shutdown abort. (some error, forgot on reporting database) otherwise, I will add to it. If it's hanging on the startup I recommend trying this: shutdown immediate startup nomount alter database mount alter database open You should get an error message at one of those steps that will lead you to the real problem. Chris Berry [EMAIL PROTECTED] Systems Administrator JM Associates Without change, something sleeps inside us, and seldom awakens. The sleeper must awaken. -- Duke Leto Atreides _ Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chris Berry 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: dbshut script - shutdown or shutdown immediate
Thanks Dan, I've found myself defending that position from time to time. Jared Daniel W. Fink [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 04/02/2003 11:20 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: dbshut script - shutdown or shutdown immediate Multiplexing redo logs has nothing to do with the archive mode. Logs are multiplexed so that an error writing to one of the members in a group does not cause the instance to terminate. Myth - If you use disk mirroring, you don't need to multiplex your redo logs. Reality - Mirroring only protects from hardware failure. It will not protect you from accidental deletion of the log (been there, had to fix it!). -- Daniel W. Fink http://www.optimaldba.com IOUG-A Live! April 27 - May 1, 2003 Orlando, FL Sunday, April 27 8:30am - 4:30pm - Problem Solving with Oracle 9i SQL Thursday, May 1 1:00pm - 2:00pm - Automatic Undo Internals GovindanK wrote: Shutdown abort is pretty drastic, are you sure shutdown immediate didn't work? Well said. This topic has been circulating in many DBA forums for a long time. Shutdown immediate does rollback and will take time if no.of users is high. On the otherside, shutdown abort simply takes the db down and does not bother about anything else. As per manual, if you do a shutdown abort then you WILL need the online redo logs for recovery just in case. Think twice if your db is in NOARCHIVELOG mode. If your db is in ARCHIVE mode make sure the logs are multiplexed. Though Oracle's recovery seems to be sturdy, double check your backup recovery strategies. Also, which option to use is influenced by how much downtime/shutdown time you can afford. HTH GovindanK -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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: dbshut script - shutdown or shutdown immediate
On Wed, 2 Apr 2003, Stephen Murphy wrote: We replace the simple shutdown command with: shutdown immediate startup restrict alter system switch logfile; host sleep 10 shutdown immediate Why do you do this elaborate dance? Are you trying to get the last logfile? If so, you should know that this combination of commands will not accomplish that. Any user with DBA priv can be in the database doing stuff and making transactions after your switch logfile and your shutdown immediate. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton 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: dbshut script - shutdown or shutdown immediate
On Wed, 2 Apr 2003, Chris Berry wrote: Shutdown abort is pretty drastic, are you sure shutdown immediate didn't work? What is drastic about shutdown abort? Never one to opt out of a shutdown abort thread, -- Jeremiah Wilton http://www.speakeasy.net/~jwilton - Uses shutdown abort exclusively - successful shutdowns/startups: over 10,000 - problems with shutdown abort: 0 - versions used: 7.3.2.3 - 10.0 (yes I have a pre-beta) - still employed! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton 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: dbshut script - shutdown or shutdown immediate
On Wed, 2 Apr 2003, GovindanK wrote: Shutdown immediate does rollback and will take time if no.of users is high. Number of users is not the largest contributing factor to shutdown immediate taking a long time. The longest poles in the tent are large transaction rollback and lazy temp segment deallocation. On the otherside, shutdown abort simply takes the db down and does not bother about anything else. As per manual, if you do a shutdown abort then you WILL need the online redo logs for recovery just in case. Do you know of anyone who does not have their online redologs? You pretty much need them or your database would have crashed a long time ago. Think twice if your db is in NOARCHIVELOG mode. If your db is in ARCHIVE mode make sure the logs are multiplexed. As has been pointed out, having multiplexed logs has nothing to do with archivelog mode. Furthermore there is no reason to be more careful about using abort if you are in noarchivelog mode. Crash recovery will not need any archived redologs, since it only needs those logs since the last checkpoint. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton 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: dbshut script - shutdown or shutdown immediate
Well... my official oracle instructor in dba larva school said that it's tantamount to crashing the db--or so I recall anyway. This isn't so? Peace, -Roy Roy Pardee Programmer/Analyst SWFPAC Lockheed Martin IT Extension 8487 -Original Message- Sent: Wednesday, April 02, 2003 2:09 PM To: Multiple recipients of list ORACLE-L On Wed, 2 Apr 2003, Chris Berry wrote: Shutdown abort is pretty drastic, are you sure shutdown immediate didn't work? What is drastic about shutdown abort? Never one to opt out of a shutdown abort thread, -- Jeremiah Wilton http://www.speakeasy.net/~jwilton - Uses shutdown abort exclusively - successful shutdowns/startups: over 10,000 - problems with shutdown abort: 0 - versions used: 7.3.2.3 - 10.0 (yes I have a pre-beta) - still employed! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton 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.net -- Author: Pardee, Roy E 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: dbshut script - shutdown or shutdown immediate
http://download-west.oracle.com/docs/cd/A81042_01/DOC/server.816/a76956/onlinere.htm#3981 would be nice reference. What i was trying to communicate was this: If the log is not multiplexed and the only log member is not avbl for writing then LGWR cannot write and the db instance will go down. However, if it is multiplexed then an error will be logged to the alert.log but the db will continue to function. I agree this has nothing to do with the arch/noarch mode but one has to have the log files multiplexed to get out of such scenarios. HTH GovindanK -- |XXX| |You should treat others the way you want to be treated - Mahatma Gandhi| |XXX| Daniel W. Fink [EMAIL PROTECTED] wrote: The scenario you describe would occur regardless of the archive mode. An active log cannot be archived. This would require that the ARCH process read the log while LGWR is writing it. Once a log switch occurs (automatic or manual), the previously active log can be archived. In this scenario, you cannot perform a complete recovery. You can recover up to the last log that can be read. If the active log cannot be read, the previous log is the end point of your recovery. -- Daniel W. Fink http://www.optimaldba.com IOUG-A Live! April 27 - May 1, 2003 Orlando, FL Sunday, April 27 8:30am - 4:30pm - Problem Solving with Oracle 9i SQL Thursday, May 1 1:00pm - 2:00pm - Automatic Undo Internals GovindanK wrote: This topic is getting interesting once more. Lets contribute. Multiplexing redo logs has nothing to do with the archive mode. Take a situation wherein the db is in NOARCH mode with only one member per group (default setup). The dba gives shutdown abort and upon starting for some reason the active log could not be read for recovery. How would one perform a complete recovery?. Let me know if you have a workaround. I am willing to learn. GovindanK __ Try AOL and get 1045 hours FREE for 45 days! http://free.aol.com/tryaolfree/index.adp?375380 Get AOL Instant Messenger 5.1 for FREE! Download Now! http://aim.aol.com/aimnew/Aim/register.adp?promo=380455 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: GovindanK 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: dbshut script - shutdown or shutdown immediate
Agreed. I admit my English needs some improvement. What i wanted to say was about rollback but used the words no.of.users. Thanks for pointing out. GovindanK Jeremiah Wilton [EMAIL PROTECTED] wrote: On Wed, 2 Apr 2003, GovindanK wrote: Shutdown immediate does rollback and will take time if no.of users is high. Number of users is not the largest contributing factor to shutdown immediate taking a long time. The longest poles in the tent are large transaction rollback and lazy temp segment deallocation. On the otherside, shutdown abort simply takes the db down and does not bother about anything else. As per manual, if you do a shutdown abort then you WILL need the online redo logs for recovery just in case. Do you know of anyone who does not have their online redologs? You pretty much need them or your database would have crashed a long time ago. Think twice if your db is in NOARCHIVELOG mode. If your db is in ARCHIVE mode make sure the logs are multiplexed. As has been pointed out, having multiplexed logs has nothing to do with archivelog mode. Furthermore there is no reason to be more careful about using abort if you are in noarchivelog mode. Crash recovery will not need any archived redologs, since it only needs those logs since the last checkpoint. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton __ Try AOL and get 1045 hours FREE for 45 days! http://free.aol.com/tryaolfree/index.adp?375380 Get AOL Instant Messenger 5.1 for FREE! Download Now! http://aim.aol.com/aimnew/Aim/register.adp?promo=380455 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: GovindanK 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: dbshut script - shutdown or shutdown immediate
From: Jeremiah Wilton [EMAIL PROTECTED] On Wed, 2 Apr 2003, Chris Berry wrote: Shutdown abort is pretty drastic, are you sure shutdown immediate didn't work? What is drastic about shutdown abort? Never one to opt out of a shutdown abort thread, -- Jeremiah Wilton http://www.speakeasy.net/~jwilton - Uses shutdown abort exclusively - successful shutdowns/startups: over 10,000 - problems with shutdown abort: 0 - versions used: 7.3.2.3 - 10.0 (yes I have a pre-beta) - still employed! Well, you have way more experience than me in this subject so do it how you like. I was under the impression that telling the database to drop everything was not the best practice, and should only be used when shutdown immediate didn't work. To me it seemed the same as turning off your computer with the power button instead of the shutdown command or using kill -9, sometimes you have to, but it's not what you do normally. Chris Berry [EMAIL PROTECTED] Systems Administrator JM Associates Without change, something sleeps inside us, and seldom awakens. The sleeper must awaken. -- Duke Leto Atreides _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chris Berry 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: dbshut script - shutdown or shutdown immediate
Suppose you have a database with a sid of mydb running on unix. Shutdown abort is like doing the following from the unix command line: ps -ef | grep mydb | grep -v grep | xargs kill -9. All the processes that make up the instance or processes that are connected to that instance are killed. The database will require instance recovery on the next start. Allan -Original Message- Sent: Wednesday, April 02, 2003 4:29 PM To: Multiple recipients of list ORACLE-L Well... my official oracle instructor in dba larva school said that it's tantamount to crashing the db--or so I recall anyway. This isn't so? Peace, -Roy Roy Pardee Programmer/Analyst SWFPAC Lockheed Martin IT Extension 8487 -Original Message- Sent: Wednesday, April 02, 2003 2:09 PM To: Multiple recipients of list ORACLE-L On Wed, 2 Apr 2003, Chris Berry wrote: Shutdown abort is pretty drastic, are you sure shutdown immediate didn't work? What is drastic about shutdown abort? Never one to opt out of a shutdown abort thread, -- Jeremiah Wilton http://www.speakeasy.net/~jwilton - Uses shutdown abort exclusively - successful shutdowns/startups: over 10,000 - problems with shutdown abort: 0 - versions used: 7.3.2.3 - 10.0 (yes I have a pre-beta) - still employed! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton 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.net -- Author: Pardee, Roy E 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). __ This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson, Allan 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: dbshut script - shutdown or shutdown immediate
- Uses shutdown abort exclusively - successful shutdowns/startups: over 10,000 - problems with shutdown abort: 0 - versions used: 7.3.2.3 - 10.0 (yes I have a pre-beta) - still employed! - Drives to work on busy streets exclusively - successful trips to work: over 14,000 - accidents during trips to work: 0 - still, I drive carefully [EMAIL PROTECTED] 04/02/03 04:28PM Well... my official oracle instructor in dba larva school said that it's tantamount to crashing the db--or so I recall anyway. This isn't so? Peace, -Roy Roy Pardee Programmer/Analyst SWFPAC Lockheed Martin IT Extension 8487 -Original Message- Sent: Wednesday, April 02, 2003 2:09 PM To: Multiple recipients of list ORACLE-L On Wed, 2 Apr 2003, Chris Berry wrote: Shutdown abort is pretty drastic, are you sure shutdown immediate didn't work? What is drastic about shutdown abort? Never one to opt out of a shutdown abort thread, -- Jeremiah Wilton http://www.speakeasy.net/~jwilton - Uses shutdown abort exclusively - successful shutdowns/startups: over 10,000 - problems with shutdown abort: 0 - versions used: 7.3.2.3 - 10.0 (yes I have a pre-beta) - still employed! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton 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.net -- Author: Pardee, Roy E 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.net -- Author: Darrell Landrum 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: dbshut script - shutdown or shutdown immediate
To me it seemed the same as turning off your computer with the power button instead of the shutdown command or using kill -9, sometimes you have to, but it's not what you do normally. Chris Berry Sounds practical. GovindanK -- |XXX| |You should treat others the way you want to be treated - Mahatma Gandhi| |XXX| __ Try AOL and get 1045 hours FREE for 45 days! http://free.aol.com/tryaolfree/index.adp?375380 Get AOL Instant Messenger 5.1 for FREE! Download Now! http://aim.aol.com/aimnew/Aim/register.adp?promo=380455 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: GovindanK 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: dbshut script - shutdown or shutdown immediate
Shutdown Immediate v. Shutdown abort (Tastes Great...Less Filling!) I'll admit to being in the Immediate camp. Why? I like the database to come down in a consistent state except in emergency circumstances. There have been bugs related to shutdown abort causing database problems. Do those in the Abort camp have valid reasons? Absolutely! Recovery is quicker and problems are extremely rare. I have a higher level of comfort in immediate. That is why I use it. Can I use abort/startup restrict/normal without incurring problems? Yes, except in rare cases. Almost certainly more rare than the times when the immediate takes longer than expected. I don't think this issue is one of black and white/right and wrong, but rather varying shades of gray. Okay, Connor...your turn! -- Daniel W. Fink http://www.optimaldba.com IOUG-A Live! April 27 - May 1, 2003 Orlando, FL Sunday, April 27 8:30am - 4:30pm - Problem Solving with Oracle 9i SQL Thursday, May 1 1:00pm - 2:00pm - Automatic Undo Internals -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel W. Fink 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: dbshut script - shutdown or shutdown immediate
On Wed, Apr 02, 2003 at 03:43:43PM -0800, Darrell Landrum wrote: - Drives to work on busy streets exclusively - successful trips to work: over 14,000 - accidents during trips to work: 0 - still, I drive carefully -- I've always taken Jeremiah's modivation on this to be functionality. You can wait for db tasks on shutdown immediate or you can wait for recovery later. It just depends on when you want to wait and the times are not always the same. Under some circumstances, immediate may cause a much very long wait and that can be unacceptable. If you need to bring it down, don't fear abort. There are times when abort is the tool you need, not some evil twin. Oracle, by design, has the db covered, less some early v7 releases. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ray Stell 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: dbshut script - shutdown or shutdown immediate
yeah so? are you suggesting that Oracle instance recovery can't handle a database crash? If so, better pray your server never crashes. --- Pardee, Roy E [EMAIL PROTECTED] wrote: Well... my official oracle instructor in dba larva school said that it's tantamount to crashing the db--or so I recall anyway. This isn't so? Peace, -Roy Roy Pardee Programmer/Analyst SWFPAC Lockheed Martin IT Extension 8487 -Original Message- Sent: Wednesday, April 02, 2003 2:09 PM To: Multiple recipients of list ORACLE-L On Wed, 2 Apr 2003, Chris Berry wrote: Shutdown abort is pretty drastic, are you sure shutdown immediate didn't work? What is drastic about shutdown abort? Never one to opt out of a shutdown abort thread, -- Jeremiah Wilton http://www.speakeasy.net/~jwilton - Uses shutdown abort exclusively - successful shutdowns/startups: over 10,000 - problems with shutdown abort: 0 - versions used: 7.3.2.3 - 10.0 (yes I have a pre-beta) - still employed! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton 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.net -- Author: Pardee, Roy E 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). __ Do you Yahoo!? Yahoo! Tax Center - File online, calculators, forms, and more http://tax.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael 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: dbshut script - shutdown or shutdown immediate
I don't think the issue is so much about whether Oracle recovery can handle a database crash or not. I think the issue is whether you want to spend the time of going through that process. I'm sure recovery can also handle the server being powered cycled but how many people do that without shutting down Oracle first? Since we had a car analogy already in this thread... I'm confident that the seat belts in my car work but I'm in no rush to test them out, and even if they do work I'm likely to end up bruised anyway. I guess the bruising my equate to overtime spent recovering the database... Oh, I hate trying to make really good analogies. Rachel Carmichael To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED] cc: ahoo.comSubject: RE: dbshut script - shutdown or shutdown immediate Sent by: [EMAIL PROTECTED] om 03/04/2003 12:33 Please respond to ORACLE-L yeah so? are you suggesting that Oracle instance recovery can't handle a database crash? If so, better pray your server never crashes. --- Pardee, Roy E [EMAIL PROTECTED] wrote: Well... my official oracle instructor in dba larva school said that it's tantamount to crashing the db--or so I recall anyway. This isn't so? Peace, -Roy Roy Pardee Programmer/Analyst SWFPAC Lockheed Martin IT Extension 8487 -Original Message- Sent: Wednesday, April 02, 2003 2:09 PM To: Multiple recipients of list ORACLE-L On Wed, 2 Apr 2003, Chris Berry wrote: Shutdown abort is pretty drastic, are you sure shutdown immediate didn't work? What is drastic about shutdown abort? Never one to opt out of a shutdown abort thread, -- Jeremiah Wilton http://www.speakeasy.net/~jwilton - Uses shutdown abort exclusively - successful shutdowns/startups: over 10,000 - problems with shutdown abort: 0 - versions used: 7.3.2.3 - 10.0 (yes I have a pre-beta) - still employed! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton 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.net -- Author: Pardee, Roy E 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). __ Do you Yahoo!? Yahoo! Tax Center - File online, calculators, forms, and more http
RE: dbshut script - shutdown or shutdown immediate
I think I would still prefer a shutdown abort over a kill -9. There might be even a slight level of control and error management in a shutdown abort but not in a kill -9 nothing and I repeat nothing can avoid a kill -9 and there is no cleanup by the process that is killed. Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Nelson, Allan [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 03/04/2003 09:14 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: dbshut script - shutdown or shutdown immediate Suppose you have a database with a sid of mydb running on unix. Shutdown abort is like doing the following from the unix command line: ps -ef | grep mydb | grep -v grep | xargs kill -9. All the processes that make up the instance or processes that are connected to that instance are killed. The database will require instance recovery on the next start. Allan -Original Message- Sent: Wednesday, April 02, 2003 4:29 PM To: Multiple recipients of list ORACLE-L Well... my official oracle instructor in dba larva school said that it's tantamount to crashing the db--or so I recall anyway. This isn't so? Peace, -Roy Roy Pardee Programmer/Analyst SWFPAC Lockheed Martin IT Extension 8487 -Original Message- Sent: Wednesday, April 02, 2003 2:09 PM To: Multiple recipients of list ORACLE-L On Wed, 2 Apr 2003, Chris Berry wrote: Shutdown abort is pretty drastic, are you sure shutdown immediate didn't work? What is drastic about shutdown abort? Never one to opt out of a shutdown abort thread, -- Jeremiah Wilton http://www.speakeasy.net/~jwilton - Uses shutdown abort exclusively - successful shutdowns/startups: over 10,000 - problems with shutdown abort: 0 - versions used: 7.3.2.3 - 10.0 (yes I have a pre-beta) - still employed! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton 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.net -- Author: Pardee, Roy E 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). __ This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson, Allan 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
RE: dbshut script - shutdown or shutdown immediate
Oracle crash??? What's that :)??? Isn't that a bug in SQL Server only ? -Mensaje original- De: Rachel Carmichael [mailto:[EMAIL PROTECTED] Enviado el: Miércoles, 02 de Abril de 2003 22:34 Para: Multiple recipients of list ORACLE-L Asunto: RE: dbshut script - shutdown or shutdown immediate yeah so? are you suggesting that Oracle instance recovery can't handle a database crash? If so, better pray your server never crashes. --- Pardee, Roy E [EMAIL PROTECTED] wrote: Well... my official oracle instructor in dba larva school said that it's tantamount to crashing the db--or so I recall anyway. This isn't so? Peace, -Roy Roy Pardee Programmer/Analyst SWFPAC Lockheed Martin IT Extension 8487 -Original Message- Sent: Wednesday, April 02, 2003 2:09 PM To: Multiple recipients of list ORACLE-L On Wed, 2 Apr 2003, Chris Berry wrote: Shutdown abort is pretty drastic, are you sure shutdown immediate didn't work? What is drastic about shutdown abort? Never one to opt out of a shutdown abort thread, -- Jeremiah Wilton http://www.speakeasy.net/~jwilton - Uses shutdown abort exclusively - successful shutdowns/startups: over 10,000 - problems with shutdown abort: 0 - versions used: 7.3.2.3 - 10.0 (yes I have a pre-beta) - still employed! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton 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.net -- Author: Pardee, Roy E 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). __ Do you Yahoo!? Yahoo! Tax Center - File online, calculators, forms, and more http://tax.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael 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.net -- Author: Nelson Flores 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).
