Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Database Crash !!

Re: Database Crash !!

From: <Winnie_Liu_at_infonet.com>
Date: Wed, 9 Aug 2000 09:48:18 -0700
Message-Id: <10584.114190@fatcity.com>


You will need to drop the entire tablespace (index and rollback) after you use "offline drop" command.

Winnie

Ashish Shah <ar_shah_at_yahoo.com> on 08/09/2000 08:25:51 AM

To: dbalist <ORACLE-L_at_fatcity.com>, lazydba <oracledba_at_quickdoc.co.uk> cc: (bcc: Winnie Liu/HQ/ISC)

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

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/

If you're bored, then visit the list's website: http://www.lazydba.com (updated daily)
to unsubscribe, send a blank email to oracledba-unsubscribe_at_quickdoc.co.uk to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk Received on Wed Aug 09 2000 - 11:48:18 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US