oracle 11g rac undo表空间切换(二)
-----
UNDOTBS1 _SYSSMU1_1700093001$ OFFLINE
UNDOTBS2 _SYSSMU20_2568447873$ ONLINE
UNDOTBS2 _SYSSMU19_4150900536$ ONLINE
UNDOTBS2 _SYSSMU18_1622692891$ ONLINE
UNDOTBS2 _SYSSMU17_2591770417$ ONLINE
UNDOTBS2 _SYSSMU16_387766918$ ONLINE
UNDOTBS2 _SYSSMU15_420029824$ ONLINE
UNDOTBS2 _SYSSMU14_1191035681$ ONLINE
UNDOTBS2 _SYSSMU13_1762171886$ ONLINE
UNDOTBS2 _SYSSMU12_4222198645$ ONLINE
UNDOTBS2 _SYSSMU11_4155293491$ ONLINE
TABLESPACE_NAME SEGMENT_NAME STATUS
------------------------------ ------------------------------ ----------------
UNDOTBS3 _SYSSMU30_2992889604$ ONLINE
UNDOTBS3 _SYSSMU29_3198754354$ ONLINE
UNDOTBS3 _SYSSMU28_3953353629$ ONLINE
UNDOTBS3 _SYSSMU27_2811255809$ ONLINE
UNDOTBS3 _SYSSMU26_3953879438$ ONLINE
UNDOTBS3 _SYSSMU25_3485703372$ ONLINE
UNDOTBS3 _SYSSMU24_1121934957$ ONLINE
UNDOTBS3 _SYSSMU23_153918182$ ONLINE
UNDOTBS3 _SYSSMU22_1502226063$ ONLINE
UNDOTBS3 _SYSSMU21_3331829347$ ONLINE
32 rows selected.
删除 undotbs1
SQL> drop tablespace undotbs1 including contents and datafiles;
Tablespace dropped.
此时，节点1的undo为undotbs3,为了看起舒服，再切换为undotbs1
创建undotbs1
SQL> CREATE UNDO TABLESPACE UNDOTBS1 DATAFILE '+DATA' SIZE 5000M;
Tablespace created.
修改
数据库undo为 undotbs1
SQL> alter system set undo_tablespace=UNDOTBS1 scope=both;
System altered.
查看数据库回滚段的status发现undotbs1online undotbs3 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_2568447873$ ONLINE
UNDOTBS2 _SYSSMU19_4150900536$ ONLINE
UNDOTBS2 _SYSSMU18_1622692891$ ONLINE
UNDOTBS2 _SYSSMU17_2591770417$ ONLINE
UNDOTBS2 _SYSSMU16_387766918$ ONLINE
UNDOTBS2 _SYSSMU15_420029824$ ONLINE
UNDOTBS2 _SYSSMU14_1191035681$ ONLINE
UNDOTBS2 _SYSSMU13_1