DBA_ROLLBACK_SEGS entry of status "NEEDS RECOVERY" or "PARTLY AVAILABLE"

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
DBA_ROLLBACK_SEGS entry of status "NEEDS RECOVERY"
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
The DBA_ROLLBACK_SEGS view shows a rollback segment as "NEEDS RECOVERY"
if Oracle cannot see the rollback segment header or if there is a problem
encountered when attempting to roll out a transaction (eg: a tablespace or
datafile required to roll out a transaction is OFFLINE).

Actions:
1. Make a note of the SEGMENT_NAME for the DBA_ROLLBACK_SEGS row
which has STATUS set to "NEEDS RECOVERY"
eg:
SELECT segment_id, segment_name
FROM dba_rollback_segs
WHERE status='NEEDS RECOVERY';
2. Go to "Recovering Rollback Segments"
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
DBA_ROLLBACK_SEGS entry of status "PARTLY AVAILABLE"
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
The DBA_ROLLBACK_SEGS view shows a rollback segment as "PARTLY AVAILABLE"
if it is otherwise OFFLINE and either:
a. it contains active transactions that SMON has not yet finished
recovering
or
b. it contains in-doubt transactions
In case 'a' SMON will continue to roll out any active transactions in the
rollback segment and finally mark it as 'OFFLINE'. If an error is
encountered preventing a transaction from rolling out the status is changed
to "NEEDS RECOVERY".
In case 'b' the in-doubt transaction has to be resolved.
It is possible to ONLINE a "PARTLY AVAILABLE" rollback segment - doing so
will change its status to "ONLINE".
Go to "Recovering Rollback Segments"
Go to "Checking for active transactions on a rollback segment" to see
the state of transactions on this rollback segment.