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