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