> "Naik, Kevin K" wrote:
>
> Hi All,
>
> I have an interesting problem, on one of my databases, a data
> warehouse, a killed session was taking too long
> to rollback. It was time for the backup, and I had to do a shutdown
> abort.
> No its time to open the database, instance parallel recovery is taking
> place as normal, but the problem is,
> its being running for more than 20 hours and the database is still not
> open.
>
> Does any body have any clues, thoughts, ideas ?? Is there anyway I can
> see what exactly the dbms is up to ?
> The instance processes running are completely idle
>
> Thanx
> K Naik
>
v8.1.7.1.2
SQL> desc v$recovery_status;
Name Null? Type
----------------------- -------- ----------------
RECOVERY_CHECKPOINT DATE
THREAD NUMBER
SEQUENCE_NEEDED NUMBER
SCN_NEEDED VARCHAR2(16)
TIME_NEEDED DATE
PREVIOUS_LOG_NAME VARCHAR2(513)
PREVIOUS_LOG_STATUS VARCHAR2(13)
REASON VARCHAR2(13)
SQL> desc v$recovery_progress;
Name Null? Type
----------------------- -------- ----------------
TYPE VARCHAR2(64)
ITEM VARCHAR2(32)
SOFAR NUMBER
TOTAL NUMBER
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul Drake
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
