Thanks mike.. it worked..
Thanks all who replied.
Ashish.
- "Noonan, Michael" <michael.noonan_at_intel.com>
wrote:
> Ashish,
>
> Contact Oracle Support, or have a look at the
> attached.
> Usual rules apply, read and digest before proceeding
>
> Regards
> Mike
>
>
> -----Original Message-----
> From: Ashish Shah [mailto:ar_shah_at_yahoo.com]
> Sent: 09 August 2000 16:26
> To: dbalist; lazydba
> 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_at_quickdoc.co.uk
> to subscribe send a blank email to
> oracledba-subscribe_at_quickdoc.co.uk
>
>
>
> ATTACHMENT part 2 application/octet-stream
name=Recovering Rollback Tablespace.ZIP
Ashish
Toronto, Canada
Received on Wed Aug 09 2000 - 14:32:53 CDT