数据库不能open下查看undo段的名字

[oracle@www.htz.pw odu]$cat control.txt

#ts fno   rfno     filename                                          block_size  is_big_file header_offset blocks

0 0 0 /oracle/app/oracle/oradata/orcl1124/system01.dbf

这里我只写了SYSTEM表空间，因为UNDO$在SYSTEM表空间中

 

[oracle@www.htz.pw odu]$./odu

 

ODU> unload dict

CLUSTER C_USER# file_no: 1 block_no: 208

TABLE OBJ$ file_no: 1 block_no: 240

CLUSTER C_OBJ# file_no: 1 block_no: 144

CLUSTER C_OBJ# file_no: 1 block_no: 144

found IND$‘s obj# 19

found IND$‘s dataobj#:2,ts#:0,file#:1,block#:144,tab#:3

found TABPART$‘s obj# 591

found TABPART$‘s dataobj#:591,ts#:0,file#:1,block#:4000,tab#:0

found INDPART$‘s obj# 596

found INDPART$‘s dataobj#:596,ts#:0,file#:1,block#:4040,tab#:0

found TABSUBPART$‘s obj# 603

found TABSUBPART$‘s dataobj#:603,ts#:0,file#:1,block#:4096,tab#:0

found INDSUBPART$‘s obj# 608

found INDSUBPART$‘s dataobj#:608,ts#:0,file#:1,block#:4136,tab#:0

found IND$‘s obj# 19

found IND$‘s dataobj#:2,ts#:0,file#:1,block#:144,tab#:3

found LOB$‘s obj# 80

found LOB$‘s dataobj#:2,ts#:0,file#:1,block#:144,tab#:6

found LOBFRAG$‘s obj# 624

found LOBFRAG$‘s dataobj#:624,ts#:0,file#:1,block#:4264,tab#:0

 

 

ODU> unload table sys.undo$

 

Unloading table: UNDO$,object ID: 15

Unloading segment,storage(Obj#=15 DataObj#=15 TS#=0 File#=1 Block#=224 Cluster=0)

21 rows unloaded

 

 

[oracle@www.htz.pw odu]$cd data

[oracle@www.htz.pw data]$cat SYS_UNDO$.txt

0|SYSTEM|0|1|128|0|0|0|0|0|3|0|||||0

1|_SYSSMU1_3724004606$|1|3|128|1774525|0|862|222|0|3|2|||||2

2|_SYSSMU2_2996391332$|1|3|144|1774529|0|1083|212|0|3|2|||||2

3|_SYSSMU3_1723003836$|1|3|160|1774527|0|1077|217|0|3|2|||||2

4|_SYSSMU4_1254879796$|1|3|176|1774531|0|928|300|0|3|2|||||2

5|_SYSSMU5_898567397$|1|3|192|1774515|0|1075|229|0|3|2|||||2

6|_SYSSMU6_1263032392$|1|3|208|1774519|0|1262|286|0|3|2|||||2

7|_SYSSMU7_2070203016$|1|3|224|1774517|0|868|179|0|3|2|||||2

8|_SYSSMU8_517538920$|1|3|240|1774523|0|1105|335|0|3|2|||||2

9|_SYSSMU9_1650507775$|1|3|256|1774521|0|1088|402|0|3|2|||||2

10|_SYSSMU10_1197734989$|1|3|272|1774533|0|866|238|0|3|2|||||2

11|_SYSSMU11_894599432$|1|5|128|923330|0|2|1|0|1|5|||||2

12|_SYSSMU12_1573055333$|1|5|144|0|0|1|1|0|1|5|||||2

13|_SYSSMU13_3860906822$|1|5|160|923661|0|2|1|0|1|5|||||2

14|_SYSSMU14_3319140121$|1|5|176|923323|0|2|1|0|1|5|||||2

15|_SYSSMU15_1436577151$|1|5|192|923332|0|2|1|0|1|5|||||2

16|_SYSSMU16_1689093467$|1|5|208|923314|0|2|1|0|1|5|||||2

17|_SYSSMU17_1049158485$|1|5|224|923296|0|2|1|0|1|5|||||2

18|_SYSSMU18_1557221903$|1|5|240|923320|0|2|1|0|1|5|||||2

19|_SYSSMU19_2284825117$|1|5|256|923294|0|2|1|0|1|5|||||2

20|_SYSSMU20_2312497597$|1|5|272|923262|0|2|1|0|1|5|||||2

 

在DUMP的控制文件中我们能看到下面的信息

TABLESPACE #2 UNDOTBS1: recno=3

 First datafile link=3  Tablespace Flag=0

 Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00

 Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00

 

UNDO表空间的TS#=2

 

 

[oracle@www.htz.pw data]$awk -F\| ‘{ print $2,$12}‘ SYS_UNDO$.txt

SYSTEM 0

_SYSSMU1_3724004606$ 2

_SYSSMU2_2996391332$ 2

_SYSSMU3_1723003836$ 2

_SYSSMU4_1254879796$ 2

_SYSSMU5_898567397$ 2

_SYSSMU6_1263032392$ 2

_SYSSMU7_2070203016$ 2

_SYSSMU8_517538920$ 2

_SYSSMU9_1650507775$ 2

_SYSSMU10_1197734989$ 2

_SYSSMU11_894599432$ 5

_SYSSMU12_1573055333$ 5

_SYSSMU13_3860906822$ 5

_SYSSMU14_3319140121$ 5

_SYSSMU15_1436577151$ 5

_SYSSMU16_1689093467$ 5

_SYSSMU17_1049158485$ 5

_SYSSMU18_1557221903$ 5

_SYSSMU19_2284825117$ 5

_SYSSMU20_2312497597$ 5