切换到新的undo
alter system set undo_tablespace='UNDOTBS3' sid='dw1'
alter system set undo_tablespace='UNDOTBS4' sid='dw2'
--dw1
SQL> show parameter undo
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string AUTO
undo_retention integer 10800
undo_tablespace string UNDOTBS3
--dw2
SQL> show parameter undo
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string AUTO
undo_retention integer 10800
undo_tablespace string UNDOTBS4
离线旧的undotbs1,undotbs2
ALTER TABLESPACE UNDOTBS1 OFFLINE NORMAL;
ALTER TABLESPACE UNDOTBS2 OFFLINE NORMAL;
这时发现不能作写操作!提示如下:
ORA-01110: data file 5: '/dev/rlv_8g_002'
注:'/dev/rlv_8g_002' 这个裸设备是undotbs2里的。