Re: Waiting for smon to disable tx recovery.

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Thu, 15 Jun 2000 10:05:47 -0400
Message-Id: <10529.109398@fatcity.com>

I'm guessing a bit here, but when you startup after a SHUTDOWN ABORT, Oracle needs to perform crash recovery. Is it possible that your are issuing your SHUTDOWN IMMEDIATE statement while that recovery is still underway? Could the delay then be a result of SMON needing to finish the recovery before shutting down the database again?

Jonathan

---

jonathan_at_gennick.com =20
http://gennick.com
Brighten the Corner Where You Are

On Thu, 15 Jun 2000 05:07:57 -0800, you wrote:

>Does anyone else see this in their alert log file when they bounce their
>database?:
>
>Waiting for smon to disable tx recovery.
>
>It is happening more and more at my site. Last night we got it 18 =
times.
>We do the following each night:
>1. Shutdown abort.
>2. Startup
>3. Shutdown immediate
>4. Do our backups
>5. Startup
>=20
>We get the warning messages during step 3. Each time we get the message
>there is a 5 minute delay so it took us over an hour to bounce the =
database
>last night.
>=20
>AIX 4.3.2, Oracle 8.1.6.1.0
>=20
>Any ideas?
>
>Tom Terrian
>Oracle DBA
>(937) 221-1647
Received on Thu Jun 15 2000 - 09:05:47 CDT