undo segment NEEDS RECOVERY

undo segment NEEDS RECOVERY

SELECT SEGMENT_NAME,STATUS  FROM DBA_ROLLBACK_SEGS WHERE STATUS LIKE 'PART%' or status like 'NEED%';

 SEGMENT_NAME                   STATUS

------------------------------ ----------------
_SYSSMU17$                     NEEDS RECOVERY

 

 

SELECT * FROM V$RECOVER_FILE;

      FILE# ONLINE  ONLINE_ ERROR                 CHANGE# TIME

---------- ------- ------- ------------------ ---------- ---------

         2 OFFLINE OFFLINE OFFLINE NORMAL              0

 

 

SELECT NAME,STATUS FROM V$DATAFILE WHERE FILE#=2;

 

NAME                                                                   

----------------------------------------------------------------------

/undo/undotbs01.dbf                                                     

ALTER DATABASE DATAFILE 2 ONLINE;

Database altered.

 

 

SELECT STATUS,NAME FROM V$DATAFILE WHERE FILE#=2;

STATUS  NAME

------- ------------------------------------------------------------

ONLINE  /undo/undotbs01.dbf

 

 

SELECT * FROM V$RECOVER_FILE;

no rows selected

 

SELECT SEGMENT_NAME,STATUS  FROM DBA_ROLLBACK_SEGS WHERE STATUS LIKE 'PART%' or status like 'NEED%';

SEGMENT_NAME                   STATUS

------------------------------ ----------------

_SYSSMU17$                     NEEDS RECOVERY

 

 

select tablespace_name,status from dba_tablespaces;

TABLESPACE_NAME                STATUS

------------------------------ ---------

SYSTEM                         ONLINE

UNDOTBS1                       OFFLINE

alter tablespace UNDOTBS1 ONLINE;

Tablespace altered.

 

SELECT SEGMENT_NAME,STATUS  FROM DBA_ROLLBACK_SEGS WHERE STATUS LIKE 'PART%' or status like 'NEED%';

SEGMENT_NAME                   STATUS

------------------------------ ----------------

_SYSSMU17$                     NEEDS RECOVERY

 

 

alter rollback segment "_SYSSMU17$" online;

Rollback segment altered.

 

 

SELECT SEGMENT_NAME,STATUS  FROM DBA_ROLLBACK_SEGS WHERE STATUS LIKE 'PART%' or status like 'NEED%';

no rows selected