Re: Crash Recovery

It's always a good idea to include your platform, OS version and most importantly, your Oracle version.

Since it's a DW, I'm guessing that the session in question was doing parallel DML, and it's an older version of Oracle, which does not have parallel rollback capability. ( forget which version introduced this )

The rollback is being done serially, and you'll just have to wait for it.

Jared

On Sunday 10 June 2001 11:00, 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
>
> ______________________________________________
>
> Disclaimer and confidentiality note
>
> Everything in this e-mail and any attachments relating to the official
> business of Standard Bank Investment Corporation (Stanbic) is proprietary
> to the company. It is confidential, legally privileged and protected by
> law.\ Stanbic 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.
>
>
> ______________________________________________

Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1"
Content-Transfer-Encoding: 7bit
Content-Description: 
----------------------------------------

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