Crash Recovery

From: Naik, Kevin K <KNaik_at_mail.sbic.co.za>
Date: Sun, 10 Jun 2001 10:27:51 -0700
Message-ID: <F001.003236A6.20010610100019@fatcity.com>

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

______________________________________________<FONT face=Arial 

size=2>
Disclaimer and
confidentiality note
Everything in this e-mail and
any attachments relating to the official business of Standard Bank Investment Corporation <FONT face=Arial
size=2>(Stanbic) is proprietary to the company. It is confidential, legally privileged and protected by law. Stanbic<FONT color=#0000ff face=Arial size=2> does not own and endorse any other content. Views and opinions are those of the sender unless clearly stated as being that of Stanbic.
The person addressed in the
e-mail is the sole authorised recipient. Please notify the sender immediately if it has unintentionally reached you and do not read, disclose or use the content in any way.

Stanbic can not assure that the integrity of this communication has been maintained nor that it is free of errors, virus, interception or interference.
<FONT

size=1>             _______________________________________________

Received on Sun Jun 10 2001 - 12:27:51 CDT