RE: Crash Recovery

oops, forgot that,
Sun Solaris 5.6, its an E6000, 16 cpu box, running dbms 7.3.4.5.0 the online redo logs are 500 megs in size the transaction used -+ 4 million records

-----Original Message-----
From: Paul Drake [mailto:paled_at_home.com] Sent: 10 June, 2001 21:10
To: Multiple recipients of list ORACLE-L Subject: Re: Crash Recovery

> "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
>

Hi.

platform/version info please?
how large are your online redo logs?
are your archived redo logs on the same physical drives as your datafiles being recovered?
(thrashing on the drives)
how large was the transaction that was running when you did the shutdown abort?
recovery is the process of applying redo to roll forward (crash recovery), followed by rolling back failed transactions (transaction recovery).

you might have had better luck with killing the user process/thread than simply issuing the shotdown abort.

Paul

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Drake
  INET: paled_at_home.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).





______________________________________________<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>             _______________________________________________