Re: production database on aix won't be open, help

Hello Rajesh,

You are definitly right. But, as I know Deffered Transaction Rollback feature is intruduced with 7.3.

Also,

there is a good enhancement in 8i which enables SMON to use parallel query slaves automatically to complete rollback operation. Current threshold for that is 100 rollback blocks.

Rajesh.Rao_at_jpmchase.com wrote:

> Sorry, but does Oracle not do the rollback in the background, reading
> records from undo$. This is a feature called fast warmstart, introduced
> with 8.0. During an instance recovery, a roll forward is done, and the
> database opened for normal operations. A rollback is done in the
> background.
>
> Raj
>
>
> "Charlie
> Mengler" To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> <charliem_at_mwh cc:
> .com> Subject: Re: production database on aix won't be open, help
> Sent by:
> root_at_fatcity.
> com
>
>
> June 19, 2002
> 01:28 PM
> Please
> respond to
> ORACLE-L
>
>
>
> It might be that Oracle is simply trying to rollback a _BIG_ uncommitted
> transaction.
> Once in the past I had a similar problem. The fix was amazingly simple. I
> increased
> the size of the TEMP tablespace. I suspect that if you are really, really,
> really
> patient Oracle eventually will wake from its slumber & begin normal
> operations.
>
> HTH & YMMV,
>
> HAND!
>
> chal_ping wrote:
> >
> > oracle-lHi, grurus:
> > This is a production database 8.1.7.2 on aix 4.3.3, there are 17
> instances running on the same box.
> > I shutdown immediate the database and it hangs.After wait for one
> hour, i do a shutdown abort. When i startup again, it failed to open the
> database , just hangs at this stage like:
> > Sun Jun 16 09:36:40 2002
> > SMON: enabling cache recovery
> > SMON: enabling tx recovery
> > And the sql*plus window hangs at : database mounted, but never
> showed open.
> > From another shell prompt, i sqlplus internal and query the
> instance, it showed instance open in read write state!
> > But from remote node via listener, client process showed 0134:
> oracle not available.
> > I once met such kind of questions on sun solaris, it is because
> of solaris bug.But never heard of this kind on AIX. Oracle support suggest
> reboot the server, but as there is 16 other instance on it, it is not the
> solution.
> > Can anyone help?
> > Great thanks.
> >
> > --
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: Rajesh.Rao_at_jpmchase.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).

--
Danisment Gazi Unal
http://www.ubTools.com



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Danisment Gazi Unal (ubTools)
  INET: dunal_at_ubTools.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).