Re: Rollback datafile RBSORCL.ORA corrupt and not archived. Is it possible to bring db up?

You can try the following :

1. comment out the ROLLBACK_SEGMENTS parameters in the init.ora
2. startup and mount the database
3. get the rollback datafile offline
4. open the database
5. create a couple rollback segments in some other tablespace (for the time being)
6. recover the rollback tablespace from the logs
7. bring the rollback tablespace online
8. bring all the rollback segmens online, which were in the rollback tablespace
9. drop the couple rollback segments created temporarily
10. restore the ROLLBACK_SEGMENTS parameters in init.ora

Verma

sbarakam_at_ingr.com wrote in article <87fcl9$nh8$1_at_nnrp1.deja.com>...
>
>
>
> On a Oracle 7.3 server, the rollback datafile "RBSORCL.ORA" is corrupt.
> startup from svrmgr says "needs recovery. datafile '...\rbsorcl.ora'
> file 3 block .. segment... corrupt.
>
> There is no backup, since it is a test db. Is there a way to bring the
> database up? I tried to take the rollback segment offline, but since
> the database can not be opened without this rbsorcl.ora file, it is not
> possible. The initorcl.ora file does not list this rollback file; I
> tried _offline_rollback_segment = (rbs) in the init file, along with
> (rb01), (rb02) etc., but the same error message.
>
> thanks
> Sreedhar
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>
Received on Sat Feb 05 2000 - 23:38:36 CST