[20160401]取出回滚段信息2.txt

--以前写过一篇如何取出undo$ name的信息.
http://blog.itpub.net/267265/viewspace-1162543/

--实际上有gdul,一切变得很简单.

GDUL> bootstrap
Bootstrap finish.

GDUL> desc sys.undo$
object_id: 15, dataobj#: 15, cluster tab#: 0
segment header: (ts#: 0, rfile#: 1, block#: 224))

Seg Column#  Column#    Name                 Null?           Type
------------ ---------- -------------------- --------------- --------------
1            1          US#                  NOT NULL        NUMBER
2            2          NAME                 NOT NULL        VARCHAR2(30)
3            3          USER#                NOT NULL        NUMBER
4            4          FILE#                NOT NULL        NUMBER
5            5          BLOCK#               NOT NULL        NUMBER
6            6          SCNBAS                               NUMBER
7            7          SCNWRP                               NUMBER
8            8          XACTSQN                              NUMBER
9            9          UNDOSQN                              NUMBER
10           10         INST#                                NUMBER
11           11         STATUS$              NOT NULL        NUMBER
12           12         TS#                                  NUMBER
13           13         UGRP#                                NUMBER
14           14         KEEP                                 NUMBER
15           15         OPTIMAL                              NUMBER
16           16         FLAGS                                NUMBER
17           17         SPARE1                               NUMBER
18           18         SPARE2                               NUMBER
19           19         SPARE3                               NUMBER
20           20         SPARE4                               VARCHAR2(1000)
21           21         SPARE5                               VARCHAR2(1000)
22           22         SPARE6                               DATE

GDUL> unload table sys.undo$
2016-04-01 12:06:46...unloaded "SYS"."UNDO$"   21 rows

--如果配置gdul.ini
<!--export to SQLLDR, EXP, EXPDP-->
<export_format>SQLLDR</export_format>

$ cat ~/gdul/dump/SYS_UNDO\$.dat
0|SYSTEM|0|1|128|0|0|0|0|0|3|0|||||0||||||
1|_SYSSMU1_3724004606$|1|3|128|342644320|3|2931|1054|0|3|2|||||2||||||
2|_SYSSMU2_2996391332$|1|3|144|342644290|3|3175|1510|0|3|2|||||2||||||
3|_SYSSMU3_1723003836$|1|3|160|342644376|3|3228|1761|0|3|2|||||2||||||
4|_SYSSMU4_1254879796$|1|3|176|342644334|3|3077|1573|0|3|2|||||2||||||
5|_SYSSMU5_898567397$|1|3|192|342644362|3|3460|1581|0|3|2|||||2||||||
6|_SYSSMU6_1263032392$|1|3|208|342644288|3|3570|1101|0|3|2|||||2||||||
7|_SYSSMU7_2070203016$|1|3|224|342644182|3|5234|1560|0|3|2|||||2||||||
8|_SYSSMU8_517538920$|1|3|240|342644358|3|8609|1517|0|3|2|||||2||||||
9|_SYSSMU9_1650507775$|1|3|256|342644370|3|12252|1282|0|3|2|||||2||||||
10|_SYSSMU10_1197734989$|1|3|272|342644380|3|30869|5618|0|3|2|||||2||||||
11|_SYSSMU11_1701842685$|1|3|248|337617109|3|557|362|0|1|2|||||2||||||
12|_SYSSMU12_3785813942$|1|3|296|337514803|3|1747|624|0|1|2|||||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||||||

$ cut -d"|" -f2  ~/gdul/dump/SYS_UNDO\$.dat
SYSTEM
_SYSSMU1_3724004606$
_SYSSMU2_2996391332$
_SYSSMU3_1723003836$
_SYSSMU4_1254879796$
_SYSSMU5_898567397$
_SYSSMU6_1263032392$
_SYSSMU7_2070203016$
_SYSSMU8_517538920$
_SYSSMU9_1650507775$
_SYSSMU10_1197734989$
_SYSSMU11_1701842685$
_SYSSMU12_3785813942$
_SYSSMU13_3860906822$
_SYSSMU14_3319140121$
_SYSSMU15_1436577151$
_SYSSMU16_1689093467$
_SYSSMU17_1049158485$
_SYSSMU18_1557221903$
_SYSSMU19_2284825117$
_SYSSMU20_2312497597$