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

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

--以前写过一篇如何取出undo$ name的信息.

<a href="http://blog.itpub.net/267265/viewspace-1162543/">http://blog.itpub.net/267265/viewspace-1162543/</a>

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

GDUL&gt; bootstrap

Bootstrap finish.

GDUL&gt; 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&gt; unload table sys.undo$

2016-04-01 12:06:46...unloaded "SYS"."UNDO$"   21 rows

--如果配置gdul.ini

&lt;!--export to SQLLDR, EXP, EXPDP--&gt;

&lt;export_format&gt;SQLLDR&lt;/export_format&gt;

$ 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$