Re: Recovering ORACLE db after system crash

In article <1992Oct6.225552.27031_at_cerberus.bhpese.oz.au>, brad_at_cerberus.bhpese.oz.au (Brad Keifer) writes:
>

.
.
> Using SQLDBA to look at the rollback segments table indicated that one of
> the rollback segments had a status of "NEEDS RECOVERY".
> I couldn't drop the table because ORACLE told me to put it offline, I
> couldn't alter it offline either, neither could I recover tablespace
> "rollback_segment".
>
> In the end we were desperate so we restored from tape.
>
> What should I have done?

There is an undocumented init.ora parameter that will help you. I am not exactly sure of its name but I think it is '_OFFLINE_ROLLBACK_SEGMENT'.

What it does is force the DBMS to ignore or offlines the RBS. This would have saved you the trouble of recovering the DB.

Warning: Seek Oracle support before using any '_init_ora_parameter'.

tony

 _____       ________ / ____ |Tony Jambu, Database Administrator
  /_  __       /_ __ /       |Colonial Mutual Life Australia. (ACN 004021809)
 /(_)/ ((_/ \_/(///(/_)/_(   |EMAIL:  TJambu_at_cmutual.com.au
 ______  /                   |PHONE:  +61-3-6076448
       \/                    |  FAX:  +61-3-6076198

-- 
-----------------------------------------------------------------------------
 _____       ________ / ____ |Tony Jambu, Database Administrator
  /_  __       /_ __ /       |Colonial Mutual Life Australia. (ACN 004021809)
 /(_)/ ((_/ \_/(///(/_)/_(   |EMAIL:  TJambu_at_cmutual.com.au