oracle 11g rac undo表空间切换(四)
----------------------- ----------------
UNDOTBS2 _SYSSMU20_2568447873$ OFFLINE
UNDOTBS2 _SYSSMU19_4150900536$ OFFLINE
UNDOTBS2 _SYSSMU18_1622692891$ OFFLINE
UNDOTBS2 _SYSSMU17_2591770417$ OFFLINE
UNDOTBS2 _SYSSMU16_387766918$ OFFLINE
UNDOTBS2 _SYSSMU15_420029824$ OFFLINE
UNDOTBS2 _SYSSMU14_1191035681$ OFFLINE
UNDOTBS2 _SYSSMU13_1762171886$ OFFLINE
UNDOTBS2 _SYSSMU12_4222198645$ OFFLINE
UNDOTBS2 _SYSSMU11_4155293491$ OFFLINE
UNDOTBS3 _SYSSMU32_1846650689$ ONLINE
TABLESPACE_NAME SEGMENT_NAME STATUS
------------------------------ ------------------------------ ----------------
UNDOTBS3 _SYSSMU28_3009640607$ ONLINE
UNDOTBS3 _SYSSMU27_2601671938$ ONLINE
UNDOTBS3 _SYSSMU26_1750999348$ ONLINE
UNDOTBS3 _SYSSMU25_1760351227$ ONLINE
UNDOTBS3 _SYSSMU24_4215245524$ ONLINE
UNDOTBS3 _SYSSMU23_2874026201$ ONLINE
UNDOTBS3 _SYSSMU22_2783794725$ ONLINE
UNDOTBS3 _SYSSMU21_2564029858$ ONLINE
UNDOTBS3 _SYSSMU10_548360867$ ONLINE
31 rows selected.
删除undo undotbs2
SQL> drop tablespace undotbs2 including contents and datafiles;
Tablespace dropped.
此时，节点2 undo为 undotbs3
为了使用舒服，方便，再做一次切换，undotbs3切换为undotbs2
创建undo undotbs2
SQL> SQL> CREATE UNDO TABLESPACE UNDOTBS2 DATAFILE '+DATA' SIZE 5000M;
Tablespace created.
修改数据库undo 为undotbs2
SQL> alter system set undo_tablespace=UNDOTBS2 ;
System altered.
查看节点2 undo 回滚段的 status，发现undotbs2为online, unotbs3为offline
SQL> select tablespace_name,segment_name,status from dba_rollback_segs;
TABLESPACE_NAME SEGMENT_NAME STATUS
------------------------------ ------------------------------ ----------------
SYSTEM SYSTEM ONLINE
UNDOTBS1 _SYSSMU31_1711600031$ ONLINE
UNDOTBS1 _SYSSMU9_2798512696$ ONLINE
UNDOTBS1 _SYSSMU8_995173842$ ONLINE
UNDOTBS1 _SYSSMU7_3917959301$ ONLINE
UNDOTBS1 _SYSSMU6_2267393390$ ONLINE
UNDOTBS1 _SYSSMU5_1243198418$ ONLINE
UNDOTBS1 _SYSSMU4_2867323$ ONLINE
UNDOTBS1 _SYSSMU3_4052593799$ ONLINE
UNDOTBS1 _SYSSMU2_3024038969$ ONLINE
UNDOTBS1 _SYSSMU1_2935730364$ ONLINE
TABLESPACE_NAME SEGMENT_NAME STATUS
------------------------------ ------------------------------ ----------------
UNDOTBS2 _SYSSMU20_4267337343$ ONLINE
UNDOTBS2 _SYSSMU19_2533506319$ ONLINE
UNDOTBS2 _SYSSMU18_3937924111$ ONLINE
UNDOTBS2 _SYSSMU17_1745024019$ ONLINE
UNDOTBS2 _SYSSMU16_3155049813$ ONLINE
UNDOTBS2 _SYSSMU15_1100134579$ ONLINE
UNDOTBS2 _SYSSMU14_1445631384$ ONLINE
UNDOTBS