Re: Database Crash !!

From: Ron Rogers <RROGERS_at_galottery.org>
Date: Wed, 09 Aug 2000 13:29:18 -0400
Message-Id: <10584.114193@fatcity.com>

Perhaps the rbs you took offline is needed to create the temp1 rollback = segment. That is what the error message points to.=20 Query the DBA_ROLLBACK_SEGS,V$ROLLSTAT,V$ROLLNAME to determine the status = of all the rollback segments.
HTH,
Ron Rogers
DBA OCP
Atl.GA
>>> ar_shah_at_yahoo.com 08/09/00 12:37PM >>>
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=20 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'

=3D=3D=3D=3D=3D
Ashish
Toronto, Canada

---

Do You Yahoo!?
Kick off your party with Yahoo! Invites. http://invites.yahoo.com/=20
--=20
Author: Ashish Shah
  INET: ar_shah_at_yahoo.com=20

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). Received on Wed Aug 09 2000 - 12:29:18 CDT