-
Hi,
We have an Oracle Instance in which all the rollback segments
are part of a tablespace that has one datafile.
Unfortunately, the datafile is corrupted. (We ran dbv to verify
that it is corrupted). The SYSTEM rollback segment is fine.
What is the right and easiest way of fixing this problem?
Thanks,
- Hari
-
- Create new tablespace with datafile in it
- create new rollbacks in it
- Alter new rollbacks online
- alter old rollbacks offline
- drop old rollbacks
- drop corrupted datafile & tablespace
- Manipultae init.ora file for the instance and include an entry to activate new rollbacks automatically whenever instance is initialized like :
rollback_segments=(hh,hh,hh,hh)
-
Nagia,
Thanks for your help.
- Hari