分享
 
 
 

解读Oracle 9201的控制文件

王朝oracle·作者佚名  2006-01-09
窄屏简体版  字體: |||超大  

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\SYSTEM01.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 ***

 
 
 
免责声明:本文为网络用户发布,其观点仅代表作者个人观点,与本站无关,本站仅提供信息存储服务。文中陈述内容未经本站证实,其真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
2023年上半年GDP全球前十五强
 百态   2023-10-24
美众议院议长启动对拜登的弹劾调查
 百态   2023-09-13
上海、济南、武汉等多地出现不明坠落物
 探索   2023-09-06
印度或要将国名改为“巴拉特”
 百态   2023-09-06
男子为女友送行,买票不登机被捕
 百态   2023-08-20
手机地震预警功能怎么开?
 干货   2023-08-06
女子4年卖2套房花700多万做美容:不但没变美脸,面部还出现变形
 百态   2023-08-04
住户一楼被水淹 还冲来8头猪
 百态   2023-07-31
女子体内爬出大量瓜子状活虫
 百态   2023-07-25
地球连续35年收到神秘规律性信号,网友:不要回答!
 探索   2023-07-21
全球镓价格本周大涨27%
 探索   2023-07-09
钱都流向了那些不缺钱的人,苦都留给了能吃苦的人
 探索   2023-07-02
倩女手游刀客魅者强控制(强混乱强眩晕强睡眠)和对应控制抗性的关系
 百态   2020-08-20
美国5月9日最新疫情:美国确诊人数突破131万
 百态   2020-05-09
荷兰政府宣布将集体辞职
 干货   2020-04-30
倩女幽魂手游师徒任务情义春秋猜成语答案逍遥观:鹏程万里
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案神机营:射石饮羽
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案昆仑山:拔刀相助
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案天工阁:鬼斧神工
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案丝路古道:单枪匹马
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案镇郊荒野:与虎谋皮
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案镇郊荒野:李代桃僵
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案镇郊荒野:指鹿为马
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案金陵:小鸟依人
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案金陵:千金买邻
 干货   2019-11-12
 
推荐阅读
 
 
 
>>返回首頁<<
 
靜靜地坐在廢墟上,四周的荒凉一望無際,忽然覺得,淒涼也很美
© 2005- 王朝網路 版權所有