I've lost some Rollback Segments, how can I get my DB back? (for DBA
ORACLE Interview Questions and Answers (Part 2)
(Continued from previous question...)
283. I've lost some Rollback Segments, how can I get my DB back? (for DBA
Re-start your database with the following INIT.ORA parameter if one of your rollback segments is corrupted. You can then drop the corrupted rollback segments and create it from scratch.
Caution is advised when enabling this parameter, as uncommitted transactions will be marked as committed. One can very well end up with lost or inconsistent data!!! Please contact Oracle Support before using it.
_Corrupted_rollback_segments = (rbs01, rbs01, rbs03, rbs04)
(Continued on next question...)
Other Interview Questions