RE: STARTUP Force
Yeah, me too,, force the checkpoint,shutdown abort, startup,shutdown normal - (5 mins max) - you can then schedule legato or whatever backup. been working fine for 3 years on multiple instances. (famous last words) Sam -Original Message- Sent: Friday, February 09, 2001 2:51 AM To: Multiple recipients of list ORACLE-L Yeah right! I have six years of experience and I use shutdown abort all the time. Just force a checkpoint first to speed up hot recovery on the startup. The other forms of shutdown take too long, and may never complete if you have long running transactions that don't do frequent commits. Check out the following paper if you think I am wrong... http://www.wolfenet.com/~jeremiah/241.pdf Startup force, on the other hand, I would never use this unless I had a high level oracle support engineer holding my hand. > -Original Message- > From: Mark Leith [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, February 07, 2001 8:01 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: STARTUP Force > > One thing I would say Neena - ONLY use SHUTDOWN ABORT as an absolute LAST > resort!! > > If you are shuting down the database normally, on 8, first do a SHUTDOWN > TRANSACTIONAL, if you need to close the database quickly, try a SHUTDOWN > IMMEDIATE, wait for 5 or so minutes, and if all else fails ONLY THEN issue > a > SHUTDOWN ABORT!! > > SHUTDOWN ABORT can cause corruption, and recovering is a bit of a pain the > arse (as a list memeber found out recently).. You don't seem to have a lot > of experience with Oracle, as Joe mentioned. Now I have around 3 years > experience and STILL have NO experience with Backup and Recovery (fair > enough it is not an issue for me). > > Grab hold of the Oracle docs from http://www.otn.oracle.com/ and start > reading away. > > Regards > > Mark > > -Original Message- > Testa > Sent: Wednesday, February 07, 2001 12:30 > To: Multiple recipients of list ORACLE-L > > > Neena, after looking at your last 3 messages, you need to sit down and > read the administrators guide, 90% of your questions are answered in > that book and nowadays there is no excuse for not reading docs(unlike > back in version 6 days when people used to hoard the books). > > joe > TIL-TEC wrote: > > > > When do a DBA prefers to use STARTUP FORCE than SHUTDOWN > > ABORT+STARTUP NORMAL ? > > > > --Neena > > -- > Joe Testa http://www.oracle-dba.com > Performing Remote DBA Services, need some backup DBA support? > For Sale: Oracle-dba.com domain, its not going cheap but feel free to > ask :) > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Joseph S. Testa > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Mark Leith > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Elliott, Patrick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sam P. Roberts
RE: STARTUP Force
Reading again, forget what I said.. lol.. It was too early.. -Original Message- Sent: Friday, February 09, 2001 09:16 To: Multiple recipients of list ORACLE-L So, if you are recovering you would use it? I feel my reply was quite a reasonable one then, if you are shuting down normally, don't use it.. I only told her to use it as a last resort, and a recovery situation is pretty much a last resort.. In my book anyway.. And I did actually only learn about forcing the checkpoint before a shutdown abort a couple of days ago believe it or not! Thanks for the tip though.. I learn every single day :^) -Original Message- Patrick Sent: Thursday, February 08, 2001 10:51 To: Multiple recipients of list ORACLE-L Yeah right! I have six years of experience and I use shutdown abort all the time. Just force a checkpoint first to speed up hot recovery on the startup. The other forms of shutdown take too long, and may never complete if you have long running transactions that don't do frequent commits. Check out the following paper if you think I am wrong... http://www.wolfenet.com/~jeremiah/241.pdf Startup force, on the other hand, I would never use this unless I had a high level oracle support engineer holding my hand. > -Original Message- > From: Mark Leith [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, February 07, 2001 8:01 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: STARTUP Force > > One thing I would say Neena - ONLY use SHUTDOWN ABORT as an absolute LAST > resort!! > > If you are shuting down the database normally, on 8, first do a SHUTDOWN > TRANSACTIONAL, if you need to close the database quickly, try a SHUTDOWN > IMMEDIATE, wait for 5 or so minutes, and if all else fails ONLY THEN issue > a > SHUTDOWN ABORT!! > > SHUTDOWN ABORT can cause corruption, and recovering is a bit of a pain the > arse (as a list memeber found out recently).. You don't seem to have a lot > of experience with Oracle, as Joe mentioned. Now I have around 3 years > experience and STILL have NO experience with Backup and Recovery (fair > enough it is not an issue for me). > > Grab hold of the Oracle docs from http://www.otn.oracle.com/ and start > reading away. > > Regards > > Mark > > -Original Message- > Testa > Sent: Wednesday, February 07, 2001 12:30 > To: Multiple recipients of list ORACLE-L > > > Neena, after looking at your last 3 messages, you need to sit down and > read the administrators guide, 90% of your questions are answered in > that book and nowadays there is no excuse for not reading docs(unlike > back in version 6 days when people used to hoard the books). > > joe > TIL-TEC wrote: > > > > When do a DBA prefers to use STARTUP FORCE than SHUTDOWN > > ABORT+STARTUP NORMAL ? > > > > --Neena > > -- > Joe Testa http://www.oracle-dba.com > Performing Remote DBA Services, need some backup DBA support? > For Sale: Oracle-dba.com domain, its not going cheap but feel free to > ask :) > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Joseph S. Testa > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Mark Leith > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Elliott, Patrick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mai
RE: STARTUP Force
So, if you are recovering you would use it? I feel my reply was quite a reasonable one then, if you are shuting down normally, don't use it.. I only told her to use it as a last resort, and a recovery situation is pretty much a last resort.. In my book anyway.. And I did actually only learn about forcing the checkpoint before a shutdown abort a couple of days ago believe it or not! Thanks for the tip though.. I learn every single day :^) -Original Message- Patrick Sent: Thursday, February 08, 2001 10:51 To: Multiple recipients of list ORACLE-L Yeah right! I have six years of experience and I use shutdown abort all the time. Just force a checkpoint first to speed up hot recovery on the startup. The other forms of shutdown take too long, and may never complete if you have long running transactions that don't do frequent commits. Check out the following paper if you think I am wrong... http://www.wolfenet.com/~jeremiah/241.pdf Startup force, on the other hand, I would never use this unless I had a high level oracle support engineer holding my hand. > -Original Message- > From: Mark Leith [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, February 07, 2001 8:01 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: STARTUP Force > > One thing I would say Neena - ONLY use SHUTDOWN ABORT as an absolute LAST > resort!! > > If you are shuting down the database normally, on 8, first do a SHUTDOWN > TRANSACTIONAL, if you need to close the database quickly, try a SHUTDOWN > IMMEDIATE, wait for 5 or so minutes, and if all else fails ONLY THEN issue > a > SHUTDOWN ABORT!! > > SHUTDOWN ABORT can cause corruption, and recovering is a bit of a pain the > arse (as a list memeber found out recently).. You don't seem to have a lot > of experience with Oracle, as Joe mentioned. Now I have around 3 years > experience and STILL have NO experience with Backup and Recovery (fair > enough it is not an issue for me). > > Grab hold of the Oracle docs from http://www.otn.oracle.com/ and start > reading away. > > Regards > > Mark > > -Original Message- > Testa > Sent: Wednesday, February 07, 2001 12:30 > To: Multiple recipients of list ORACLE-L > > > Neena, after looking at your last 3 messages, you need to sit down and > read the administrators guide, 90% of your questions are answered in > that book and nowadays there is no excuse for not reading docs(unlike > back in version 6 days when people used to hoard the books). > > joe > TIL-TEC wrote: > > > > When do a DBA prefers to use STARTUP FORCE than SHUTDOWN > > ABORT+STARTUP NORMAL ? > > > > --Neena > > -- > Joe Testa http://www.oracle-dba.com > Performing Remote DBA Services, need some backup DBA support? > For Sale: Oracle-dba.com domain, its not going cheap but feel free to > ask :) > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Joseph S. Testa > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Mark Leith > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Elliott, Patrick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the nam
RE: STARTUP Force
Yeah right! I have six years of experience and I use shutdown abort all the time. Just force a checkpoint first to speed up hot recovery on the startup. The other forms of shutdown take too long, and may never complete if you have long running transactions that don't do frequent commits. Check out the following paper if you think I am wrong... http://www.wolfenet.com/~jeremiah/241.pdf Startup force, on the other hand, I would never use this unless I had a high level oracle support engineer holding my hand. > -Original Message- > From: Mark Leith [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, February 07, 2001 8:01 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: STARTUP Force > > One thing I would say Neena - ONLY use SHUTDOWN ABORT as an absolute LAST > resort!! > > If you are shuting down the database normally, on 8, first do a SHUTDOWN > TRANSACTIONAL, if you need to close the database quickly, try a SHUTDOWN > IMMEDIATE, wait for 5 or so minutes, and if all else fails ONLY THEN issue > a > SHUTDOWN ABORT!! > > SHUTDOWN ABORT can cause corruption, and recovering is a bit of a pain the > arse (as a list memeber found out recently).. You don't seem to have a lot > of experience with Oracle, as Joe mentioned. Now I have around 3 years > experience and STILL have NO experience with Backup and Recovery (fair > enough it is not an issue for me). > > Grab hold of the Oracle docs from http://www.otn.oracle.com/ and start > reading away. > > Regards > > Mark > > -Original Message- > Testa > Sent: Wednesday, February 07, 2001 12:30 > To: Multiple recipients of list ORACLE-L > > > Neena, after looking at your last 3 messages, you need to sit down and > read the administrators guide, 90% of your questions are answered in > that book and nowadays there is no excuse for not reading docs(unlike > back in version 6 days when people used to hoard the books). > > joe > TIL-TEC wrote: > > > > When do a DBA prefers to use STARTUP FORCE than SHUTDOWN > > ABORT+STARTUP NORMAL ? > > > > --Neena > > -- > Joe Testa http://www.oracle-dba.com > Performing Remote DBA Services, need some backup DBA support? > For Sale: Oracle-dba.com domain, its not going cheap but feel free to > ask :) > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Joseph S. Testa > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Mark Leith > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Elliott, Patrick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: STARTUP Force
One thing I would say Neena - ONLY use SHUTDOWN ABORT as an absolute LAST resort!! If you are shuting down the database normally, on 8, first do a SHUTDOWN TRANSACTIONAL, if you need to close the database quickly, try a SHUTDOWN IMMEDIATE, wait for 5 or so minutes, and if all else fails ONLY THEN issue a SHUTDOWN ABORT!! SHUTDOWN ABORT can cause corruption, and recovering is a bit of a pain the arse (as a list memeber found out recently).. You don't seem to have a lot of experience with Oracle, as Joe mentioned. Now I have around 3 years experience and STILL have NO experience with Backup and Recovery (fair enough it is not an issue for me). Grab hold of the Oracle docs from http://www.otn.oracle.com/ and start reading away. Regards Mark -Original Message- Testa Sent: Wednesday, February 07, 2001 12:30 To: Multiple recipients of list ORACLE-L Neena, after looking at your last 3 messages, you need to sit down and read the administrators guide, 90% of your questions are answered in that book and nowadays there is no excuse for not reading docs(unlike back in version 6 days when people used to hoard the books). joe TIL-TEC wrote: > > When do a DBA prefers to use STARTUP FORCE than SHUTDOWN > ABORT+STARTUP NORMAL ? > > --Neena -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: STARTUP Force
Neena, after looking at your last 3 messages, you need to sit down and read the administrators guide, 90% of your questions are answered in that book and nowadays there is no excuse for not reading docs(unlike back in version 6 days when people used to hoard the books). joe TIL-TEC wrote: > > When do a DBA prefers to use STARTUP FORCE than SHUTDOWN > ABORT+STARTUP NORMAL ? > > --Neena -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).