Message-Id: <10584.114190@fatcity.com> From: Winnie_Liu@infonet.com Date: Wed, 9 Aug 2000 09:48:18 -0700 Subject: Re: Database Crash !! You will need to drop the entire tablespace (index and rollback) after you use "offline drop" command. Winnie Ashish Shah on 08/09/2000 08:25:51 AM To: dbalist , lazydba 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 - 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/ -------- 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@quickdoc.co.uk to subscribe send a blank email to oracledba-subscribe@quickdoc.co.uk