Re: How to tell if SMON is doing delayed recovery

On Mon, 13 Jul 1998 09:33:57 GMT, johnvue_at_gte.net <johnvue_at_gte.net> wrote:
>Oracle 7.3 lets you start up the database without waiting for a
>complete recovery.
>
>Is there a surefire way to tell if SMON is recovering? Is there a
>way to tell when it's finished?
>
>You can get some hints from the alert_SID.log that recovery has been
>initiated and you can see in a Unix "ps -f" listing that ora_smon is
>using more CPU than any other background processes. But these methods
>don't tell you 10 minutes after you've started the instance if the
>recovery is HAPPENING AT THIS MOMENT.

Just thinking out loud here, but maybe a tail -f alert_SID.log |grep ecovery would show things as they happen.

The output would be like this:

Beginning crash recovery of 1 threads
Recovery of Online Redo Log: Thread 1 Group 6 Seq 32881 Reading mem 0 Crash recovery completed successfully
SMON: enabling cache recovery
SMON: enabling tx recovery

>
>Oracle support didn't think there was any V$ views or any other method
>to find this out. Maybe there's a SMON trace I can enable that would
>show me.
>
>
>

jg
--
These opinions are my own and not necessarily those of Information Quest or Pebble In The Sky http://www.informationquest.com mailto:jgarry@nospameiq.com http://ourworld.compuserve.com/homepages/joel_garry Remove nospam to reply. mailto:joel_garry_at_compuserve.nospam.com "See your DBA?" I AM the @#%*& DBA! Received on Fri Jul 17 1998 - 20:02:22 CDT