Re: Database Crash !!

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

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