Re: db won't mount

Henry,

Look at doc # 61552.1 on Metalink.

HTH,
Michael
www.atelo.com

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, June 27, 2001 17:54

> I've got a cute one here. I saw something like this years ago, but I can't
> remember what I did. The database is running Oracle 8.0.6 on Solaris 2.6. I
> was just brought into this problem, so I don't know too much about the
> database. It is shutdown nightly for a cold backup, and by the looks of
> things it never started up again after yesterday's shutdown. After that,
> numerous attempts at shutdown/startup appear in the alert.log and
> rdbms/audit. These are the facts as I know them:
>
> I did a shutdown abort succsessfully.
> Startup nomount worked.
> Alter database mount sits forever. (right now it has been sitting for 3
> hours. Looking at the alert logs, it sat for about 12 hours between last
> nights attempt to startup and the first shutdown run today). The whole
> database appears to be 600M (unless some files are hidden in funny spots).
> No errors in the alert.log, no trace files, no core dumps, nothing in cdump,
> udump, bdump, $ORACLE_HOME/rdbms/log
> CPU time for the background processes is 0. It is 1 second for the svrmgrl
> process. No change over the last 3 hours.
> fuser shows the control files opened by ckpt and svrmgrl process, but the
> data and log files are not opened.
> The alert log shows the shutdown prior to the problem being a shutdown
> immediate so no recovery or rollbacks should have been necessary.
>
> Has anyone seen this before? Thanks.
>
> Henry
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Henry Poras
> INET: Henry.Poras_at_ctp.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: Michael Netrusov
  INET: mn_at_g-fax.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).