Database Crash !!

From: Ashish Shah <ar_shah_at_yahoo.com>
Date: Wed, 9 Aug 2000 08:25:51 -0700 (PDT)
Message-Id: <10584.114182@fatcity.com>

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. Received on Wed Aug 09 2000 - 10:25:51 CDT