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

I think that the rolling forward is a possibility. Theoretically in Oracle 8i the database opens as soon as the roll-forward is complete. SMON then continues to roll back uncommitted transactions as time is available. If a new transaction needs a data block that is still involved in an old uncommitted transaction, it will ask SMON to immediately roll that one back. Oracle marketing never missing a trick has given this feature a name "fast-start on-demand rollback". And by the way, this a question on the Backup and Recovery exam. More info at:
http://technet.oracle.com/deploy/availability/htdocs/fs_on-demand_rollback.h tml

Dennis Williams
DBA, 20% OCP
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Wednesday, June 19, 2002 2:14 PM
To: Multiple recipients of list ORACLE-L

Hi,

As Charlie said Oracle may be recovering a _BIG_ uncommitted transaction.

Also,

have you got huge redo logs ? If so, Oracle may be rolling forward comitted transactions too.

In both cases, I recommend:

• Use parallel recovery
• Tune IO subsystem before recovery

Note that recovery process is disk instensive process, not CPU intensive.

regards...

Charlie Mengler wrote:

> 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: chal_ping
> > INET: chaospku_at_163.net
> >
> > 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).
>
> --
> Charlie Mengler Maintenance Warehouse
> charliem_at_mwh.com 10641 Scripps Summit Ct.
> 858-831-2229 San Diego, CA 92131
> There are no stupid questions, but there are many inquisitive idiots!
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Charlie Mengler
> INET: charliem_at_mwh.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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.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).