RE: Database Crash !!

From: Lyall Barbour <lyallbarbour_at_sanfranmail.com>
Date: Wed, 9 Aug 2000 12:56:33 -0400 (EDT)
Message-Id: <10584.114191@fatcity.com>

Hi Ashish,
Have you tried dropping the rollback segements, and then there tablespace and then creating the new stuff.

If there's no one on the system and nothing in the rollback segments, you should be able to drop the segments, then their tablespace and create news ones.

If you can't even open the database (which you said you could, so you shouldn't have to worry about this) then you're in a lot more trouble then we can help you with.

Good luck,
Lyall Barbour

------Original Message------

From: Ashish Shah <ar_shah_at_yahoo.com>
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: August 9, 2000 4:37:17 PM GMT
Subject: Database Crash !!

Hi All,

We had a disk failure. We lost index datafiles and rollback datafile..

The database is in noarchivelog mode..only backup I have is export.dmp..

I tried to open with..

-offline drop datafile

offline drop rbs now I can open the database... but can't do anything.. it's still complaining about rbs file which I already droped..

Any ideas??????

I am trying to create temp rollback so I can rebuild indexes.....

SVRMGR> create rollback segment temp1 tablespace system;
create rollback segment temp1 tablespace system *
ORA-00376: file 2 cannot be read at this time ORA-01110: data file 2: '/oradata/indxstp04/rbs01.dbf'

Ashish
Toronto, Canada

Do You Yahoo!?
Kick off your party with Yahoo! Invites. http://invites.yahoo.com/
--

Author: Ashish Shah
INET: ar_shah_at_yahoo.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).

FREE Personalized Email at Mail.com Received on Wed Aug 09 2000 - 11:56:33 CDT