Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Database Crash !!
Winnie,=20
Please explain to me why she would have to drop the entire tablespace when =
she did an offline drop command for the data file and rbs. She is trying =
to create a segment on the system tablespace not the index tablespace. =
Should it not create the new rollback segment anyway?? Other than the =
crash taking the rbs down before she could manually do it, isn't the =
method of working with rbs's to offline, drop,create?
Ron Rogers
DBA OCP
Atl.ga
>>> Winnie_Liu_at_infonet.com 08/09/00 02:07PM >>>
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)
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'
=3D=3D=3D=3D=3D
Ashish
Toronto, Canada
--=20
Author:=20
INET: Winnie_Liu_at_infonet.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 Received on Wed Aug 09 2000 - 14:34:56 CDT