undo를 1번에서 2번으로 옮기고 1번을 drop 시킬려고 하는데... 에러가... ㅠ,.ㅜ 시급히 처리해야 하는데... 인터넷에서 방법을 봐도 잘 안되네요.
각 명령어 실행시 나오는 결과 입니다.
오라클 버전은 현재 10g를 사용하고 있습니다. 조언 좀 부탁드리겠습니다.
-------------------------------------------------------------------------------------------------------
> show parameter undo;
undo_management string AUTO
undo_retention integer 900
undo_tablespace string UNDOTBS2
-------------------------------------------------------------------------------------------------------
> select SEGMENT_NAME,TABLESPACE_NAME, PCT_INCREASE, STATUS from dba_rollback_segs;
SYSTEM SYSTEM ONLINE
_SYSSMU1$ UNDOTBS2 ONLINE
_SYSSMU2$ UNDOTBS2 ONLINE
_SYSSMU3$ UNDOTBS1 NEEDS RECOVERY
_SYSSMU4$ UNDOTBS1 OFFLINE
_SYSSMU5$ UNDOTBS1 OFFLINE
_SYSSMU6$ UNDOTBS1 OFFLINE
_SYSSMU7$ UNDOTBS1 OFFLINE
_SYSSMU8$ UNDOTBS1 OFFLINE
_SYSSMU9$ UNDOTBS1 OFFLINE
_SYSSMU10$ UNDOTBS1 OFFLINE
_SYSSMU11$ UNDOTBS1 OFFLINE
_SYSSMU12$ UNDOTBS1 OFFLINE
_SYSSMU13$ UNDOTBS1 OFFLINE
_SYSSMU14$ UNDOTBS1 OFFLINE
_SYSSMU15$ UNDOTBS1 OFFLINE
_SYSSMU16$ UNDOTBS1 OFFLINE
_SYSSMU17$ UNDOTBS1 OFFLINE
_SYSSMU18$ UNDOTBS1 OFFLINE
_SYSSMU19$ UNDOTBS1 OFFLINE
_SYSSMU20$ UNDOTBS1 OFFLINE
_SYSSMU21$ UNDOTBS1 OFFLINE
_SYSSMU22$ UNDOTBS1 OFFLINE
_SYSSMU23$ UNDOTBS1 OFFLINE
_SYSSMU24$ UNDOTBS1 OFFLINE
_SYSSMU25$ UNDOTBS1 OFFLINE
_SYSSMU26$ UNDOTBS1 OFFLINE
_SYSSMU27$ UNDOTBS1 OFFLINE
_SYSSMU28$ UNDOTBS1 OFFLINE
_SYSSMU29$ UNDOTBS1 OFFLINE
_SYSSMU30$ UNDOTBS1 OFFLINE
_SYSSMU60$ UNDOTBS2 ONLINE
_SYSSMU61$ UNDOTBS2 ONLINE
_SYSSMU62$ UNDOTBS2 ONLINE
_SYSSMU63$ UNDOTBS2 ONLINE
_SYSSMU64$ UNDOTBS2 ONLINE
_SYSSMU65$ UNDOTBS2 ONLINE
_SYSSMU66$ UNDOTBS2 ONLINE
_SYSSMU67$ UNDOTBS2 ONLINE
_SYSSMU68$ UNDOTBS2 ONLINE
_SYSSMU69$ UNDOTBS2 ONLINE
_SYSSMU70$ UNDOTBS2 ONLINE
_SYSSMU71$ UNDOTBS2 ONLINE
_SYSSMU72$ UNDOTBS2 ONLINE
_SYSSMU73$ UNDOTBS2 ONLINE
_SYSSMU74$ UNDOTBS2 ONLINE
_SYSSMU75$ UNDOTBS2 ONLINE
_SYSSMU76$ UNDOTBS2 ONLINE
_SYSSMU77$ UNDOTBS2 ONLINE
_SYSSMU78$ UNDOTBS2 ONLINE
_SYSSMU79$ UNDOTBS2 ONLINE
_SYSSMU80$ UNDOTBS2 ONLINE
_SYSSMU81$ UNDOTBS2 ONLINE
_SYSSMU82$ UNDOTBS2 ONLINE
_SYSSMU83$ UNDOTBS2 ONLINE
_SYSSMU84$ UNDOTBS2 ONLINE
_SYSSMU85$ UNDOTBS2 ONLINE
_SYSSMU86$ UNDOTBS2 ONLINE
-------------------------------------------------------------------------------------------------------
> select segment_name,status,tablespace_name from dba_rollback_segs where status='NEEDS RECOVERY';
_SYSSMU3$ NEEDS RECOVERY UNDOTBS1
-------------------------------------------------------------------------------------------------------
> alter rollback segment "_SYSSMU3$" OFFLINE;
Rollback segment altered.
-------------------------------------------------------------------------------------------------------
> drop rollback segment "_SYSSMU3$";
ERROR at line 1:
ORA-30025: DROP segment '_SYSSMU3$' (in undo tablespace) not allowed
-------------------------------------------------------------------------------------------------------
> drop tablespace UNDOTBS1 including contents and datafiles cascade constraints;
ERROR at line 1:
ORA-01548: active rollback segment '_SYSSMU3$' found, terminate dropping tablespace
-------------------------------------------------------------------------------------------------------
> alter database datafile '/oradata/RCMDB/undotbs01.dbf' resize 10000M;
ERROR at line 1:
ORA-00376: file 2 cannot be read at this time
ORA-01110: data file 2: '/oradata/RCMDB/undotbs01.dbf'
-------------------------------------------------------------------------------------------------------
|