AUL 挖取11g UNDO段名称

挖取11g undosegment 名称。
下载老楼的AUL.

1.创建配置文件。

点击(此处)折叠或打开

1. SQL> spool d:\auldemf.cfg
2. SQL> select file#,rfile#,name from v$datafile;
4. FILE# RFILE# NAME
5. ---------- ---------- --------------------------------------------------
6. 1 1 F:\APP\ADMINISTRATOR\ORADATA\ORCL\SYSTEM01.DBF
7. 2 2 F:\APP\ADMINISTRATOR\ORADATA\ORCL\SYSAUX01.DBF
8. 4 4 F:\APP\ADMINISTRATOR\ORADATA\ORCL\USERS01.DBF
10. SQL> spool off;

2.挖取

点击(此处)折叠或打开

1. D:\>cd aul
   
2. 
   
3. D:\aul>aul5b_trial.exe
   
4. Register Code: Trial Version, No License
   
5. 
   
6. AUL : AnySQL UnLoader(MyDUL) for Oracle 8/8i/9i/10g/11g, release 5.1.4
   
7. 
   
8. (C) Copyright Lou Fangxin 2005-2011 (AnySQL.net), all rights reserved.
   
9. 
   
10. AUL> open auldemo.cfg
    
11. * ts# fno rfn ver bsize blocks filename
    
12. - ---- ---- ---- --- ----- ---------- -----------------------------------
    
13. Y 0 1 1 a2 8192 87040 F:\APP\ADMINISTRATOR\ORADATA\ORCL\SYSTEM01.DBF
    
14. 
    
15. AUL> UNLOAD TABLE USER$;
    
16. 2014-02-16 16:58:09
    
17. 2014-02-16 16:58:09
    
18. AUL> UNLOAD TABLE OBJ$;
    
19. 2014-02-16 16:58:17
    
20. 2014-02-16 16:58:19
    
21. AUL> UNLOAD TABLE TAB$
    
22.    2 ;
    
23. 2014-02-16 16:59:16
    
24. 2014-02-16 16:59:17
    
25. 
    
26. AUL> UNLOAD TABLE COL$;
    
27. 2014-02-16 17:00:55
    
28. 2014-02-16 17:00:57
    
29. 
    
30. AUL> desc sys.undo$;
    
31. 
    
32. Storage(OBJ#=15 OBJD=15 TS=0 FILE=1 BLOCK=224 CLUSTER=0)
    
33. No. SEQ INT Column Name Type
    
34. --- --- --- ----------------------------- ----------------
    
35.   1 1 1 US# NUMBER NOT NULL
    
36.   2 2 2 NAME VARCHAR2(30) NOT NULL
    
37.   3 3 3 USER# NUMBER NOT NULL
    
38.   4 4 4 FILE# NUMBER NOT NULL
    
39.   5 5 5 BLOCK# NUMBER NOT NULL
    
40.   6 6 6 SCNBAS NUMBER
    
41.   7 7 7 SCNWRP NUMBER
    
42.   8 8 8 XACTSQN NUMBER
    
43.   9 9 9 UNDOSQN NUMBER
    
44.  10 10 10 INST# NUMBER
    
45.  11 11 11 STATUS$ NUMBER NOT NULL
    
46.  12 12 12 TS# NUMBER
    
47.  13 13 13 UGRP# NUMBER
    
48.  14 14 14 KEEP NUMBER
    
49.  15 15 15 OPTIMAL NUMBER
    
50.  16 16 16 FLAGS NUMBER
    
51.  17 17 17 SPARE1 NUMBER
    
52.  18 18 18 SPARE2 NUMBER
    
53.  19 19 19 SPARE3 NUMBER
    
54.  20 20 20 SPARE4 VARCHAR2(1000)
    
55.  21 21 21 SPARE5 VARCHAR2(1000)
    
56.  22 22 22 SPARE6 DATE
    
57. 
    
58. AUL> UNLOAD TABLE SYS.UNDO$;  --已经挖取出来
    
59. 2014-02-16 17:02:30
    
60. Unload OBJD=15 FILE=1 BLOCK=224 CLUSTER=0 ...
    
61. 0|SYSTEM|0|1|128|0|0|0|0|0|3|0|||||0
    
62. 1|_SYSSMU1_3086899707$|1|3|128|1045335|0|637|204|0|3|2|||||2
    
63. 2|_SYSSMU2_1531987058$|1|3|144|1045396|0|752|135|0|3|2|||||2
    
64. 3|_SYSSMU3_478608968$|1|3|160|1045392|0|812|216|0|3|2|||||2
    
65. 4|_SYSSMU4_1451910634$|1|3|176|1045337|0|562|155|0|3|2|||||2
    
66. 5|_SYSSMU5_2520346804$|1|3|192|1045317|0|786|141|0|3|2|||||2
    
67. 6|_SYSSMU6_1439239625$|1|3|208|1045404|0|766|124|0|3|2|||||2
    
68. 7|_SYSSMU7_1101470402$|1|3|224|1045402|0|573|200|0|3|2|||||2
    
69. 8|_SYSSMU8_1682283174$|1|3|240|1045332|0|942|135|0|3|2|||||2
    
70. 9|_SYSSMU9_3186340089$|1|3|256|1045354|0|754|144|0|3|2|||||2
    
71. 10|_SYSSMU10_378818850$|1|3|272|1045398|0|600|99|0|3|2|||||2
    
72. 11|_SYSSMU11_1398542477$|1|5|128|945016|0|2|1|0|1|5|||||2
    
73. 12|_SYSSMU12_1493912138$|1|5|144|944662|0|2|1|0|1|5|||||2
    
74. 13|_SYSSMU13_2531751786$|1|5|160|0|0|1|1|0|1|5|||||2
    
75. 14|_SYSSMU14_1552961453$|1|5|176|944673|0|2|1|0|1|5|||||2
    
76. 15|_SYSSMU15_457989160$|1|5|192|944658|0|2|1|0|1|5|||||2
    
77. 16|_SYSSMU16_2025364313$|1|5|208|0|0|1|1|0|1|5|||||2
    
78. 17|_SYSSMU17_3520270026$|1|5|224|944670|0|2|1|0|1|5|||||2
    
79. 18|_SYSSMU18_4278963515$|1|5|240|944652|0|2|1|0|1|5|||||2
    
80. 19|_SYSSMU19_1252467289$|1|5|256|944633|0|2|1|0|1|5|||||2
    
81. 20|_SYSSMU20_2990673235$|1|5|272|944630|0|2|1|0|1|5|||||2
    
82. Sucessfully unload 21 rows ...
    
83. 2014-02-16 17:02:30
    
84. AUL>

至此挖取出来。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29477587/viewspace-1082218/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29477587/viewspace-1082218/