Oracle 9201的控制文件內容列表：
控制文件頭...
數據庫項...
檢查點進度記錄（該項從Oracle8開始引入）...
擴展的數據庫項（該項從Oracle9i開始引入）...
重做線程項...
日志文件項...
數據文件項...
臨時文件記錄項（該項從Oracle9i開始引入）...
表空間記錄項（該項從Oracle8開始引入）...
Rman配置記錄項（該項從Oracle9i開始引入）...
日志文件歷史記錄項...
脫機范圍記錄項（該項從Oracle8開始引入）...
歸檔日志記錄項（該項從Oracle8開始引入）...
使用Rman備份數據庫的備份集記錄項（該項從Oracle8開始引入）...
使用Rman備份數據庫的備份片記錄項（該項從Oracle8開始引入）...
使用Rman備份數據庫的備份數據文件的記錄項（該項從Oracle8開始引入）...
使用Rman備份數據庫的備份歸檔日志文件的記錄項（該項從Oracle8開始引入）...
使用Rman備份數據庫時數據文件拷貝的記錄項（該項從Oracle8開始引入）...
使用Rman備份數據庫的備份數據文件損壞記錄項（該項從Oracle8開始引入）...
使用Rman備份數據庫的數據文件拷貝損壞記錄項（該項從Oracle8開始引入）...
使用Rman備份數據庫的刪除記錄（該項從Oracle8開始引入）...
使用Rman備份數據庫的代理拷貝記錄項（該項從Oracle8i開始引入）...
INCARNATION RECORDS（該項從Oracle9i開始引入）...
第1行到第22行的內容為控制文件的頭信息，這部分內容的解釋參見《轉儲控制文件頭》。
控制文件頭
1. Dump file e:/oracle/admin/test/udump/test_ora_376.trc
2. Fri May 14 15:09:52 2004
3. ORACLE V9.2.0.1.0 - PRodUCtion vsnsta=0
4. vsnsql=12 vsnxtr=3
5. windows 2000 Version 5.0 Service Pack 4, CPU type 586
6. Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
7. With the Partitioning, OLAP and Oracle Data Mining options
8. JServer Release 9.2.0.1.0 - Production
9. Windows 2000 Version 5.0 Service Pack 4, CPU type 586
10. Instance name: test
11. Redo thread mounted by this instance: 1
12. Oracle process number: 13
13. Windows thread id: 376, image: ORACLE.EXE
14. *** 2004-05-14 15:09:52.000
15. *** session ID:(10.21) 2004-05-14 15:09:52.000
16. DUMP OF CONTROL FILES, Seq # 2929 = 0xb71
＝＝＝＝＝＝＝第17行到第22行為通用文件頭＝＝＝＝＝＝＝＝
17.FILE HEADER:
18. Software vsn=153092096=0x9200000, Compatibility Vsn=134217728=0x8000000
19. Db ID=1750352942=0x6854442e, Db Name='TEST1'
20. Activation ID=0=0x0
21. Control Seq=2929=0xb71, File size=228=0xe4
22. File Number=0, Blksiz=8192, File Type=1 CONTROL
**************************控制文件頭信息結束****************************
數據庫項
23.**********************************************************************
24.DATABASE ENTRY
25.**********************************************************************
26. (blkno = 0x1, size = 192, max = 1, in-use = 1, last-recid= 0)
blkno
size指出數據庫項的字節數，本例中為192byte;
max指出最大的塊
in-use當前正在使用的塊
last-recid
27. DF Version: creation=0x9200000 compatible=0x8000000, Date 07/13/2003 14:30:51
數據文件的版本是9.2.0，兼容版本是8.0
28. DB Name "TEST1"
數據庫名為"TEST1"
29. Database flags = 0x00404001
30. Controlfile Creation Timestamp 07/13/2003 14:30:52
控制文件的創建時間
31. Incmplt recovery scn: 0x0000.00000000
假如數據庫進行過不完全回復，我們可以看出
32. Resetlogs scn: 0x0000.04ada796 Resetlogs Timestamp 07/13/2003 14:34:39
啟用Resetlogs時的scn值和時戳，
33. Prior resetlogs scn: 0x0000.04a0b855 Prior resetlogs Timestamp 04/11/2003 09:59:18
啟用Resetlogs之前的scn值和時戳
Oracle不能夠應用Resetlogs之前的重做日志（redo log file）。
34. Redo Version: creation=0x9200000 compatable=0x9200000
重做日志文件的版本是9.2.0，兼容版本是8.0
35. #Data files = 12, #Online files = 12
數據庫總共有12個數據文件，并且這12個文件全部處在聯機（online）狀態
36. Database checkpoint: Thread=1 scn: 0x0000.04b9d858
37. Threads: #Enabled=1, #Open=1, Head=1, Tail=1
當前啟用了一個線程，當然，也僅僅打開了這一個線程
38. enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
39. Max log members = 3, Max data members = 1
數據庫答應每個日志組最多有3個log member；
Oracle目前還不支持數據文件的多路復用，因此，Max data members的值為1，這個條目是為以后的版本升級而預留的。
40. Arch list: Head=3, Tail=3, Force scn: 0x0000.04b93016scn: 0x0000.04b9d857
請注重Force scn，凡是開始scn小于Force scn的重做都被歸檔。強制scn是所有重做都被歸檔的scn。
41. Controlfile Checkpointed at scn: 0x0000.04b9d85a 05/14/2004 08:37:00
當前控制文件Checkpointed時的scn為0x0000.04b9d85a？？？
42. thread:0 rba:(0x0.0.0)
43. enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
檢查點進度記錄（該項從Oracle8開始引入）
44.**********************************************************************
45.CHECKPOINT PROGRESS RECORDS
46. **********************************************************************
檢查點進度記錄這個條目是從Oracle 8開始出現在控制文件中的。該項目主要用來記錄緩沖區高速緩存的狀態，每個記錄占用控制文件的一個塊。
47. (blkno = 0x4, size = 104, max = 1, in-use = 1, last-recid= 0)
48. THREAD #1 - status:0x2 flags:0x0 dirty:15
線程信息，
49. low cache rba:(0x20.1f0.0) on disk rba:(0x20.204.0)
低速緩存rba（recovery block address）指出了在實例回復或者崩潰恢復中，需要恢復的重做開始值（即，重做日志文件中的一個塊地址）；
on disk rba是磁盤上的最高的重做值，在進行實力恢復應用重做的時候必須達到這個值。假如on disk rba
50. on disk scn: 0x0000.04b9f6e2 05/14/2004 15:06:42
on disk scn是on disk rba處的scn值
51. resetlogs scn: 0x0000.04ada796 07/13/2003 14:34:39
啟用Resetlogs時的scn值和時戳，和數據庫項中的相應條目是一致的
52. heartbeat: 526099342 mount id: 903127902
53. MTTR statistics status: 3
54. Init time: Avg: 23012858, Times measured: 3
55. File open time: Avg: 123550, Times measured: 43
56. Log block read time: Avg: 182, Times measured: 32758
57. Data block handling time: Avg: 22934, Times measured: 135
擴展的數據庫項（該項從Oracle9i開始引入）
58. ***********************************************************************
59. EXTENDED DATABASE ENTRY
60. ***********************************************************************
61. (blkno = 0x71, size = 276, max = 1, in-use = 1, last-recid= 0)
62. Control AutoBackup date(dd/mm/yyyy)=13/ 7/2003
63. Next AutoBackup sequence= 0
重做線程項
64.**********************************************************************
65.REDO THREAD RECORDS
66.**********************************************************************
67. (blkno = 0x4, size = 104, max = 1, in-use = 1, last-recid= 0)
68. THREAD #1 - status:0xf thread links forward:0 back:0
69. #logs:4 first:1 last:4 current:3 last used seq#:0x20
這個條目說明數據庫中總共有4個日志文件組，第一個組為log #1（log group 1）；最后一個組為log #4（log group 4），當前正在使用的是log #3（log group 3）
70. enabled at scn: 0x0000.04ada796 07/13/2003 14:34:39
啟用線程1時的scn值
71. disabled at scn: 0x0000.00000000 01/01/1988 00:00:00
禁用線程1時的scn值，因為該線程目前處于打開狀態，所以該值為無窮大
72. opened at 05/14/2004 08:36:59 by instance test
打開線程的時戳，當前線程以及被哪個實例打開
73. Checkpointed at scn: 0x0000.04b9d858 05/14/2004 08:36:59
74. thread:1 rba:(0x20.2.10)
75. enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000
76. 00000000 00000000
77. log history: 31
日志文件項
78.**********************************************************************
79.LOG FILE RECORDS
80.**********************************************************************
81. (blkno = 0x5, size = 72, max = 5, in-use = 4, last-recid= 4)
82.LOG FILE #1:
83. (name #5) E:/ORACLE/ORA92/TEST/REDO01.LOG
84. Thread 1 redo log links: forward: 2 backward: 0
LOG FILE #1寫滿后，會切換到forward: 2，即切換到LOG FILE #2，這一點可以通過LOG FILE #1的Next scn: 0x0000.04b9870a等于LOG FILE #2的Low scn: 0x0000.04b9870a
85. siz: 0xf000 seq: 0x0000001e hws: 0x6 bsz: 512 nab: 0x15b flg: 0x1 dup: 1
nab是日志文件中LGWR可用的下一個數據塊的地址，假如這個值是無窮大，說明這個日志文件是當前（LGWR正在寫入）的日志文件
86. Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.04b8b9ad
87. Low scn: 0x0000.04b93016 05/13/2004 16:31:24
日志發生切換時會分配一個低scn和一個高scn，低scn就是上一個日志的高scn的值，而高scn則設置為無窮大，直到切換到下一個日志文件時，再將當前日志的高scn設置為下一個日志文件的低scn，將下一個日志文件的高scn設置為無窮大。
88. Next scn: 0x0000.04b9870a 05/13/2004 19:43:45
日志發生切換后，高scn就從無窮大該為Next scn（下一個scn）的值，該值將作為切換后的日志文件的低scn
89.LOG FILE #2:
90. (name #4) E:/ORACLE/ORA92/TEST/REDO02.LOG
91. Thread 1 redo log links: forward: 3 backward: 1
92. siz: 0xf000 seq: 0x0000001f hws: 0x5 bsz: 512 nab: 0x133 flg: 0x1 dup: 1
93. Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.04b93016
94. Low scn: 0x0000.04b9870a 05/13/2004 19:43:45
95. Next scn: 0x0000.04b9d857 05/14/2004 08:36:59
96.LOG FILE #3:
97. (name #3) E:/ORACLE/ORA92/TEST/REDO03.LOG
98. Thread 1 redo log links: forward: 4 backward: 2
99. siz: 0xf000 seq: 0x00000020 hws: 0x2 bsz: 512 nab: 0xffffffff flg: 0x8 dup: 1
100.Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.04b9870a
101.Low scn: 0x0000.04b9d857 05/14/2004 08:36:59
102.Next scn: 0xffff.ffffffff 01/01/1988 00:00:00
說明，LOG FILE #3是當前日志文件（LGWR正在寫入的日志文件）
103. LOG FILE #4:
104.(name #1) E:/ORACLE/ORA92/TEST/REDO04A.LOG
105.(name #2) E:/ORACLE/ORA92/TEST/REDO04B.LOG
106.Thread 1 redo log links: forward: 0 backward: 3
107.siz: 0x800 seq: 0x0000001d hws: 0xa bsz: 512 nab: 0x427 flg: 0x1 dup: 2
108.Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.04b854e4
109.Low scn: 0x0000.04b8b9ad 05/11/2004 14:27:28
110.Next scn: 0x0000.04b93016 05/13/2004 16:31:24
數據文件項
111. ******************************************************************
112. DATA FILE RECORDS
113. ******************************************************************
114.(blkno = 0x6, size = 180, max = 100, in-use = 14, last-recid= 41)
115. DATA FILE #1:
116.(name #17) E:/ORACLE/ORA92/TEST YSTEM01.DBF
117.creation size=0 block size=8192 status=0xe head=17 tail=17 dup=1
118.tablespace 0, index=1 krfil=1 prev_file=0
說明是系統表空間
119.unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
120.Checkpoint cnt:701 scn: 0x0000.04b9d858 05/14/2004 08:36:59
對該文件執行檢查點的次數為701（文件處于熱備狀態時，假如發生了檢查點，檢查點計數器（Checkpoint cnt）也還是加一）；
121.Stop scn: 0xffff.ffffffff 05/13/2004 20:18:03
結束scn（Stop scn）是數據文件的最后一個scn（數據庫正常關閉時會設置這個值），數據庫正常打開的狀態，該值為無窮大。數據庫恢復時要求恢復到Stop scn。
122.Creation Checkpointed at scn: 0x0000.00000014 01/13/2002 22:01:17
當時用“alter database create datafile”命令恢復數據文件時（該命令從Oracle7開始引入），需要依據文件創建時的檢查點scn（Creation Checkpointed at scn）。
123.thread:0 rba:(0x0.0.0)
124.enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
125. Offline scn: 0x0000.04ada795 prev_range: 0
當文件脫機時，文件脫機時的scn作為脫機scn保存在控制文件中
126.Online Checkpointed at scn: 0x0000.04ada796 07/13/2003 14:34:39
當文件聯機時，文件聯機時的檢查點scn作為聯機scn保存在控制文件中
由于系統表空間的數據文件永遠不能脫機，所以系統數據文件的脫機scn應該為0x0000.00000000
猜想，這里的Offline scn表示數據庫上一次正常關閉時數據文件的檢查點scn；
這里的Online Checkpointed at scn表示數據庫本次打開時的數據文件的檢查點scn
127.thread:1 rba:(0x1.2.0)
128.enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
129.Hot Backup end marker scn: 0x0000.00000000
熱備時的scn
130.aux_file is NOT DEFINED
131. DATA FILE #2:
132.(name #16) E:/ORACLE/ORA92/TEST/UNDOTBS01.DBF
133.creation size=0 block size=8192 status=0xe head=16 tail=16 dup=1
134.tablespace 1, index=2 krfil=2 prev_file=0
135.unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
136.Checkpoint cnt:640 scn: 0x0000.04b9d858 05/14/2004 08:36:59
137.Stop scn: 0xffff.ffffffff 05/13/2004 20:18:03
138.Creation Checkpointed at scn: 0x0000.0002f401 01/14/2002 22:24:49
139.thread:0 rba:(0x0.0.0)
140.enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000
141.00000000 00000000
142.Offline scn: 0x0000.04ada795 prev_range: 0
143.Online Checkpointed at scn: 0x0000.04ada796 07/13/2003 14:34:39
144.thread:1 rba:(0x1.2.0)
145.enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000
146.00000000 00000000
147.Hot Backup end marker scn: 0x0000.00000000
148.aux_file is NOT DEFINED
149. DATA FILE #3:
150.(name #15) E:/ORACLE/ORA92/TEST/DRSYS01.DBF
151.creation size=0 block size=8192 status=0xe head=15 tail=15 dup=1
152.tablespace 3, index=3 krfil=3 prev_file=0
153.unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
154.Checkpoint cnt:699 scn: 0x0000.04b9d858 05/14/2004 08:36:59
155.Stop scn: 0xffff.ffffffff 05/13/2004 20:18:03
156.Creation Checkpointed at scn: 0x0000.00001882 01/13/2002 22:02:52
157.thread:0 rba:(0x0.0.0)
158.enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000
159.00000000 00000000
160.Offline scn: 0x0000.04ada795 prev_range: 0
161.Online Checkpointed at scn: 0x0000.04ada796 07/13/2003 14:34:39
162.thread:1 rba:(0x1.2.0)
163.enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000
164.00000000 00000000
165.Hot Backup end marker scn: 0x0000.00000000
166.aux_file is NOT DEFINED
167. DATA FILE #4:
168.(name #14) E:/ORACLE/ORA92/TEST/INDX01.DBF
169.creation size=0 block size=8192 status=0xe head=14 tail=14 dup=1
170.tablespace 4, index=4 krfil=4 prev_file=0
171.unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
172.Checkpoint cnt:699 scn: 0x0000.04b9d858 05/14/2004 08:36:59
173.Stop scn: 0xffff.ffffffff 05/13/2004 20:18:03
174.Creation Checkpointed at scn: 0x0000.00001895 01/13/2002 22:02:58
175.thread:0 rba:(0x0.0.0)
176.enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000
177.00000000 00000000
178.Offline scn: 0x0000.04ada795 prev_range: 0
179.Online Checkpointed at scn: 0x0000.04ada796 07/13/2003 14:34:39
180.thread:1 rba:(0x1.2.0)
181.enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000
182.00000000 00000000
183.Hot Backup end marker scn: 0x0000.00000000
184.aux_file is NOT DEFINED
185. DATA FILE #5:
186.(name #13) E:/ORACLE/ORA92/TEST/TOOLS01.DBF
187.creation size=0 block size=8192 status=0xe head=13 tail=13 dup=1
188.tablespace 5, index=5 krfil=5 prev_file=0
189.unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
190.Checkpoint cnt:699 scn: 0x0000.04b9d858 05/14/2004 08:36:59
191.Stop scn: 0xffff.ffffffff 05/13/2004 20:18:03
192.Creation Checkpointed at scn: 0x0000.000018a6 01/13/2002 22:03:03
193.thread:0 rba:(0x0.0.0)
194.enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000
195.00000000 00000000
196.Offline scn: 0x0000.04ada795 prev_range: 0
197.Online Checkpointed at scn: 0x0000.04ada796 07/13/2003 14:34:39
198.thread:1 rba:(0x1.2.0)
199.enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000
200.00000000 00000000
201.Hot Backup end marker scn: 0x0000.00000000
202.aux_file is NOT DEFINED
203. DATA FILE #6:
204.(name #12) E:/ORACLE/ORA92/TEST/USERS01.DBF
205.creation size=0 block size=8192 status=0xe head=12 tail=12 dup=1
206.tablespace 6, index=6 krfil=6 prev_file=0
207.unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
208.Checkpoint cnt:702 scn: 0x0000.04b9d858 05/14/2004 08:36:59
209.Stop scn: 0xffff.ffffffff 05/13/2004 20:18:03
210.Creation Checkpointed at scn: 0x0000.000018b7 01/13/2002 22:03:09
211.thread:0 rba:(0x0.0.0)
212.enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000
213.00000000 00000000
214.Offline scn: 0x0000.04ada795 prev_range: 0
215.Online Checkpointed at scn: 0x0000.04ada796 07/13/2003 14:34:39
216.thread:1 rba:(0x1.2.0)
217.enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000
218.00000000 00000000
219.Hot Backup end marker scn: 0x0000.00000000
220.aux_file is NOT DEFINED
221. DATA FILE #7:
222.(name #11) E:/ORACLE/ORA92/TEST/XDB01.DBF
223.creation size=0 block size=8192 status=0xe head=11 tail=11 dup=1
224.tablespace 7, index=7 krfil=7 prev_file=0
225.unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
226.Checkpoint cnt:698 scn: 0x0000.04b9d858 05/14/2004 08:36:59
227.Stop scn: 0xffff.ffffffff 05/13/2004 20:18:03
228.Creation Checkpointed at scn: 0x0000.000018cc 01/13/2002 22:03:18
229.thread:0 rba:(0x0.0.0)
230.enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000
231.00000000 00000000
232.Offline scn: 0x0000.04ada795 prev_range: 0
233.Online Checkpointed at scn: 0x0000.04ada796 07/13/2003 14:34:39
234.thread:1 rba:(0x1.2.0)
235.enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000
236.00000000 00000000
237.Hot Backup end marker scn: 0x0000.00000000
238.aux_file is NOT DEFINED
239. DATA FILE #8:
240.(name #10) E:/ORACLE/ORA92/TEST/TEST01.DBF
241.creation size=0 block size=8192 status=0xe head=10 tail=10 dup=1
242.tablespace 11, index=8 krfil=8 prev_file=0
243.unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
244.Checkpoint cnt:356 scn: 0x0000.04b9d858 05/14/2004 08:36:59
245.Stop scn: 0xffff.ffffffff 05/13/2004 20:18:03
246.Creation Checkpointed at scn: 0x0000.0011a40e 02/06/2003 16:25:09
247.thread:0 rba:(0x0.0.0)
248.enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000
249.00000000 00000000
250.Offline scn: 0x0000.04ada795 prev_range: 0
251.Online Checkpointed at scn: 0x0000.04ada796 07/13/2003 14:34:39
252.thread:1 rba:(0x1.2.0)
253.enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000
254.00000000 00000000
255.Hot Backup end marker scn: 0x0000.00000000
256.aux_file is NOT DEFINED
257. DATA FILE #9:
258.(name #9) E:/ORACLE/ORA92/TEST/RMAN01.DBF
259.creation size=0 block size=8192 status=0xe head=9 tail=9 dup=1
260.tablespace 9, index=9 krfil=9 prev_file=0
261.unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
262.Checkpoint cnt:576 scn: 0x0000.04b9d858 05/14/2004 08:36:59
263.Stop scn: 0xffff.ffffffff 05/13/2004 20:18:03
264.Creation Checkpointed at scn: 0x0000.0009f9ce 01/24/2002 17:23:42
265.thread:0 rba:(0x0.0.0)
266.enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000
267.00000000 00000000
268.Offline scn: 0x0000.04ada795 prev_range: 0
269.Online Checkpointed at scn: 0x0000.04ada796 07/13/2003 14:34:39
270.thread:1 rba:(0x1.2.0)
271.enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000
272.00000000 00000000
273.Hot Backup end marker scn: 0x0000.00000000
274.aux_file is NOT DEFINED
275. DATA FILE #10:
276.(name #8) E:/ORACLE/ORA92/TEST/PERFSTAT01.DBF
277.creation size=0 block size=8192 status=0xe head=8 tail=8 dup=1
278.tablespace 12, index=10 krfil=10 prev_file=0
279.unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
280.Checkpoint cnt:253 scn: 0x0000.04b9d858 05/14/2004 08:36:59
281.Stop scn: 0xffff.ffffffff 05/13/2004 20:18:03
282.Creation Checkpointed at scn: 0x0000.00199caf 03/03/2003 19:55:07
283.thread:0 rba:(0x0.0.0)
284.enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000
285.00000000 00000000
286.Offline scn: 0x0000.04ada795 prev_range: 0
287.Online Checkpointed at scn: 0x0000.04ada796 07/13/2003 14:34:39
288.thread:1 rba:(0x1.2.0)
289.enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000
290.00000000 00000000
291.Hot Backup end marker scn: 0x0000.00000000
292.aux_file is NOT DEFINED
293. DATA FILE #11:
294.(name #7) E:/ORACLE/ORA92/TEST/UNDOTBS02.DBF
295.creation size=0 block size=8192 status=0xe head=7 tail=7 dup=1
296.tablespace 8, index=11 krfil=11 prev_file=0
297.unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
298.Checkpoint cnt:237 scn: 0x0000.04b9d858 05/14/2004 08:36:59
299.Stop scn: 0xffff.ffffffff 05/13/2004 20:18:03
300.Creation Checkpointed at scn: 0x0000.049f6bf8 03/27/2003 09:48:22
301.thread:0 rba:(0x0.0.0)
302.enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000
303.00000000 00000000
304.Offline scn: 0x0000.04ada795 prev_range: 0
305.Online Checkpointed at scn: 0x0000.04ada796 07/13/2003 14:34:39
306.thread:1 rba:(0x1.2.0)
307.enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000
308.00000000 00000000
309.Hot Backup end marker scn: 0x0000.00000000
310.aux_file is NOT DEFINED
311. DATA FILE #12: <deleted>
312.creation size=1280 block size=8192 status=0x800 head=0 tail=0 dup=0
313.tablespace 18, index=14 krfil=12 prev_file=0
314.unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
315.Checkpoint cnt:3 scn: 0x0000.04b7e874 05/10/2004 16:45:12
316.Stop scn: 0x0000.04b7e874 05/10/2004 16:45:12
317.Creation Checkpointed at scn: 0x0000.04b7e496 05/10/2004 16:04:32
318.thread:1 rba:(0x1a.17d.10)
319.enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000
320.00000000 00000000
321.Offline scn: 0x0000.00000000 prev_range: 0
322.Online Checkpointed at scn: 0x0000.00000000
323.thread:0 rba:(0x0.0.0)
324.enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000
325.00000000 00000000
326.Hot Backup end marker scn: 0x0000.00000000
327.aux_file is NOT DEFINED
328. DATA FILE #13: <deleted>
329.creation size=0 block size=0 status=0x0 head=0 tail=0 dup=0
330.tablespace 0, index=0 krfil=0 prev_file=0
331.unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
332.Checkpoint cnt:0 scn: 0x0000.00000000 01/01/1988 00:00:00
333.Stop scn: 0x0000.00000000 01/01/1988 00:00:00
334.Creation Checkpointed at scn: 0x0000.00000000
335.thread:0 rba:(0x0.0.0)
336.enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000
337.00000000 00000000
338.Offline scn: 0x0000.00000000 prev_range: 0
339.Online Checkpointed at scn: 0x0000.00000000
340.thread:0 rba:(0x0.0.0)
341.enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000
342.00000000 00000000
343.Hot Backup end marker scn: 0x0000.00000000
344.aux_file=0
345. DATA FILE #14:
346.(name #6) E:/ORACLE/ORA92/TEST/XPRT01.DBF
347.creation size=0 block size=8192 status=0xe head=6 tail=6 dup=1
348.tablespace 16, index=12 krfil=14 prev_file=0
349.unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
350.Checkpoint cnt:187 scn: 0x0000.04b9d858 05/14/2004 08:36:59
351.Stop scn: 0xffff.ffffffff 05/13/2004 20:18:03
352.Creation Checkpointed at scn: 0x0000.04a3fd9c 05/28/2003 15:06:11
353.thread:0 rba:(0x0.0.0)
354.enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000
355.00000000 00000000
356.Offline scn: 0x0000.04ada795 prev_range: 0
357.Online Checkpointed at scn: 0x0000.04ada796 07/13/2003 14:34:39
358.thread:1 rba:(0x1.2.0)
359.enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000
360.00000000 00000000
361.Hot Backup end marker scn: 0x0000.00000000
362.aux_file is NOT DEFINED
臨時文件記錄項（該項從Oracle9i開始引入）
363. ******************************************************************
364. TEMP FILE RECORDS
365. ******************************************************************
366.(blkno = 0x12, size = 56, max = 100, in-use = 1, last-recid= 1)
367.TEMP FILE #1: External File #201
368.(name #18) E:/ORACLE/ORA92/TEST/TEMP.DBF
369.creation size=2560 block size=8192 status=0xe head=18 tail=18 dup=1
370.tablespace 2, index=13 krfil=1 prev_file=0
371.unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
表空間記錄項（該項從Oracle8開始引入）
372. ******************************************************************
373. TABLESPACE RECORDS
374. ******************************************************************
375.(blkno = 0x11, size = 68, max = 100, in-use = 16, last-recid= 9)
376.TABLESPACE #0 SYSTEM: recno=1
377.First datafile link=1 Tablespace Flag=0
378.Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00
379.Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00
380.TABLESPACE #1 UNDOTBS1: recno=2
381.First datafile link=2 Tablespace Flag=0
382.Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00
383.Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00
384.TABLESPACE #3 DRSYS: recno=3
385.First datafile link=3 Tablespace Flag=0
386.Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00
387.Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00
388.TABLESPACE #4 INDX: recno=4
389.First datafile link=4 Tablespace Flag=0
390.Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00
391.Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00
392.TABLESPACE #5 TOOLS: recno=5
393.First datafile link=5 Tablespace Flag=0
394.Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00
395.Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00
396.TABLESPACE #6 USERS: recno=6
397.First datafile link=6 Tablespace Flag=0
398.Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00
399.Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00
400.TABLESPACE #7 XDB: recno=7
401.First datafile link=7 Tablespace Flag=0
402.Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00
403.Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00
404.TABLESPACE #11 TEST: recno=8
405.First datafile link=8 Tablespace Flag=0
406.Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00
407.Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00
408.TABLESPACE #9 RMAN: recno=9
409.First datafile link=9 Tablespace Flag=0
410.Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00
411.Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00
412.TABLESPACE #12 PERFSTAT: recno=10
413.First datafile link=10 Tablespace Flag=0
414.Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00
415.Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00
416.TABLESPACE #8 UNDOTBS2: recno=11
417.First datafile link=11 Tablespace Flag=0
418.Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00
419.Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00
420.TABLESPACE #16 XPRT: recno=12
421.First datafile link=14 Tablespace Flag=0
422.Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00
423.Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00
424.TABLESPACE #2 TEMP: recno=13
425.First datafile link=1 Tablespace Flag=1
426.Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00
427.Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00
428.TABLESPACE #2147483647 UNDO_TEST: recno=14
429.First datafile link=0 Tablespace Flag=0
430.Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00
431.Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00
432.TABLESPACE #2147483647 SORT: recno=15
433.First datafile link=0 Tablespace Flag=1
434.Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00
435.Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00
436.TABLESPACE #2147483647 LUNARTEMP: recno=16
437.First datafile link=0 Tablespace Flag=1
438.Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00
439.Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00
Rman配置記錄項（該項從Oracle9i開始引入）
440. ******************************************************************
441. RMAN CONFIGURATION RECORDS
442. ******************************************************************
443.(blkno = 0x13, size = 1108, max = 50, in-use = 0, last-recid= 0)
日志文件歷史記錄項
444. ******************************************************************
445. LOG FILE HISTORY RECORDS
446. ******************************************************************
447.(blkno = 0x1a, size = 36, max = 226, in-use = 31, last-recid= 31)
448.Earliest record:
449.RECID #1 Recno 1 Record timestamp 07/20/03 09:30:37 Thread=1 Seq#=1 Link-Recid=0
450.Low scn: 0x0000.04ada796 07/13/03 14:34:39 Next scn: 0x0000.04ae05fb
451.Latest record:
452.RECID #31 Recno 31 Record timestamp 05/14/04 08:36:59 Thread=1 Seq#=31 Link-Recid=30
453.Low scn: 0x0000.04b9870a 05/13/04 19:43:45 Next scn: 0x0000.04b9d857
454.RECID #30 Recno 30 Record timestamp 05/13/04 19:43:45 Thread=1 Seq#=30 Link-Recid=29
455.Low scn: 0x0000.04b93016 05/13/04 16:31:24 Next scn: 0x0000.04b9870a
456.RECID #29 Recno 29 Record timestamp 05/13/04 16:31:24 Thread=1 Seq#=29 Link-Recid=28
457.Low scn: 0x0000.04b8b9ad 05/11/04 14:27:28 Next scn: 0x0000.04b93016
458.RECID #28 Recno 28 Record timestamp 05/11/04 14:27:29 Thread=1 Seq#=28 Link-Recid=27
459.Low scn: 0x0000.04b854e4 05/11/04 08:14:52 Next scn: 0x0000.04b8b9ad
460.RECID #27 Recno 27 Record timestamp 05/11/04 08:14:52 Thread=1 Seq#=27 Link-Recid=26
461.Low scn: 0x0000.04b7efc3 05/10/04 18:00:17 Next scn: 0x0000.04b854e4
462.RECID #26 Recno 26 Record timestamp 05/10/04 18:00:17 Thread=1 Seq#=26 Link-Recid=25
463.Low scn: 0x0000.04b7d716 05/10/04 13:16:04 Next scn: 0x0000.04b7efc3
464.RECID #25 Recno 25 Record timestamp 05/10/04 13:16:05 Thread=1 Seq#=25 Link-Recid=24
465.Low scn: 0x0000.04b759e6 05/09/04 08:41:38 Next scn: 0x0000.04b7d716
466.RECID #24 Recno 24 Record timestamp 05/09/04 08:41:38 Thread=1 Seq#=24 Link-Recid=23
467.Low scn: 0x0000.04b6d74d 05/08/04 09:45:10 Next scn: 0x0000.04b759e6
468.RECID #23 Recno 23 Record timestamp 05/08/04 09:45:10 Thread=1 Seq#=23 Link-Recid=22
469.Low scn: 0x0000.04b67d98 05/02/04 15:36:17 Next scn: 0x0000.04b6d74d
470.RECID #22 Recno 22 Record timestamp 05/02/04 15:36:18 Thread=1 Seq#=22 Link-Recid=21
471.Low scn: 0x0000.04b62189 05/02/04 08:19:22 Next scn: 0x0000.04b67d98
472.RECID #21 Recno 21 Record timestamp 05/02/04 08:19:22 Thread=1 Seq#=21 Link-Recid=20
473.Low scn: 0x0000.04b5a5f0 04/30/04 07:32:34 Next scn: 0x0000.04b62189
474.RECID #20 Recno 20 Record timestamp 04/30/04 07:32:34 Thread=1 Seq#=20 Link-Recid=19
475.Low scn: 0x0000.04b551b5 04/29/04 17:10:52 Next scn: 0x0000.04b5a5f0
476.RECID #19 Recno 19 Record timestamp 04/29/04 17:10:52 Thread=1 Seq#=19 Link-Recid=18
477.Low scn: 0x0000.04b4dfcd 04/29/04 08:47:27 Next scn: 0x0000.04b551b5
478.RECID #18 Recno 18 Record timestamp 04/29/04 08:47:27 Thread=1 Seq#=18 Link-Recid=17
479.Low scn: 0x0000.04b47afe 04/28/04 15:47:36 Next scn: 0x0000.04b4dfcd
480.RECID #17 Recno 17 Record timestamp 04/28/04 15:47:36 Thread=1 Seq#=17 Link-Recid=16
481.Low scn: 0x0000.04b426a9 04/28/04 10:46:54 Next scn: 0x0000.04b47afe
482.RECID #16 Recno 16 Record timestamp 04/28/04 10:46:54 Thread=1 Seq#=16 Link-Recid=15
483.Low scn: 0x0000.04b3d745 04/28/04 10:24:23 Next scn: 0x0000.04b426a9
484.RECID #15 Recno 15 Record timestamp 04/28/04 10:24:24 Thread=1 Seq#=15 Link-Recid=14
485.Low scn: 0x0000.04b34c54 04/27/04 09:25:18 Next scn: 0x0000.04b3d745
486.RECID #14 Recno 14 Record timestamp 04/27/04 09:25:18 Thread=1 Seq#=14 Link-Recid=13
487.Low scn: 0x0000.04b2db02 04/17/04 11:54:17 Next scn: 0x0000.04b34c54
488.RECID #13 Recno 13 Record timestamp 04/17/04 11:54:17 Thread=1 Seq#=13 Link-Recid=12
489.Low scn: 0x0000.04b27786 04/16/04 19:06:32 Next scn: 0x0000.04b2db02
490.RECID #12 Recno 12 Record timestamp 04/16/04 19:06:32 Thread=1 Seq#=12 Link-Recid=11
491.Low scn: 0x0000.04b225c5 04/03/04 13:17:32 Next scn: 0x0000.04b27786
492.RECID #11 Recno 11 Record timestamp 04/03/04 13:17:32 Thread=1 Seq#=11 Link-Recid=10
493.Low scn: 0x0000.04b1caec 04/02/04 13:37:07 Next scn: 0x0000.04b225c5
494.RECID #10 Recno 10 Record timestamp 04/02/04 13:37:08 Thread=1 Seq#=10 Link-Recid=9
495.Low scn: 0x0000.04b1759e 02/27/04 13:42:16 Next scn: 0x0000.04b1caec
496.RECID #9 Recno 9 Record timestamp 02/27/04 13:42:16 Thread=1 Seq#=9 Link-Recid=8
497.Low scn: 0x0000.04b10a6b 02/14/04 10:34:55 Next scn: 0x0000.04b1759e
498.RECID #8 Recno 8 Record timestamp 02/14/04 10:34:55 Thread=1 Seq#=8 Link-Recid=7
499.Low scn: 0x0000.04b0a354 02/13/04 11:24:29 Next scn: 0x0000.04b10a6b
500.RECID #7 Recno 7 Record timestamp 02/13/04 11:24:29 Thread=1 Seq#=7 Link-Recid=6
501.Low scn: 0x0000.04b046f0 02/11/04 13:19:35 Next scn: 0x0000.04b0a354
502.RECID #6 Recno 6 Record timestamp 02/11/04 13:19:35 Thread=1 Seq#=6 Link-Recid=5
503.Low scn: 0x0000.04af02f4 10/08/03 08:53:42 Next scn: 0x0000.04b046f0
504.RECID #5 Recno 5 Record timestamp 10/08/03 08:53:42 Thread=1 Seq#=5 Link-Recid=4
505.Low scn: 0x0000.04aeadbb 08/08/03 15:15:38 Next scn: 0x0000.04af02f4
506.RECID #4 Recno 4 Record timestamp 08/08/03 15:15:38 Thread=1 Seq#=4 Link-Recid=3
507.Low scn: 0x0000.04ae599c 07/20/03 10:47:36 Next scn: 0x0000.04aeadbb
508.RECID #3 Recno 3 Record timestamp 07/20/03 10:47:36 Thread=1 Seq#=3 Link-Recid=2
509.Low scn: 0x0000.04ae07a9 07/20/03 09:43:05 Next scn: 0x0000.04ae599c
510.RECID #2 Recno 2 Record timestamp 07/20/03 09:43:05 Thread=1 Seq#=2 Link-Recid=1
511.Low scn: 0x0000.04ae05fb 07/20/03 09:30:37 Next scn: 0x0000.04ae07a9
512.RECID #1 Recno 1 Record timestamp 07/20/03 09:30:37 Thread=1 Seq#=1 Link-Recid=0
513.Low scn: 0x0000.04ada796 07/13/03 14:34:39 Next scn: 0x0000.04ae05fb
脫機范圍記錄項（該項從Oracle8開始引入）
514. ******************************************************************
515. OFFLINE RANGE RECORDS
516. ******************************************************************
517.(blkno = 0x1b, size = 56, max = 145, in-use = 0, last-recid= 0)
歸檔日志記錄項（該項從Oracle8開始引入）
518. ******************************************************************
519. ARCHIVED LOG RECORDS
520. ******************************************************************
521.(blkno = 0x1c, size = 584, max = 237, in-use = 31, last-recid= 31)
522.Earliest record:
523.RECID #1 Recno 1 Record timestamp 07/20/03 09:30:39 Thread=1 Seq#=1
524.Flags: <produced by archive Operation> <created by the ARCH process>
525.Resetlogs scn and time scn: 0x0000.04ada796 07/13/03 14:34:39
526.filename E:/ORACLE/ORADATA/TEST/ARCHIVE/1_1.ARC
527.Low scn: 0x0000.04ada796 07/13/03 14:34:39 Next scn: 0x0000.04ae05fb 07/20/03 09:30:37
528.Block count=608 Blocksize=512
529.Latest record:
530.RECID #31 Recno 31 Record timestamp 05/14/04 08:37:00 Thread=1 Seq#=31
531.Flags: <produced by archive operation> <created by the ARCH process>
532.Resetlogs scn and time scn: 0x0000.04ada796 07/13/03 14:34:39
533.filename E:/ORACLE/ORADATA/TEST/ARCHIVE/1_31.ARC
534.Low scn: 0x0000.04b9870a 05/13/04 19:43:45 Next scn: 0x0000.04b9d857 05/14/04 08:36:59
535.Block count=306 Blocksize=512
536.RECID #30 Recno 30 Record timestamp 05/13/04 19:43:47 Thread=1 Seq#=30
537.Flags: <produced by archive operation> <created by the ARCH process>
538.Resetlogs scn and time scn: 0x0000.04ada796 07/13/03 14:34:39
539.filename E:/ORACLE/ORADATA/TEST/ARCHIVE/1_30.ARC
540.Low scn: 0x0000.04b93016 05/13/04 16:31:24 Next scn: 0x0000.04b9870a 05/13/04 19:43:45
541.Block count=346 Blocksize=512
542.RECID #29 Recno 29 Record timestamp 05/13/04 16:31:26 Thread=1 Seq#=29
543.Flags: <produced by archive operation> <created by the ARCH process>
544.Resetlogs scn and time scn: 0x0000.04ada796 07/13/03 14:34:39
545.filename E:/ORACLE/ORADATA/TEST/ARCHIVE/1_29.ARC
546.Low scn: 0x0000.04b8b9ad 05/11/04 14:27:28 Next scn: 0x0000.04b93016 05/13/04 16:31:24
547.Block count=1062 Blocksize=512
548.RECID #28 Recno 28 Record timestamp 05/11/04 14:27:33 Thread=1 Seq#=28
549.Flags: <produced by archive operation> <created by the ARCH process>
550.Resetlogs scn and time scn: 0x0000.04ada796 07/13/03 14:34:39
551.filename E:/ORACLE/ORADATA/TEST/ARCHIVE/1_28.ARC
552.Low scn: 0x0000.04b854e4 05/11/04 08:14:52 Next scn: 0x0000.04b8b9ad 05/11/04 14:27:28
553.Block count=785 Blocksize=512
554.RECID #27 Recno 27 Record timestamp 05/11/04 08:15:01 Thread=1 Seq#=27
555.Flags: <produced by archive operation> <created by the ARCH process>
556.Resetlogs scn and time scn: 0x0000.04ada796 07/13/03 14:34:39
557.filename E:/ORACLE/ORADATA/TEST/ARCHIVE/1_27.ARC
558.Low scn: 0x0000.04b7efc3 05/10/04 18:00:17 Next scn: 0x0000.04b854e4 05/11/04 08:14:52
559.Block count=38044 Blocksize=512
560.RECID #26 Recno 26 Record timestamp 05/10/04 18:00:30 Thread=1 Seq#=26
561.Flags: <produced by archive operation> <created by the ARCH process>
562.Resetlogs scn and time scn: 0x0000.04ada796 07/13/03 14:34:39
563.filename E:/ORACLE/ORADATA/TEST/ARCHIVE/1_26.ARC
564.Low scn: 0x0000.04b7d716 05/10/04 13:16:04 Next scn: 0x0000.04b7efc3 05/10/04 18:00:17
565.Block count=61433 Blocksize=512
566.RECID #25 Recno 25 Record timestamp 05/10/04 13:16:07 Thread=1 Seq#=25
567.Flags: <produced by archive operation> <created by the ARCH process>
568.Resetlogs scn and time scn: 0x0000.04ada796 07/13/03 14:34:39
569.filename E:/ORACLE/ORADATA/TEST/ARCHIVE/1_25.ARC
570.Low scn: 0x0000.04b759e6 05/09/04 08:41:38 Next scn: 0x0000.04b7d716 05/10/04 13:16:04
571.Block count=909 Blocksize=512
572.RECID #24 Recno 24 Record timestamp 05/09/04 08:41:43 Thread=1 Seq#=24
573.Flags: <produced by archive operation> <created by the ARCH process>
574.Resetlogs scn and time scn: 0x0000.04ada796 07/13/03 14:34:39
575.filename E:/ORACLE/ORADATA/TEST/ARCHIVE/1_24.ARC
576.Low scn: 0x0000.04b6d74d 05/08/04 09:45:10 Next scn: 0x0000.04b759e6 05/09/04 08:41:38
577.Block count=21946 Blocksize=512
578.RECID #23 Recno 23 Record timestamp 05/08/04 09:45:14 Thread=1 Seq#=23
579.Flags: <produced by archive operation> <created by the ARCH process>
580.Resetlogs scn and time scn: 0x0000.04ada796 07/13/03 14:34:39
581.filename E:/ORACLE/ORADATA/TEST/ARCHIVE/1_23.ARC
582.Low scn: 0x0000.04b67d98 05/02/04 15:36:17 Next scn: 0x0000.04b6d74d 05/08/04 09:45:10
583.Block count=11872 Blocksize=512
584.RECID #22 Recno 22 Record timestamp 05/02/04 15:36:19 Thread=1 Seq#=22
585.Flags: <produced by archive operation> <created by the ARCH process>
586.Resetlogs scn and time scn: 0x0000.04ada796 07/13/03 14:34:39
587.filename E:/ORACLE/ORADATA/TEST/ARCHIVE/1_22.ARC
588.Low scn: 0x0000.04b62189 05/02/04 08:19:22 Next scn: 0x0000.04b67d98 05/02/04 15:36:17
589.Block count=373 Blocksize=512
590.RECID #21 Recno 21 Record timestamp 05/02/04 08:19:24 Thread=1 Seq#=21
591.Flags: <produced by archive operation> <created by the ARCH process>
592.Resetlogs scn and time scn: 0x0000.04ada796 07/13/03 14:34:39
593.filename E:/ORACLE/ORADATA/TEST/ARCHIVE/1_21.ARC
594.Low scn: 0x0000.04b5a5f0 04/30/04 07:32:34 Next scn: 0x0000.04b62189 05/02/04 08:19:22
595.Block count=645 Blocksize=512
596.RECID #20 Recno 20 Record timestamp 04/30/04 07:32:37 Thread=1 Seq#=20
597.Flags: <produced by archive operation> <created by the ARCH process>
598.Resetlogs scn and time scn: 0x0000.04ada796 07/13/03 14:34:39
599.filename E:/ORACLE/ORADATA/TEST/ARCHIVE/1_20.ARC
600.Low scn: 0x0000.04b551b5 04/29/04 17:10:52 Next scn: 0x0000.04b5a5f0 04/30/04 07:32:34
601.Block count=378 Blocksize=512
602.RECID #19 Recno 19 Record timestamp 04/29/04 17:10:54 Thread=1 Seq#=19
603.Flags: <produced by archive operation> <created by the ARCH process>
604.Resetlogs scn and time scn: 0x0000.04ada796 07/13/03 14:34:39
605.filename E:/ORACLE/ORADATA/TEST/ARCHIVE/1_19.ARC
606.Low scn: 0x0000.04b4dfcd 04/29/04 08:47:27 Next scn: 0x0000.04b551b5 04/29/04 17:10:52
607.Block count=711 Blocksize=512
608.RECID #18 Recno 18 Record timestamp 04/29/04 08:47:31 Thread=1 Seq#=18
609.Flags: <produced by archive operation> <created by the ARCH process>
610.Resetlogs scn and time scn: 0x0000.04ada796 07/13/03 14:34:39
611.filename E:/ORACLE/ORADATA/TEST/ARCHIVE/1_18.ARC
612.Low scn: 0x0000.04b47afe 04/28/04 15:47:36 Next scn: 0x0000.04b4dfcd 04/29/04 08:47:27
613.Block count=471 Blocksize=512
614.RECID #17 Recno 17 Record timestamp 04/28/04 15:47:38 Thread=1 Seq#=17
615.Flags: <produced by archive operation> <created by the ARCH process>
616.Resetlogs scn and time scn: 0x0000.04ada796 07/13/03 14:34:39
617.filename E:/ORACLE/ORADATA/TEST/ARCHIVE/1_17.ARC
618.Low scn: 0x0000.04b426a9 04/28/04 10:46:54 Next scn: 0x0000.04b47afe 04/28/04 15:47:36
619.Block count=336 Blocksize=512
620.RECID #16 Recno 16 Record timestamp 04/28/04 10:46:56 Thread=1 Seq#=16
621.Flags: <produced by archive operation> <created by the ARCH process>
622.Resetlogs scn and time scn: 0x0000.04ada796 07/13/03 14:34:39
623.filename E:/ORACLE/ORADATA/TEST/ARCHIVE/1_16.ARC
624.Low scn: 0x0000.04b3d745 04/28/04 10:24:23 Next scn: 0x0000.04b426a9 04/28/04 10:46:54
625.Block count=272 Blocksize=512
626.RECID #15 Recno 15 Record timestamp 04/28/04 10:24:26 Thread=1 Seq#=15
627.Flags: <produced by archive operation> <created by the ARCH process>
628.Resetlogs scn and time scn: 0x0000.04ada796 07/13/03 14:34:39
629.filename E:/ORACLE/ORADATA/TEST/ARCHIVE/1_15.ARC
630.Low scn: 0x0000.04b34c54 04/27/04 09:25:18 Next scn: 0x0000.04b3d745 04/28/04 10:24:23
631.Block count=755 Blocksize=512
632.RECID #14 Recno 14 Record timestamp 04/27/04 09:25:22 Thread=1 Seq#=14
633.Flags: <produced by archive operation> <created by the ARCH process>
634.Resetlogs scn and time scn: 0x0000.04ada796 07/13/03 14:34:39
635.filename E:/ORACLE/ORADATA/TEST/ARCHIVE/1_14.ARC
636.Low scn: 0x0000.04b2db02 04/17/04 11:54:17 Next scn: 0x0000.04b34c54 04/27/04 09:25:18
637.Block count=7292 Blocksize=512
638.RECID #13 Recno 13 Record timestamp 04/17/04 11:54:19 Thread=1 Seq#=13
639.Flags: <produced by archive operation> <created by the ARCH process>
640.Resetlogs scn and time scn: 0x0000.04ada796 07/13/03 14:34:39
641.filename E:/ORACLE/ORADATA/TEST/ARCHIVE/1_13.ARC
642.Low scn: 0x0000.04b27786 04/16/04 19:06:32 Next scn: 0x0000.04b2db02 04/17/04 11:54:17
643.Block count=414 Blocksize=512
644.RECID #12 Recno 12 Record timestamp 04/16/04 19:06:34 Thread=1 Seq#=12
645.Flags: <produced by archive operation> <created by the ARCH process>
646.Resetlogs scn and time scn: 0x0000.04ada796 07/13/03 14:34:39
647.filename E:/ORACLE/ORADATA/TEST/ARCHIVE/1_12.ARC
648.Low scn: 0x0000.04b225c5 04/03/04 13:17:32 Next scn: 0x0000.04b27786 04/16/04 19:06:32
649.Block count=285 Blocksize=512
650.RECID #11 Recno 11 Record timestamp 04/03/04 13:17:33 Thread=1 Seq#=11
651.Flags: <produced by archive operation> <created by the ARCH process>
652.Resetlogs scn and time scn: 0x0000.04ada796 07/13/03 14:34:39
653.filename E:/ORACLE/ORADATA/TEST/ARCHIVE/1_11.ARC
654.Low scn: 0x0000.04b1caec 04/02/04 13:37:07 Next scn: 0x0000.04b225c5 04/03/04 13:17:32
655.Block count=350 Blocksize=512
656.RECID #10 Recno 10 Record timestamp 04/02/04 13:37:09 Thread=1 Seq#=10
657.Flags: <produced by archive operation> <created by the ARCH process>
658.Resetlogs scn and time scn: 0x0000.04ada796 07/13/03 14:34:39
659.filename E:/ORACLE/ORADATA/TEST/ARCHIVE/1_10.ARC
660.Low scn: 0x0000.04b1759e 02/27/04 13:42:16 Next scn: 0x0000.04b1caec 04/02/04 13:37:07
661.Block count=305 Blocksize=512
662.RECID #9 Recno 9 Record timestamp 02/27/04 13:42:18 Thread=1 Seq#=9
663.Flags: <produced by archive operation> <created by the ARCH process>
664.Resetlogs scn and time scn: 0x0000.04ada796 07/13/03 14:34:39
665.filename E:/ORACLE/ORADATA/TEST/ARCHIVE/1_9.ARC
666.Low scn: 0x0000.04b10a6b 02/14/04 10:34:55 Next scn: 0x0000.04b1759e 02/27/04 13:42:16
667.Block count=683 Blocksize=512
668.RECID #8 Recno 8 Record timestamp 02/14/04 10:34:57 Thread=1 Seq#=8
669.Flags: <produced by archive operation> <created by the ARCH process>
670.Resetlogs scn and time scn: 0x0000.04ada796 07/13/03 14:34:39
671.filename E:/ORACLE/ORADATA/TEST/ARCHIVE/1_8.ARC
672.Low scn: 0x0000.04b0a354 02/13/04 11:24:29 Next scn: 0x0000.04b10a6b 02/14/04 10:34:55
673.Block count=466 Blocksize=512
674.RECID #7 Recno 7 Record timestamp 02/13/04 11:24:31 Thread=1 Seq#=7
675.Flags: <produced by archive operation> <created by the ARCH process>
676.Resetlogs scn and time scn: 0x0000.04ada796 07/13/03 14:34:39
677.filename E:/ORACLE/ORADATA/TEST/ARCHIVE/1_7.ARC
678.Low scn: 0x0000.04b046f0 02/11/04 13:19:35 Next scn: 0x0000.04b0a354 02/13/04 11:24:29
679.Block count=363 Blocksize=512
680.RECID #6 Recno 6 Record timestamp 02/11/04 13:19:37 Thread=1 Seq#=6
681.Flags: <produced by archive operation> <created by the ARCH process>
682.Resetlogs scn and time scn: 0x0000.04ada796 07/13/03 14:34:39
683.filename E:/ORACLE/ORADATA/TEST/ARCHIVE/1_6.ARC
684.Low scn: 0x0000.04af02f4 10/08/03 08:53:42 Next scn: 0x0000.04b046f0 02/11/04 13:19:35
685.Block count=2464 Blocksize=512
686.RECID #5 Recno 5 Record timestamp 10/08/03 08:53:44 Thread=1 Seq#=5
687.Flags: <produced by archive operation> <created by the ARCH process>
688.Resetlogs scn and time scn: 0x0000.04ada796 07/13/03 14:34:39
689.filename E:/ORACLE/ORADATA/TEST/ARCHIVE/1_5.ARC
690.Low scn: 0x0000.04aeadbb 08/08/03 15:15:38 Next scn: 0x0000.04af02f4 10/08/03 08:53:42
691.Block count=384 Blocksize=512
692.RECID #4 Recno 4 Record timestamp 08/08/03 15:15:41 Thread=1 Seq#=4
693.Flags: <produced by archive operation> <created by the ARCH process>
694.Resetlogs scn and time scn: 0x0000.04ada796 07/13/03 14:34:39
695.filename E:/ORACLE/ORADATA/TEST/ARCHIVE/1_4.ARC
696.Low scn: 0x0000.04ae599c 07/20/03 10:47:36 Next scn: 0x0000.04aeadbb 08/08/03 15:15:38
697.Block count=302 Blocksize=512
698.RECID #3 Recno 3 Record timestamp 07/20/03 10:47:37 Thread=1 Seq#=3
699.Flags: <produced by archive operation> <created by the ARCH process>
700.Resetlogs scn and time scn: 0x0000.04ada796 07/13/03 14:34:39
701.filename E:/ORACLE/ORADATA/TEST/ARCHIVE/1_3.ARC
702.Low scn: 0x0000.04ae07a9 07/20/03 09:43:05 Next scn: 0x0000.04ae599c 07/20/03 10:47:36
703.Block count=41 Blocksize=512
704.RECID #2 Recno 2 Record timestamp 07/20/03 09:43:05 Thread=1 Seq#=2
705.Flags: <produced by archive operation> <created by the foreground process>
706.Resetlogs scn and time scn: 0x0000.04ada796 07/13/03 14:34:39
707.filename E:/ORACLE/ORADATA/TEST/ARCHIVE/1_2.ARC
708.Low scn: 0x0000.04ae05fb 07/20/03 09:30:37 Next scn: 0x0000.04ae07a9 07/20/03 09:43:05
709.Block count=385 Blocksize=512
710.RECID #1 Recno 1 Record timestamp 07/20/03 09:30:39 Thread=1 Seq#=1
711.Flags: <produced by archive operation> <created by the ARCH process>
712.Resetlogs scn and time scn: 0x0000.04ada796 07/13/03 14:34:39
713.filename E:/ORACLE/ORADATA/TEST/ARCHIVE/1_1.ARC
714.Low scn: 0x0000.04ada796 07/13/03 14:34:39 Next scn: 0x0000.04ae05fb 07/20/03 09:30:37
715.Block count=608 Blocksize=512
使用Rman備份數據庫的備份集記錄項（該項從Oracle8開始引入）
716. ******************************************************************
717. BACKUP SET RECORDS
718. ******************************************************************
719.(blkno = 0x2d, size = 40, max = 204, in-use = 0, last-recid= 0)
使用Rman備份數據庫的備份片記錄項（該項從Oracle8開始引入）
720. ******************************************************************
721. BACKUP PIECE RECORDS
722. ******************************************************************
723.(blkno = 0x2e, size = 736, max = 210, in-use = 0, last-recid= 0)
使用Rman備份數據庫的備份數據文件的記錄項（該項從Oracle8開始引入）
724. ******************************************************************
725. BACKUP DATAFILE RECORDS
726. ******************************************************************
727.(blkno = 0x41, size = 116, max = 211, in-use = 0, last-recid= 0)
使用Rman備份數據庫的備份歸檔日志文件的記錄項（該項從Oracle8開始引入）
728. ******************************************************************
729. BACKUP LOG RECORDS
730. ******************************************************************
731.(blkno = 0x44, size = 76, max = 107, in-use = 0, last-recid= 0)
使用Rman備份數據庫時數據文件拷貝的記錄項（該項從Oracle8開始引入）
732. ******************************************************************
733. DATAFILE COPY RECORDS
734. ******************************************************************
735.(blkno = 0x45, size = 660, max = 210, in-use = 1, last-recid= 1)
736.Earliest record:
737.RECID #1 Recno 1 Record timestamp 07/20/03 09:43:04
738.File=0 (0) database id=1750352942 block size=8192
739.Flags:
740.Filename: D:/HOT_BACKUP/CONTROL02.CTL
741.Creation checkpointed at scn: 0x0000.00000000 07/13/03 14:30:52
742.File header checkpointed at scn: 0x0000.04ae079e 07/20/03 09:43:02
743.Resetlogs scn and time scn: 0x0000.04ada796 07/13/03 14:34:39
744.Recovery Fuzzy scn and time scn: 0x0000.00000000 01/01/88 00:00:00
745.Absolute Fuzzy scn: 0x0000.00000000
746.Newly-marked media corrupt blocks 0 Total media corrupt blocks 0
747.Total logically corrupt blocks 0 Block images written to backup 228
748.Low Offline Range Recid 0
749.Tag:
750.Copy does not have keep options.
751.Latest record:
752.RECID #1 Recno 1 Record timestamp 07/20/03 09:43:04
753.File=0 (0) database id=1750352942 block size=8192
754.Flags:
755.Filename: D:/HOT_BACKUP/CONTROL02.CTL
756.Creation checkpointed at scn: 0x0000.00000000 07/13/03 14:30:52
757.File header checkpointed at scn: 0x0000.04ae079e 07/20/03 09:43:02
758.Resetlogs scn and time scn: 0x0000.04ada796 07/13/03 14:34:39
759.Recovery Fuzzy scn and time scn: 0x0000.00000000 01/01/88 00:00:00
760.Absolute Fuzzy scn: 0x0000.00000000
761.Newly-marked media corrupt blocks 0 Total media corrupt blocks 0
762.Total logically corrupt blocks 0 Block images written to backup 228
763.Low Offline Range Recid 0
764.Tag:
765.Copy does not have keep options.
使用Rman備份數據庫的備份數據文件損壞記錄項（該項從Oracle8開始引入）
766. ******************************************************************
767. BACKUP DATAFILE CORRUPTION RECORDS
768. ******************************************************************
769.(blkno = 0x56, size = 44, max = 185, in-use = 0, last-recid= 0)
使用Rman備份數據庫的數據文件拷貝損壞記錄項（該項從Oracle8開始引入）
770. ******************************************************************
771. DATAFILE COPY CORRUPTION RECORDS
772. ******************************************************************
773.(blkno = 0x57, size = 40, max = 204, in-use = 0, last-recid= 0)
使用Rman備份數據庫的刪除記錄（該項從Oracle8開始引入）
774. ******************************************************************
775. DELETION RECORDS
776. ******************************************************************
777.(blkno = 0x58, size = 20, max = 408, in-use = 0, last-recid= 0)
使用Rman備份數據庫的代理拷貝記錄項（該項從Oracle8i開始引入）
778. ******************************************************************
779. PROXY COPY RECORDS
780. ******************************************************************
781.(blkno = 0x59, size = 852, max = 210, in-use = 0, last-recid= 0)
INCARNATION RECORDS（該項從Oracle9i開始引入）
782. ******************************************************************
783. INCARNATION RECORDS
784. ******************************************************************
785.(blkno = 0x72, size = 56, max = 145, in-use = 1, last-recid= 1)
786.Earliest record:
787.RECID #1 Recno 1 Record timestamp
788.Resetlogs scn and time scn: 0x0000.04ada796 07/13/03 14:34:39
789.Previous Resetlogs scn and time scn: 0x0000.04a0b855 04/11/03 09:59:18
790.Latest record:
791.RECID #1 Recno 1 Record timestamp
792.Resetlogs scn and time scn: 0x0000.04ada796 07/13/03 14:34:39
793.Previous Resetlogs scn and time scn: 0x0000.04a0b855 04/11/03 09:59:18
794. *** END OF DUMP ***
