RE: Waiting for smon to disable tx recovery.

From: Gopal, Umesh <ugopal_at_proxicom.com>
Date: Thu, 15 Jun 2000 08:54:30 -0400
Message-Id: <10529.109385@fatcity.com>

replace shutdown abort by, shutdown immediate, by using shutdown abort you are definitely going to cause instance recovery, hence the message

Umesh

-----Original Message-----
From: Terrian, Thomas [mailto:Thomas.Terrian_at_standardregister.com] Sent: Thursday, June 15, 2000 9:08 AM
To: Multiple recipients of list ORACLE-L Subject: Waiting for smon to disable tx recovery.

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

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.

AIX 4.3.2, Oracle 8.1.6.1.0

Any ideas?

Tom Terrian
Oracle DBA
(937) 221-1647
Thomas.Terrian_at_standardregister.com Received on Thu Jun 15 2000 - 07:54:30 CDT