| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: shutdown hang
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01BFC74C.64A82F70
Content-Type: text/plain;
charset="iso-8859-1"
Could you please provide more info about this class? Who is offering it, how long, how much, schedule, agenda etc.
Alex Hillman
-----Original Message-----
From: Madhavan Amruthur [mailto:mad012000_at_hotmail.com]
Sent: Thursday, May 25, 2000 12:15 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: shutdown hang
Hi Rachel,
I went to the internal classes taught by Scott in Feb and he is just great.
He keeps the interest (after lunch) from dwindling and at the end of the 4
seminars, I became more dangerous than ever with all the information he
provided.
Regards,
Madhavan
IBM Corporation Webserver Div
>From: "Rachel Carmichael" <carmichr_at_hotmail.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: shutdown hang
>Date: Wed, 24 May 2000 17:54:50 -0800
>
>
>
>According to the internals class I am taking (and the instructor, Scott
>Gossett, is one of the best), rollback takes about as long as it took from
>the start of the transaction to when you started the rollback.
>
>The reason is:
>
>to make the original changes to the blocks, Oracle builds change vectors
>which get applied to the blocks (rollback segment header block, undo block
>and data block). When you rollback, you build similar change vectors to
>change things back...... Why you ask? Well, Oracle is building entries in
>the rollback segment to be able to rollback the rollback if a problem
>happens in the middle. Yes, I know that sounds strange, but when have we
>ever understood what Oracle is doing and why? <G>
>
>So you are doing as much work to rollback as you did to get to that point.
>
>This class rocks. And is making my head hurt... there is SO much to learn!
>
>Rachel
>
>
>>From: Ari D Kaplan <akaplan_at_interaccess.com>
>>Reply-To: ORACLE-L_at_fatcity.com
>>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>>Subject: RE: shutdown hang
>>Date: Wed, 24 May 2000 13:46:26 -0800
>>
>>It depends on how large the 120,000 rows are. If there is a LONG column or
>>200 columns, etc. it could take an hour or so. If it is a "typical" table,
>>say 15 columns, then 120,000 rows should take about a minute.
>>
>>With other tables, as Winnie has said, can take hours or more.
>>
>>-Ari Kaplan
>>Independent Oracle DBA Consultant
>>
>><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
>><-> For 370+ Oracle tips, visit: <->
>><-> <->
>><-> www.arikaplan.com <->
>><-> <->
>><-> email: akaplan_at_interaccess.com <->
>><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
>>
>>
>>On Wed, 24 May 2000 Winnie_Liu_at_infonet.com wrote:
>>
>> >
>> > Teresa,
>> >
>> > I don't think I can answer your question staight. I have seen tables
>>that
>> > had been locked for minutes, hours to about 1 day.
>> >
>> > Any other DBA have similar experience that can shared with Teresa?
>> >
>> > Winnie
>> >
>> >
>> >
>> >
>> >
>> > "Southerland, Teresa" <tsouther_at_indiana.edu> on 05/24/2000 01:15:30 PM
>> >
>> > Please respond to ORACLE-L_at_fatcity.com
>> >
>> > To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>> > cc: (bcc: Winnie Liu/HQ/ISC)
>> >
>> >
>> >
>> >
>> >
>> > Winnie,
>> >
>> > I have an off the wall question. If there was a transaction running
>>that
>> > executed 120,000 rows and had to rollback without shut down to the
>> > database,
>> > what kind of time frame would this take?
>> >
>> > Thanks,
>> >
>> > Teresa
>> >
>> > -----Original Message-----
>> > Sent: Friday, May 19, 2000 1:16 PM
>> > To: Multiple recipients of list ORACLE-L
>> >
>> >
>> >
>> > Joan,
>> >
>> > The reaon is that in your first startup, Oracle does NOT clean up
>> > everything yet. It opened the database for you to use, but still
>>cleaning
>> > up the processes inthe background. Those clean up may take any time
>>from
>> > minutes to days (from some Oracle guru in Oracle corporation).
>> >
>> > If you are looking at the alert.log file after those startup, you
>>should
>> > see something like
>> >
>> > SMON: enabling cache recovery
>> > SMON: enabling tx recovery
>> >
>> > The database is up and running fine, but SMON is doing the recovery at
>>the
>> > background.
>> >
>> > Until you see the words:
>> >
>> > SMON: disabling cache recovery
>> > SMON: disabling tx recovery
>> >
>> > The recovery done by SMON is not done yet. This process may take hours
>>and
>> > days if you are temporary segments is huge and there are a lot of clean
>>up
>> > need to be done by SMON.
>> >
>> > When you do a shutdown immediate, since you are asking Oracle to
>>shutdown
>> > the database cleanly. SMON had to finish that job before shutting down
>>the
>> > database. Those hours/days will then add to your shutdown time.
>> >
>> > So the best method for me (which I also get from Oracle) is to do a
>> > shutdown abort and then a startup and wait for the SMON recovery to be
>> > finished in the background.
>> >
>> > There are a few events that you can set to free up SMON from performing
>> > those daily activities and concentrate on the recovery. If you are
>> > interested, I will send them to you.
>> >
>> > Hope it makes more sense now.
>> >
>> > Winnie
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> > Joan Hsieh <jhsieh_at_infonet.tufts.edu> on 05/19/2000 07:28:05 AM
>> >
>> > Please respond to ORACLE-L_at_fatcity.com
>> >
>> > To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>> > cc: (bcc: Winnie Liu/HQ/ISC)
>> >
>> >
>> >
>> >
>> >
>> > Winnie,
>> >
>> > I did shutdown abort and startup (took 20 min.) What concerns me is
>> > after startup, I did shutdown immediate again. It hangs (more than one
>> > hour and didn't comeback) NOBODY on the system. My question is the
>>first
>> > startup should clean up everything, why shutdown immediate hangs after?
>> >
>> > Thanks,
>> >
>> > Joan
>> >
>> > ORACLE-L_at_fatcity.com wrote:
>> > >
>> > > It is perfectly normal. But if I were you, I will shutdown abort and
>> > > startup again (oracle is actually cleaning up the processes in the
>> > > background, they are doing the same job as if you issue the shutdown
>> > > immediate). At least the database is up and running while Oracle did
>>the
>> > > cleaning.
>> > >
>> > > My worst nightmare is to wait for 14 hours for it to get cleaned up.
>> > >
>> > > Winnie
>> > >
>> > > Joan Hsieh <jhsieh_at_infonet.tufts.edu> on 05/18/2000 02:19:39 PM
>> > >
>> > > Please respond to ORACLE-L_at_fatcity.com
>> > >
>> > > To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>> > > cc: (bcc: Winnie Liu/HQ/ISC)
>> > >
>> > > Hi List,
>> > >
>> > > One of the developers deleted more than 120,000 rows on a small
>> > > database. In the middle of the session, he killed the
>>process.(because
>> > > hang) I did shutdown abort and startup again (waited a while whitout
>> > > problem) and want to shutdown immediate and startup over again. This
>> > > time shutdown immediate hangs. Is this normal (waiting rollback)?
>>I've
>> > > been hang here for over one hours now.
>> > >
>> > > Thanks in advance,
>> > >
>> > > Joan
>> > > --
>> > > Author: Joan Hsieh
>> > > INET: jhsieh_at_infonet.tufts.edu
>> > >
>> > > 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: ListGuru_at_fatcity.com (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).
>> > >
>> > > --
>> > > Author:
>> > > INET: Winnie_Liu_at_infonet.com
>> > >
>> > > 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: ListGuru_at_fatcity.com (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).
>> > --
>> > Author: Joan Hsieh
>> > INET: jhsieh_at_infonet.tufts.edu
>> >
>> > 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: ListGuru_at_fatcity.com (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).
>> >
>> >
>> >
>> >
>> >
>> >
>> > --
>> > Author:
>> > INET: Winnie_Liu_at_infonet.com
>> >
>> > 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: ListGuru_at_fatcity.com (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).
>> > --
>> > Author: Southerland, Teresa
>> > INET: tsouther_at_indiana.edu
>> >
>> > 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: ListGuru_at_fatcity.com (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).
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> > --
>> > Author:
>> > INET: Winnie_Liu_at_infonet.com
>> >
>> > 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: ListGuru_at_fatcity.com (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).
>> >
>>
>>--
>>Author: Ari D Kaplan
>> INET: akaplan_at_interaccess.com
>>
>>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: ListGuru_at_fatcity.com (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).
>
>________________________________________________________________________
>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>
>--
>Author: Rachel Carmichael
> INET: carmichr_at_hotmail.com
>
>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: ListGuru_at_fatcity.com (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).
-- Author: Madhavan Amruthur INET: mad012000_at_hotmail.com 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: ListGuru_at_fatcity.com (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). ------_=_NextPart_001_01BFC74C.64A82F70 Content-Type: text/html; charset="iso-8859-1" <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> <META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2448.0"> <TITLE>RE: shutdown hang</TITLE> </HEAD> <BODY> <P><FONT SIZE=2>Could you please provide more info about this class? Who is offering it, how long, how much, schedule, agenda etc.</FONT> </P> <P><FONT SIZE=2>Alex Hillman</FONT> </P> <P><FONT SIZE=2>-----Original Message-----</FONT> <BR><FONT SIZE=2>From: Madhavan Amruthur [<A HREF="mailto:mad012000_at_hotmail.com">mailto:mad012000_at_hotmail.com</A>]</FONT> <BR><FONT SIZE=2>Sent: Thursday, May 25, 2000 12:15 PM</FONT> <BR><FONT SIZE=2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=2>Subject: RE: shutdown hang</FONT> </P> <BR> <P><FONT SIZE=2>Hi Rachel,</FONT> <BR><FONT SIZE=2>I went to the internal classes taught by Scott in Feb and he is just great. </FONT> <BR><FONT SIZE=2>He keeps the interest (after lunch) from dwindling and at the end of the 4 </FONT> <BR><FONT SIZE=2>seminars, I became more dangerous than ever with all the information he </FONT> <BR><FONT SIZE=2>provided.</FONT> </P> <P><FONT SIZE=2>Regards,</FONT> <BR><FONT SIZE=2>Madhavan</FONT> <BR><FONT SIZE=2>IBM Corporation Webserver Div</FONT> </P> <BR> <P><FONT SIZE=2>>From: "Rachel Carmichael" <carmichr_at_hotmail.com></FONT> <BR><FONT SIZE=2>>Reply-To: ORACLE-L_at_fatcity.com</FONT> <BR><FONT SIZE=2>>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com></FONT> <BR><FONT SIZE=2>>Subject: RE: shutdown hang</FONT> <BR><FONT SIZE=2>>Date: Wed, 24 May 2000 17:54:50 -0800</FONT> <BR><FONT SIZE=2>></FONT> <BR><FONT SIZE=2>></FONT> <BR><FONT SIZE=2>></FONT> <BR><FONT SIZE=2>>According to the internals class I am taking (and the instructor, Scott</FONT> <BR><FONT SIZE=2>>Gossett, is one of the best), rollback takes about as long as it took from</FONT> <BR><FONT SIZE=2>>the start of the transaction to when you started the rollback.</FONT> <BR><FONT SIZE=2>></FONT> <BR><FONT SIZE=2>>The reason is:</FONT> <BR><FONT SIZE=2>></FONT> <BR><FONT SIZE=2>>to make the original changes to the blocks, Oracle builds change vectors</FONT> <BR><FONT SIZE=2>>which get applied to the blocks (rollback segment header block, undo block</FONT> <BR><FONT SIZE=2>>and data block). When you rollback, you build similar change vectors to</FONT> <BR><FONT SIZE=2>>change things back...... Why you ask? Well, Oracle is building entries in</FONT> <BR><FONT SIZE=2>>the rollback segment to be able to rollback the rollback if a problem</FONT> <BR><FONT SIZE=2>>happens in the middle. Yes, I know that sounds strange, but when have we</FONT> <BR><FONT SIZE=2>>ever understood what Oracle is doing and why? <G></FONT> <BR><FONT SIZE=2>></FONT> <BR><FONT SIZE=2>>So you are doing as much work to rollback as you did to get to that point.</FONT> <BR><FONT SIZE=2>></FONT> <BR><FONT SIZE=2>>This class rocks. And is making my head hurt... there is SO much to learn!</FONT> <BR><FONT SIZE=2>></FONT> <BR><FONT SIZE=2>>Rachel</FONT> <BR><FONT SIZE=2>></FONT> <BR><FONT SIZE=2>></FONT> <BR><FONT SIZE=2>>>From: Ari D Kaplan <akaplan_at_interaccess.com></FONT> <BR><FONT SIZE=2>>>Reply-To: ORACLE-L_at_fatcity.com</FONT> <BR><FONT SIZE=2>>>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com></FONT> <BR><FONT SIZE=2>>>Subject: RE: shutdown hang</FONT> <BR><FONT SIZE=2>>>Date: Wed, 24 May 2000 13:46:26 -0800</FONT> <BR><FONT SIZE=2>>></FONT> <BR><FONT SIZE=2>>>It depends on how large the 120,000 rows are. If there is a LONG column or</FONT> <BR><FONT SIZE=2>>>200 columns, etc. it could take an hour or so. If it is a "typical" table,</FONT> <BR><FONT SIZE=2>>>say 15 columns, then 120,000 rows should take about a minute.</FONT> <BR><FONT SIZE=2>>></FONT> <BR><FONT SIZE=2>>>With other tables, as Winnie has said, can take hours or more.</FONT> <BR><FONT SIZE=2>>></FONT> <BR><FONT SIZE=2>>>-Ari Kaplan</FONT> <BR><FONT SIZE=2>>>Independent Oracle DBA Consultant</FONT> <BR><FONT SIZE=2>>></FONT> <BR><FONT SIZE=2>>><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-></FONT> <BR><FONT SIZE=2>>><-> For 370+ Oracle tips, visit: <-></FONT> <BR><FONT SIZE=2>>><-> <-></FONT> <BR><FONT SIZE=2>>><-> www.arikaplan.com <-></FONT> <BR><FONT SIZE=2>>><-> <-></FONT> <BR><FONT SIZE=2>>><-> email: akaplan_at_interaccess.com <-></FONT> <BR><FONT SIZE=2>>><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-></FONT> <BR><FONT SIZE=2>>></FONT> <BR><FONT SIZE=2>>></FONT> <BR><FONT SIZE=2>>>On Wed, 24 May 2000 Winnie_Liu_at_infonet.com wrote:</FONT> <BR><FONT SIZE=2>>></FONT> <BR><FONT SIZE=2>>> ></FONT> <BR><FONT SIZE=2>>> > Teresa,</FONT> <BR><FONT SIZE=2>>> ></FONT> <BR><FONT SIZE=2>>> > I don't think I can answer your question staight. I have seen tables</FONT> <BR><FONT SIZE=2>>>that</FONT> <BR><FONT SIZE=2>>> > had been locked for minutes, hours to about 1 day.</FONT> <BR><FONT SIZE=2>>> ></FONT> <BR><FONT SIZE=2>>> > Any other DBA have similar experience that can shared with Teresa?</FONT> <BR><FONT SIZE=2>>> ></FONT> <BR><FONT SIZE=2>>> > Winnie</FONT> <BR><FONT SIZE=2>>> ></FONT> <BR><FONT SIZE=2>>> ></FONT> <BR><FONT SIZE=2>>> ></FONT> <BR><FONT SIZE=2>>> ></FONT> <BR><FONT SIZE=2>>> ></FONT> <BR><FONT SIZE=2>>> > "Southerland, Teresa" <tsouther_at_indiana.edu> on 05/24/2000 01:15:30 PM</FONT> <BR><FONT SIZE=2>>> ></FONT> <BR><FONT SIZE=2>>> > Please respond to ORACLE-L_at_fatcity.com</FONT> <BR><FONT SIZE=2>>> ></FONT> <BR><FONT SIZE=2>>> > To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com></FONT> <BR><FONT SIZE=2>>> > cc: (bcc: Winnie Liu/HQ/ISC)</FONT> <BR><FONT SIZE=2>>> ></FONT> <BR><FONT SIZE=2>>> ></FONT> <BR><FONT SIZE=2>>> ></FONT> <BR><FONT SIZE=2>>> ></FONT> <BR><FONT SIZE=2>>> ></FONT> <BR><FONT SIZE=2>>> > Winnie,</FONT> <BR><FONT SIZE=2>>> ></FONT> <BR><FONT SIZE=2>>> > I have an off the wall question. If there was a transaction running</FONT> <BR><FONT SIZE=2>>>that</FONT> <BR><FONT SIZE=2>>> > executed 120,000 rows and had to rollback without shut down to the</FONT> <BR><FONT SIZE=2>>> > database,</FONT> <BR><FONT SIZE=2>>> > what kind of time frame would this take?</FONT> <BR><FONT SIZE=2>>> ></FONT> <BR><FONT SIZE=2>>> > Thanks,</FONT> <BR><FONT SIZE=2>>> ></FONT> <BR><FONT SIZE=2>>> > Teresa</FONT> <BR><FONT SIZE=2>>> ></FONT> <BR><FONT SIZE=2>>> > -----Original Message-----</FONT> <BR><FONT SIZE=2>>> > Sent: Friday, May 19, 2000 1:16 PM</FONT> <BR><FONT SIZE=2>>> > To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=2>>> ></FONT> <BR><FONT SIZE=2>>> ></FONT> <BR><FONT SIZE=2>>> ></FONT> <BR><FONT SIZE=2>>> > Joan,</FONT> <BR><FONT SIZE=2>>> ></FONT> <BR><FONT SIZE=2>>> > The reaon is that in your first startup, Oracle does NOT clean up</FONT> <BR><FONT SIZE=2>>> > everything yet. It opened the database for you to use, but still</FONT> <BR><FONT SIZE=2>>>cleaning</FONT> <BR><FONT SIZE=2>>> > up the processes inthe background. Those clean up may take any time </FONT> <BR><FONT SIZE=2>>>from</FONT> <BR><FONT SIZE=2>>> > minutes to days (from some Oracle guru in Oracle corporation).</FONT> <BR><FONT SIZE=2>>> ></FONT> <BR><FONT SIZE=2>>> > If you are looking at the alert.log file after those startup, you </FONT> <BR><FONT SIZE=2>>>should</FONT> <BR><FONT SIZE=2>>> > see something like</FONT> <BR><FONT SIZE=2>>> ></FONT> <BR><FONT SIZE=2>>> > SMON: enabling cache recovery</FONT> <BR><FONT SIZE=2>>> > SMON: enabling tx recovery</FONT> <BR><FONT SIZE=2>>> ></FONT> <BR><FONT SIZE=2>>> > The database is up and running fine, but SMON is doing the recovery at</FONT> <BR><FONT SIZE=2>>>the</FONT> <BR><FONT SIZE=2>>> > background.</FONT> <BR><FONT SIZE=2>>> ></FONT> <BR><FONT SIZE=2>>> > Until you see the words:</FONT> <BR><FONT SIZE=2>>> ></FONT> <BR><FONT SIZE=2>>> > SMON: disabling cache recovery</FONT> <BR><FONT SIZE=2>>> > SMON: disabling tx recovery</FONT> <BR><FONT SIZE=2>>> ></FONT> <BR><FONT SIZE=2>>> > The recovery done by SMON is not done yet. This process may take hours</FONT> <BR><FONT SIZE=2>>>and</FONT> <BR><FONT SIZE=2>>> > days if you are temporary segments is huge and there are a lot of clean</FONT> <BR><FONT SIZE=2>>>up</FONT> <BR><FONT SIZE=2>>> > need to be done by SMON.</FONT> <BR><FONT SIZE=2>>> ></FONT> <BR><FONT SIZE=2>>> > When you do a shutdown immediate, since you are asking Oracle to</FONT> <BR><FONT SIZE=2>>>shutdown</FONT> <BR><FONT SIZE=2>>> > the database cleanly. SMON had to finish that job before shutting down</FONT> <BR><FONT SIZE=2>>>the</FONT> <BR><FONT SIZE=2>>> > database. Those hours/days will then add to your shutdown time.</FONT> <BR><FONT SIZE=2>>> ></FONT> <BR><FONT SIZE=2>>> > So the best method for me (which I also get from Oracle) is to do a</FONT> <BR><FONT SIZE=2>>> > shutdown abort and then a startup and wait for the SMON recovery to be</FONT> <BR><FONT SIZE=2>>> > finished in the background.</FONT> <BR><FONT SIZE=2>>> ></FONT> <BR><FONT SIZE=2>>> > There are a few events that you can set to free up SMON from performing</FONT> <BR><FONT SIZE=2>>> > those daily activities and concentrate on the recovery. If you are</FONT> <BR><FONT SIZE=2>>> > interested, I will send them to you.</FONT> <BR><FONT SIZE=2>>> ></FONT> <BR><FONT SIZE=2>>> > Hope it makes more sense now.</FONT> <BR><FONT SIZE=2>>> ></FONT> <BR><FONT SIZE=2>>> > Winnie</FONT> <BR><FONT SIZE=2>>> ></FONT> <BR><FONT SIZE=2>>> ></FONT> <BR><FONT SIZE=2>>> ></FONT> <BR><FONT SIZE=2>>> ></FONT> <BR><FONT SIZE=2>>> ></FONT> <BR><FONT SIZE=2>>> ></FONT> <BR><FONT SIZE=2>>> ></FONT> <BR><FONT SIZE=2>>> ></FONT> <BR><FONT SIZE=2>>> ></FONT> <BR><FONT SIZE=2>>> > Joan Hsieh <jhsieh_at_infonet.tufts.edu> on 05/19/2000 07:28:05 AM</FONT> <BR><FONT SIZE=2>>> ></FONT> <BR><FONT SIZE=2>>> > Please respond to ORACLE-L_at_fatcity.com</FONT> <BR><FONT SIZE=2>>> ></FONT> <BR><FONT SIZE=2>>> > To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com></FONT> <BR><FONT SIZE=2>>> > cc: (bcc: Winnie Liu/HQ/ISC)</FONT> <BR><FONT SIZE=2>>> ></FONT> <BR><FONT SIZE=2>>> ></FONT> <BR><FONT SIZE=2>>> ></FONT> <BR><FONT SIZE=2>>> ></FONT> <BR><FONT SIZE=2>>> ></FONT> <BR><FONT SIZE=2>>> > Winnie,</FONT> <BR><FONT SIZE=2>>> ></FONT> <BR><FONT SIZE=2>>> > I did shutdown abort and startup (took 20 min.) What concerns me is</FONT> <BR><FONT SIZE=2>>> > after startup, I did shutdown immediate again. It hangs (more than one</FONT> <BR><FONT SIZE=2>>> > hour and didn't comeback) NOBODY on the system. My question is the </FONT> <BR><FONT SIZE=2>>>first</FONT> <BR><FONT SIZE=2>>> > startup should clean up everything, why shutdown immediate hangs after?</FONT> <BR><FONT SIZE=2>>> ></FONT> <BR><FONT SIZE=2>>> > Thanks,</FONT> <BR><FONT SIZE=2>>> ></FONT> <BR><FONT SIZE=2>>> > Joan</FONT> <BR><FONT SIZE=2>>> ></FONT> <BR><FONT SIZE=2>>> > ORACLE-L_at_fatcity.com wrote:</FONT> <BR><FONT SIZE=2>>> > ></FONT> <BR><FONT SIZE=2>>> > > It is perfectly normal. But if I were you, I will shutdown abort and</FONT> <BR><FONT SIZE=2>>> > > startup again (oracle is actually cleaning up the processes in the</FONT> <BR><FONT SIZE=2>>> > > background, they are doing the same job as if you issue the shutdown</FONT> <BR><FONT SIZE=2>>> > > immediate). At least the database is up and running while Oracle did</FONT> <BR><FONT SIZE=2>>>the</FONT> <BR><FONT SIZE=2>>> > > cleaning.</FONT> <BR><FONT SIZE=2>>> > ></FONT> <BR><FONT SIZE=2>>> > > My worst nightmare is to wait for 14 hours for it to get cleaned up.</FONT> <BR><FONT SIZE=2>>> > ></FONT> <BR><FONT SIZE=2>>> > > Winnie</FONT> <BR><FONT SIZE=2>>> > ></FONT> <BR><FONT SIZE=2>>> > > Joan Hsieh <jhsieh_at_infonet.tufts.edu> on 05/18/2000 02:19:39 PM</FONT> <BR><FONT SIZE=2>>> > ></FONT> <BR><FONT SIZE=2>>> > > Please respond to ORACLE-L_at_fatcity.com</FONT> <BR><FONT SIZE=2>>> > ></FONT> <BR><FONT SIZE=2>>> > > To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com></FONT> <BR><FONT SIZE=2>>> > > cc: (bcc: Winnie Liu/HQ/ISC)</FONT> <BR><FONT SIZE=2>>> > ></FONT> <BR><FONT SIZE=2>>> > > Hi List,</FONT> <BR><FONT SIZE=2>>> > ></FONT> <BR><FONT SIZE=2>>> > > One of the developers deleted more than 120,000 rows on a small</FONT> <BR><FONT SIZE=2>>> > > database. In the middle of the session, he killed the </FONT> <BR><FONT SIZE=2>>>process.(because</FONT> <BR><FONT SIZE=2>>> > > hang) I did shutdown abort and startup again (waited a while whitout</FONT> <BR><FONT SIZE=2>>> > > problem) and want to shutdown immediate and startup over again. This</FONT> <BR><FONT SIZE=2>>> > > time shutdown immediate hangs. Is this normal (waiting rollback)? </FONT> <BR><FONT SIZE=2>>>I've</FONT> <BR><FONT SIZE=2>>> > > been hang here for over one hours now.</FONT> <BR><FONT SIZE=2>>> > ></FONT> <BR><FONT SIZE=2>>> > > Thanks in advance,</FONT> <BR><FONT SIZE=2>>> > ></FONT> <BR><FONT SIZE=2>>> > > Joan</FONT> <BR><FONT SIZE=2>>> > > --</FONT> <BR><FONT SIZE=2>>> > > Author: Joan Hsieh</FONT> <BR><FONT SIZE=2>>> > > INET: jhsieh_at_infonet.tufts.edu</FONT> <BR><FONT SIZE=2>>> > ></FONT> <BR><FONT SIZE=2>>> > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=2>>> > > San Diego, California -- Public Internet access / Mailing </FONT> <BR><FONT SIZE=2>>>Lists</FONT> <BR><FONT SIZE=2>>> > > --------------------------------------------------------------------</FONT> <BR><FONT SIZE=2>>> > > To REMOVE yourself from this mailing list, send an E-Mail message</FONT> <BR><FONT SIZE=2>>> > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in</FONT> <BR><FONT SIZE=2>>> > > the message BODY, include a line containing: UNSUB ORACLE-L</FONT> <BR><FONT SIZE=2>>> > > (or the name of mailing list you want to be removed from). You may</FONT> <BR><FONT SIZE=2>>> > > also send the HELP command for other information (like subscribing).</FONT> <BR><FONT SIZE=2>>> > ></FONT> <BR><FONT SIZE=2>>> > > --</FONT> <BR><FONT SIZE=2>>> > > Author:</FONT> <BR><FONT SIZE=2>>> > > INET: Winnie_Liu_at_infonet.com</FONT> <BR><FONT SIZE=2>>> > ></FONT> <BR><FONT SIZE=2>>> > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=2>>> > > San Diego, California -- Public Internet access / Mailing </FONT> <BR><FONT SIZE=2>>>Lists</FONT> <BR><FONT SIZE=2>>> > > --------------------------------------------------------------------</FONT> <BR><FONT SIZE=2>>> > > To REMOVE yourself from this mailing list, send an E-Mail message</FONT> <BR><FONT SIZE=2>>> > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in</FONT> <BR><FONT SIZE=2>>> > > the message BODY, include a line containing: UNSUB ORACLE-L</FONT> <BR><FONT SIZE=2>>> > > (or the name of mailing list you want to be removed from). You may</FONT> <BR><FONT SIZE=2>>> > > also send the HELP command for other information (like subscribing).</FONT> <BR><FONT SIZE=2>>> > --</FONT> <BR><FONT SIZE=2>>> > Author: Joan Hsieh</FONT> <BR><FONT SIZE=2>>> > INET: jhsieh_at_infonet.tufts.edu</FONT> <BR><FONT SIZE=2>>> ></FONT> <BR><FONT SIZE=2>>> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=2>>> > San Diego, California -- Public Internet access / Mailing Lists</FONT> <BR><FONT SIZE=2>>> > --------------------------------------------------------------------</FONT> <BR><FONT SIZE=2>>> > To REMOVE yourself from this mailing list, send an E-Mail message</FONT> <BR><FONT SIZE=2>>> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in</FONT> <BR><FONT SIZE=2>>> > the message BODY, include a line containing: UNSUB ORACLE-L</FONT> <BR><FONT SIZE=2>>> > (or the name of mailing list you want to be removed from). You may</FONT> <BR><FONT SIZE=2>>> > also send the HELP command for other information (like subscribing).</FONT> <BR><FONT SIZE=2>>> ></FONT> <BR><FONT SIZE=2>>> ></FONT> <BR><FONT SIZE=2>>> ></FONT> <BR><FONT SIZE=2>>> ></FONT> <BR><FONT SIZE=2>>> ></FONT> <BR><FONT SIZE=2>>> ></FONT> <BR><FONT SIZE=2>>> > --</FONT> <BR><FONT SIZE=2>>> > Author:</FONT> <BR><FONT SIZE=2>>> > INET: Winnie_Liu_at_infonet.com</FONT> <BR><FONT SIZE=2>>> ></FONT> <BR><FONT SIZE=2>>> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=2>>> > San Diego, California -- Public Internet access / Mailing Lists</FONT> <BR><FONT SIZE=2>>> > --------------------------------------------------------------------</FONT> <BR><FONT SIZE=2>>> > To REMOVE yourself from this mailing list, send an E-Mail message</FONT> <BR><FONT SIZE=2>>> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in</FONT> <BR><FONT SIZE=2>>> > the message BODY, include a line containing: UNSUB ORACLE-L</FONT> <BR><FONT SIZE=2>>> > (or the name of mailing list you want to be removed from). You may</FONT> <BR><FONT SIZE=2>>> > also send the HELP command for other information (like subscribing).</FONT> <BR><FONT SIZE=2>>> > --</FONT> <BR><FONT SIZE=2>>> > Author: Southerland, Teresa</FONT> <BR><FONT SIZE=2>>> > INET: tsouther_at_indiana.edu</FONT> <BR><FONT SIZE=2>>> ></FONT> <BR><FONT SIZE=2>>> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=2>>> > San Diego, California -- Public Internet access / Mailing Lists</FONT> <BR><FONT SIZE=2>>> > --------------------------------------------------------------------</FONT> <BR><FONT SIZE=2>>> > To REMOVE yourself from this mailing list, send an E-Mail message</FONT> <BR><FONT SIZE=2>>> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in</FONT> <BR><FONT SIZE=2>>> > the message BODY, include a line containing: UNSUB ORACLE-L</FONT> <BR><FONT SIZE=2>>> > (or the name of mailing list you want to be removed from). You may</FONT> <BR><FONT SIZE=2>>> > also send the HELP command for other information (like subscribing).</FONT> <BR><FONT SIZE=2>>> ></FONT> <BR><FONT SIZE=2>>> ></FONT> <BR><FONT SIZE=2>>> ></FONT> <BR><FONT SIZE=2>>> ></FONT> <BR><FONT SIZE=2>>> ></FONT> <BR><FONT SIZE=2>>> ></FONT> <BR><FONT SIZE=2>>> ></FONT> <BR><FONT SIZE=2>>> > --</FONT> <BR><FONT SIZE=2>>> > Author:</FONT> <BR><FONT SIZE=2>>> > INET: Winnie_Liu_at_infonet.com</FONT> <BR><FONT SIZE=2>>> ></FONT> <BR><FONT SIZE=2>>> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=2>>> > San Diego, California -- Public Internet access / Mailing Lists</FONT> <BR><FONT SIZE=2>>> > --------------------------------------------------------------------</FONT> <BR><FONT SIZE=2>>> > To REMOVE yourself from this mailing list, send an E-Mail message</FONT> <BR><FONT SIZE=2>>> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in</FONT> <BR><FONT SIZE=2>>> > the message BODY, include a line containing: UNSUB ORACLE-L</FONT> <BR><FONT SIZE=2>>> > (or the name of mailing list you want to be removed from). You may</FONT> <BR><FONT SIZE=2>>> > also send the HELP command for other information (like subscribing).</FONT> <BR><FONT SIZE=2>>> ></FONT> <BR><FONT SIZE=2>>></FONT> <BR><FONT SIZE=2>>>--</FONT> <BR><FONT SIZE=2>>>Author: Ari D Kaplan</FONT> <BR><FONT SIZE=2>>> INET: akaplan_at_interaccess.com</FONT> <BR><FONT SIZE=2>>></FONT> <BR><FONT SIZE=2>>>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=2>>>San Diego, California -- Public Internet access / Mailing Lists</FONT> <BR><FONT SIZE=2>>>--------------------------------------------------------------------</FONT> <BR><FONT SIZE=2>>>To REMOVE yourself from this mailing list, send an E-Mail message</FONT> <BR><FONT SIZE=2>>>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in</FONT> <BR><FONT SIZE=2>>>the message BODY, include a line containing: UNSUB ORACLE-L</FONT> <BR><FONT SIZE=2>>>(or the name of mailing list you want to be removed from). You may</FONT> <BR><FONT SIZE=2>>>also send the HELP command for other information (like subscribing).</FONT> <BR><FONT SIZE=2>></FONT> <BR><FONT SIZE=2>>________________________________________________________________________</FONT> <BR><FONT SIZE=2>>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com</FONT> <BR><FONT SIZE=2>></FONT> <BR><FONT SIZE=2>>--</FONT> <BR><FONT SIZE=2>>Author: Rachel Carmichael</FONT> <BR><FONT SIZE=2>> INET: carmichr_at_hotmail.com</FONT> <BR><FONT SIZE=2>></FONT> <BR><FONT SIZE=2>>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=2>>San Diego, California -- Public Internet access / Mailing Lists</FONT> <BR><FONT SIZE=2>>--------------------------------------------------------------------</FONT> <BR><FONT SIZE=2>>To REMOVE yourself from this mailing list, send an E-Mail message</FONT> <BR><FONT SIZE=2>>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in</FONT> <BR><FONT SIZE=2>>the message BODY, include a line containing: UNSUB ORACLE-L</FONT> <BR><FONT SIZE=2>>(or the name of mailing list you want to be removed from). You may</FONT> <BR><FONT SIZE=2>>also send the HELP command for other information (like subscribing).</FONT> </P> <P><FONT SIZE=2>________________________________________________________________________</FONT> <BR><FONT SIZE=2>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com</FONT> </P> <P><FONT SIZE=2>-- </FONT> <BR><FONT SIZE=2>Author: Madhavan Amruthur</FONT> <BR><FONT SIZE=2> INET: mad012000_at_hotmail.com</FONT> </P> <P><FONT SIZE=2>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051</FONT>Received on Fri May 26 2000 - 14:55:50 CDT
 |
 |