仓酷云

标题: MYSQL网页编程之解读Oracle 9201的把持文件 [打印本页]

作者: 小妖女 时间: 2015-1-16 22:42
标题: MYSQL网页编程之解读Oracle 9201的把持文件
人力成本上的节省，MySQL的用户Spacemonkey实验室的首席执行官MitchPirtle如此表示：“维护MySQL使得你不需要一个年薪15万美元的DBA。oracle|把持
Oracle9201的把持文件内容列表：

把持文件头...

数据库项...

反省点进度纪录（该项从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入手下手引进）...

INCARNATIONRECORDS（该项从Oracle9i入手下手引进）...

第1行到第22行的内容为把持文件的头信息，这部份内容的注释拜见《转储把持文件头》。
把持文件头
1.Dumpfilee:oracleadmin estudump est_ora_376.trc

2.FriMay1415:09:522004

3.ORACLEV9.2.0.1.0-Productionvsnsta=0

4.vsnsql=12vsnxtr=3

5.Windows2000Version5.0ServicePack4,CPUtype586

6.Oracle9iEnterpriseEditionRelease9.2.0.1.0-Production

7.WiththePartitioning,OLAPandOracleDataMiningoptions

8.JServerRelease9.2.0.1.0-Production

9.Windows2000Version5.0ServicePack4,CPUtype586

10.Instancename:test

11.Redothreadmountedbythisinstance:1

12.Oracleprocessnumber:13

13.Windowsthreadid:376,image:ORACLE.EXE

14.***2004-05-1415:09:52.000

15.***SESSIONID:(10.21)2004-05-1415:09:52.000

16.DUMPOFCONTROLFILES,Seq#2929=0xb71

＝＝＝＝＝＝＝第17行到第22举动通用文件头＝＝＝＝＝＝＝＝

17.FILEHEADER:

18.Softwarevsn=153092096=0x9200000,CompatibilityVsn=134217728=0x8000000

19.DbID=1750352942=0x6854442e,DbName=TEST1

20.ActivationID=0=0x0

21.ControlSeq=2929=0xb71,Filesize=228=0xe4

22.FileNumber=0,Blksiz=8192,FileType=1CONTROL

**************************把持文件头信息停止****************************

数据库项
23.**********************************************************************

24.DATABASEENTRY

25.**********************************************************************

26.(blkno=0x1,size=192,max=1,in-use=1,last-recid=0)

blkno

size指出数据库项的字节数，本例中为192byte;

max指出最年夜的块

in-use以后正在利用的块

last-recid

27.DFVersion:creation=0x9200000compatible=0x8000000,Date07/13/200314:30:51

数据文件的版本是9.2.0，兼容版本是8.0

28.DBName"TEST1"

数据库名为"TEST1"

29.Databaseflags=0x00404001

30.ControlfileCreationTimestamp07/13/200314:30:52

把持文件的创立工夫

31.Incmpltrecoveryscn:0x0000.00000000

假如数据库举行过不完整复兴，我们能够看出

32.Resetlogsscn:0x0000.04ada796ResetlogsTimestamp07/13/200314:34:39

启用Resetlogs时的scn值和时戳，

33.Priorresetlogsscn:0x0000.04a0b855PriorresetlogsTimestamp04/11/200309:59:18

启用Resetlogs之前的scn值和时戳

Oracle不克不及够使用Resetlogs之前的重做日记（redologfile）。

34.RedoVersion:creation=0x9200000compatable=0x9200000

重做日记文件的版本是9.2.0，兼容版本是8.0

35.#Datafiles=12,#Onlinefiles=12

数据库统共有12个数据文件，而且这12个文件全体处在联机（online）形态

36.Databasecheckpoint:Thread=1scn:0x0000.04b9d858

37.Threads:#Enabled=1,#Open=1,Head=1,Tail=1

以后启用了一个线程，固然，也仅仅翻开了这一个线程

38.enabledthreads:0100000000000000000000000000000000000000000000000000000000000000

39.Maxlogmembers=3,Maxdatamembers=1

数据库同意每一个日记组最多有3个logmember；

Oracle今朝还不撑持数据文件的多路复用，因而，Maxdatamembers的值为1，这个条目是为今后的版本晋级而预留的。

40.Archlist:Head=3,Tail=3,Forcescn:0x0000.04b93016scn:0x0000.04b9d857

请注重Forcescn，但凡入手下手scn小于Forcescn的重做都被回档。强迫scn是一切重做都被回档的scn。

41.ControlfileCheckpointedatscn:0x0000.04b9d85a05/14/200408:37:00

以后把持文件Checkpointed时的scn为0x0000.04b9d85a？？？

42.thread:0rba:(0x0.0.0)

43.enabledthreads:000000000000000000000000000000000000000000000000

0000000000000000

反省点进度纪录（该项从Oracle8入手下手引进）
44.**********************************************************************

45.CHECKPOINTPROGRESSRECORDS

46.**********************************************************************

反省点进度纪录这个条目是从Oracle8入手下手呈现在把持文件中的。该项目次要用来纪录缓冲区高速缓存的形态，每一个纪录占用把持文件的一个块。

47.(blkno=0x4,size=104,max=1,in-use=1,last-recid=0)

48.THREAD#1-status:0x2flags:0x0dirty:15

线程信息，

49.lowcacherba:(0x20.1f0.0)ondiskrba:(0x20.204.0)

低速缓存rba（recoveryblockaddress）指出了在实例复兴大概溃散恢复中，必要恢复的重做入手下手值（即，重做日记文件中的一个块地点）；

ondiskrba是磁盘上的最高的重做值，在举行气力恢复使用重做的时分必需到达这个值。假如ondiskrba

50.ondiskscn:0x0000.04b9f6e205/14/200415:06:42

ondiskscn是ondiskrba处的scn值

51.resetlogsscn:0x0000.04ada79607/13/200314:34:39

启用Resetlogs时的scn值和时戳，和数据库项中的响应条目是分歧的

52.heartbeat:526099342mountid:903127902

53.MTTRstatisticsstatus:3

54.Inittime:Avg:23012858,Timesmeasured:3

55.Fileopentime:Avg:123550,Timesmeasured:43

56.Logblockreadtime:Avg:182,Timesmeasured:32758

57.Datablockhandlingtime:Avg:22934,Timesmeasured:135

扩大的数据库项（该项从Oracle9i入手下手引进）
58.***********************************************************************

59.EXTENDEDDATABASEENTRY

60.***********************************************************************

61.(blkno=0x71,size=276,max=1,in-use=1,last-recid=0)

62.ControlAutoBackupdate(dd/mm/yyyy)=13/7/2003

63.NextAutoBackupsequence=0

重做线程项
64.**********************************************************************

65.REDOTHREADRECORDS

66.**********************************************************************

67.(blkno=0x4,size=104,max=1,in-use=1,last-recid=0)

68.THREAD#1-status:0xfthreadlinksforward:0back:0

69.#logs:4first:1last:4current:3lastusedseq#:0x20

这个条目申明数据库中统共有4个日记文件组，第一个组为log#1（loggroup1）；最初一个组为log#4（loggroup4），以后正在利用的是log#3（loggroup3）

70.enabledatscn:0x0000.04ada79607/13/200314:34:39

启用线程1时的scn值

71.disabledatscn:0x0000.0000000001/01/198800:00:00

禁用线程1时的scn值，由于该线程今朝处于翻开形态，以是该值为无量年夜

72.openedat05/14/200408:36:59byinstancetest

翻开线程的时戳，以后线程和被哪一个实例翻开

73.Checkpointedatscn:0x0000.04b9d85805/14/200408:36:59

74.thread:1rba:(0x20.2.10)

75.enabledthreads:010000000000000000000000000000000000000000000000

76.0000000000000000

77.loghistory:31

日记文件项
78.**********************************************************************

79.LOGFILERECORDS

80.**********************************************************************

81.(blkno=0x5,size=72,max=5,in-use=4,last-recid=4)

82.LOGFILE#1:

83.(name#5)E:ORACLEORA92TESTREDO01.LOG

84.Thread1redologlinks:forward:2backward:0

LOGFILE#1写满后，会切换到forward:2，即切换到LOGFILE#2，这一点能够经由过程LOGFILE#1的Nextscn:0x0000.04b9870a即是LOGFILE#2的Lowscn:0x0000.04b9870a

85.siz:0xf000seq:0x0000001ehws:0x6bsz:512nab:0x15bflg:0x1dup:1

nab是日记文件中LGWR可用的下一个数据块的地点，假如这个值是无量年夜，申明这个日记文件是以后（LGWR正在写进）的日记文件

86.Archivelinks:fwrd:0back:0Prevscn:0x0000.04b8b9ad

87.Lowscn:0x0000.04b9301605/13/200416:31:24

日记产生切换时会分派一个低scn和一个高scn，低scn就是上一个日记的高scn的值，而高scn则设置为无量年夜，直到切换到下一个日记文件时，再将以后日记的高scn设置为下一个日记文件的低scn，将下一个日记文件的高scn设置为无量年夜。

88.Nextscn:0x0000.04b9870a05/13/200419:43:45

日记产生切换后，高scn就从无量年夜该为Nextscn（下一个scn）的值，该值将作为切换后的日记文件的低scn

89.LOGFILE#2:

90.(name#4)E:ORACLEORA92TESTREDO02.LOG

91.Thread1redologlinks:forward:3backward:1

92.siz:0xf000seq:0x0000001fhws:0x5bsz:512nab:0x133flg:0x1dup:1

93.Archivelinks:fwrd:0back:0Prevscn:0x0000.04b93016

94.Lowscn:0x0000.04b9870a05/13/200419:43:45

95.Nextscn:0x0000.04b9d85705/14/200408:36:59

96.LOGFILE#3:

97.(name#3)E:ORACLEORA92TESTREDO03.LOG

98.Thread1redologlinks:forward:4backward:2

99.siz:0xf000seq:0x00000020hws:0x2bsz:512nab:0xffffffffflg:0x8dup:1

100.Archivelinks:fwrd:0back:0Prevscn:0x0000.04b9870a

101.Lowscn:0x0000.04b9d85705/14/200408:36:59

102.Nextscn:0xffff.ffffffff01/01/198800:00:00

申明，LOGFILE#3是以后日记文件（LGWR正在写进的日记文件）

103.LOGFILE#4:

104.(name#1)E:ORACLEORA92TESTREDO04A.LOG

105.(name#2)E:ORACLEORA92TESTREDO04B.LOG

106.Thread1redologlinks:forward:0backward:3

107.siz:0x800seq:0x0000001dhws:0xabsz:512nab:0x427flg:0x1dup:2

108.Archivelinks:fwrd:0back:0Prevscn:0x0000.04b854e4

109.Lowscn:0x0000.04b8b9ad05/11/200414:27:28

110.Nextscn:0x0000.04b9301605/13/200416:31:24

数据文件项
111.******************************************************************

112.DATAFILERECORDS

113.******************************************************************

114.(blkno=0x6,size=180,max=100,in-use=14,last-recid=41)

115.DATAFILE#1:

116.(name#17)E:ORACLEORA92TESTYSTEM01.DBF

117.creationsize=0blocksize=8192status=0xehead=17tail=17dup=1

118.tablespace0,index=1krfil=1prev_file=0

申明是体系表空间

119.unrecoverablescn:0x0000.0000000001/01/198800:00:00

120.Checkpointcnt:701scn:0x0000.04b9d85805/14/200408:36:59

对该文件实行反省点的次数为701（文件处于热备形态时，假如产生了反省点，反省点计数器（Checkpointcnt）也仍是加一）；

121.Stopscn:0xffff.ffffffff05/13/200420:18:03

停止scn（Stopscn）是数据文件的最初一个scn（数据库一般封闭时会设置这个值），数据库一般翻开的形态，该值为无量年夜。数据库恢复时请求恢复到Stopscn。

122.CreationCheckpointedatscn:0x0000.0000001401/13/200222:01:17

事先用“alterdatabasecreatedatafile”命令恢单数据文件时（该命令从Oracle7入手下手引进），必要根据文件创立时的反省点scn（CreationCheckpointedatscn）。

123.thread:0rba:(0x0.0.0)

124.enabledthreads:000000000000000000000000000000000000000000000000

0000000000000000

125.Offlinescn:0x0000.04ada795prev_range:0

当文件脱机时，文件脱机时的scn作为脱机scn保留在把持文件中

126.OnlineCheckpointedatscn:0x0000.04ada79607/13/200314:34:39

当文件联机时，文件联机时的反省点scn作为联机scn保留在把持文件中

因为体系表空间的数据文件永久不克不及脱机，以是体系数据文件的脱机scn应当为0x0000.00000000

料想，这里的Offlinescn暗示数据库上一次一般封闭时数据文件的反省点scn；

这里的OnlineCheckpointedatscn暗示数据库本次翻开时的数据文件的反省点scn

127.thread:1rba:(0x1.2.0)

128.enabledthreads:010000000000000000000000000000000000000000000000

0000000000000000

129.HotBackupendmarkerscn:0x0000.00000000

热备时的scn

130.aux_fileisNOTDEFINED

131.DATAFILE#2:

132.(name#16)E:ORACLEORA92TESTUNDOTBS01.DBF

133.creationsize=0blocksize=8192status=0xehead=16tail=16dup=1

134.tablespace1,index=2krfil=2prev_file=0

135.unrecoverablescn:0x0000.0000000001/01/198800:00:00

136.Checkpointcnt:640scn:0x0000.04b9d85805/14/200408:36:59

137.Stopscn:0xffff.ffffffff05/13/200420:18:03

138.CreationCheckpointedatscn:0x0000.0002f40101/14/200222:24:49

139.thread:0rba:(0x0.0.0)

140.enabledthreads:000000000000000000000000000000000000000000000000

141.0000000000000000

142.Offlinescn:0x0000.04ada795prev_range:0

143.OnlineCheckpointedatscn:0x0000.04ada79607/13/200314:34:39

144.thread:1rba:(0x1.2.0)

145.enabledthreads:010000000000000000000000000000000000000000000000

146.0000000000000000

147.HotBackupendmarkerscn:0x0000.00000000

148.aux_fileisNOTDEFINED

149.DATAFILE#3:

150.(name#15)E:ORACLEORA92TESTDRSYS01.DBF

151.creationsize=0blocksize=8192status=0xehead=15tail=15dup=1

152.tablespace3,index=3krfil=3prev_file=0

153.unrecoverablescn:0x0000.0000000001/01/198800:00:00

154.Checkpointcnt:699scn:0x0000.04b9d85805/14/200408:36:59

155.Stopscn:0xffff.ffffffff05/13/200420:18:03

156.CreationCheckpointedatscn:0x0000.0000188201/13/200222:02:52

157.thread:0rba:(0x0.0.0)

158.enabledthreads:000000000000000000000000000000000000000000000000

159.0000000000000000

160.Offlinescn:0x0000.04ada795prev_range:0

161.OnlineCheckpointedatscn:0x0000.04ada79607/13/200314:34:39

162.thread:1rba:(0x1.2.0)

163.enabledthreads:010000000000000000000000000000000000000000000000

164.0000000000000000

165.HotBackupendmarkerscn:0x0000.00000000

166.aux_fileisNOTDEFINED

167.DATAFILE#4:

168.(name#14)E:ORACLEORA92TESTINDX01.DBF

169.creationsize=0blocksize=8192status=0xehead=14tail=14dup=1

170.tablespace4,index=4krfil=4prev_file=0

171.unrecoverablescn:0x0000.0000000001/01/198800:00:00

172.Checkpointcnt:699scn:0x0000.04b9d85805/14/200408:36:59

173.Stopscn:0xffff.ffffffff05/13/200420:18:03

174.CreationCheckpointedatscn:0x0000.0000189501/13/200222:02:58

175.thread:0rba:(0x0.0.0)

176.enabledthreads:000000000000000000000000000000000000000000000000

177.0000000000000000

178.Offlinescn:0x0000.04ada795prev_range:0

179.OnlineCheckpointedatscn:0x0000.04ada79607/13/200314:34:39

180.thread:1rba:(0x1.2.0)

181.enabledthreads:010000000000000000000000000000000000000000000000

182.0000000000000000

183.HotBackupendmarkerscn:0x0000.00000000

184.aux_fileisNOTDEFINED

185.DATAFILE#5:

186.(name#13)E:ORACLEORA92TESTTOOLS01.DBF

187.creationsize=0blocksize=8192status=0xehead=13tail=13dup=1

188.tablespace5,index=5krfil=5prev_file=0

189.unrecoverablescn:0x0000.0000000001/01/198800:00:00

190.Checkpointcnt:699scn:0x0000.04b9d85805/14/200408:36:59

191.Stopscn:0xffff.ffffffff05/13/200420:18:03

192.CreationCheckpointedatscn:0x0000.000018a601/13/200222:03:03

193.thread:0rba:(0x0.0.0)

194.enabledthreads:000000000000000000000000000000000000000000000000

195.0000000000000000

196.Offlinescn:0x0000.04ada795prev_range:0

197.OnlineCheckpointedatscn:0x0000.04ada79607/13/200314:34:39

198.thread:1rba:(0x1.2.0)

199.enabledthreads:010000000000000000000000000000000000000000000000

200.0000000000000000

201.HotBackupendmarkerscn:0x0000.00000000

202.aux_fileisNOTDEFINED

203.DATAFILE#6:

204.(name#12)E:ORACLEORA92TESTUSERS01.DBF

205.creationsize=0blocksize=8192status=0xehead=12tail=12dup=1

206.tablespace6,index=6krfil=6prev_file=0

207.unrecoverablescn:0x0000.0000000001/01/198800:00:00

208.Checkpointcnt:702scn:0x0000.04b9d85805/14/200408:36:59

209.Stopscn:0xffff.ffffffff05/13/200420:18:03

210.CreationCheckpointedatscn:0x0000.000018b701/13/200222:03:09

211.thread:0rba:(0x0.0.0)

212.enabledthreads:000000000000000000000000000000000000000000000000

213.0000000000000000

214.Offlinescn:0x0000.04ada795prev_range:0

215.OnlineCheckpointedatscn:0x0000.04ada79607/13/200314:34:39

216.thread:1rba:(0x1.2.0)

217.enabledthreads:010000000000000000000000000000000000000000000000

218.0000000000000000

219.HotBackupendmarkerscn:0x0000.00000000

220.aux_fileisNOTDEFINED

221.DATAFILE#7:

222.(name#11)E:ORACLEORA92TESTXDB01.DBF

223.creationsize=0blocksize=8192status=0xehead=11tail=11dup=1

224.tablespace7,index=7krfil=7prev_file=0

225.unrecoverablescn:0x0000.0000000001/01/198800:00:00

226.Checkpointcnt:698scn:0x0000.04b9d85805/14/200408:36:59

227.Stopscn:0xffff.ffffffff05/13/200420:18:03

228.CreationCheckpointedatscn:0x0000.000018cc01/13/200222:03:18

229.thread:0rba:(0x0.0.0)

230.enabledthreads:000000000000000000000000000000000000000000000000

231.0000000000000000

232.Offlinescn:0x0000.04ada795prev_range:0

233.OnlineCheckpointedatscn:0x0000.04ada79607/13/200314:34:39

234.thread:1rba:(0x1.2.0)

235.enabledthreads:010000000000000000000000000000000000000000000000

236.0000000000000000

237.HotBackupendmarkerscn:0x0000.00000000

238.aux_fileisNOTDEFINED

239.DATAFILE#8:

240.(name#10)E:ORACLEORA92TESTTEST01.DBF

241.creationsize=0blocksize=8192status=0xehead=10tail=10dup=1

242.tablespace11,index=8krfil=8prev_file=0

243.unrecoverablescn:0x0000.0000000001/01/198800:00:00

244.Checkpointcnt:356scn:0x0000.04b9d85805/14/200408:36:59

245.Stopscn:0xffff.ffffffff05/13/200420:18:03

246.CreationCheckpointedatscn:0x0000.0011a40e02/06/200316:25:09

247.thread:0rba:(0x0.0.0)

248.enabledthreads:000000000000000000000000000000000000000000000000

249.0000000000000000

250.Offlinescn:0x0000.04ada795prev_range:0

251.OnlineCheckpointedatscn:0x0000.04ada79607/13/200314:34:39

252.thread:1rba:(0x1.2.0)

253.enabledthreads:010000000000000000000000000000000000000000000000

254.0000000000000000

255.HotBackupendmarkerscn:0x0000.00000000

256.aux_fileisNOTDEFINED

257.DATAFILE#9:

258.(name#9)E:ORACLEORA92TESTRMAN01.DBF

259.creationsize=0blocksize=8192status=0xehead=9tail=9dup=1

260.tablespace9,index=9krfil=9prev_file=0

261.unrecoverablescn:0x0000.0000000001/01/198800:00:00

262.Checkpointcnt:576scn:0x0000.04b9d85805/14/200408:36:59

263.Stopscn:0xffff.ffffffff05/13/200420:18:03

264.CreationCheckpointedatscn:0x0000.0009f9ce01/24/200217:23:42

265.thread:0rba:(0x0.0.0)

266.enabledthreads:000000000000000000000000000000000000000000000000

267.0000000000000000

268.Offlinescn:0x0000.04ada795prev_range:0

269.OnlineCheckpointedatscn:0x0000.04ada79607/13/200314:34:39

270.thread:1rba:(0x1.2.0)

271.enabledthreads:010000000000000000000000000000000000000000000000

272.0000000000000000

273.HotBackupendmarkerscn:0x0000.00000000

274.aux_fileisNOTDEFINED

275.DATAFILE#10:

276.(name#8)E:ORACLEORA92TESTPERFSTAT01.DBF

277.creationsize=0blocksize=8192status=0xehead=8tail=8dup=1

278.tablespace12,index=10krfil=10prev_file=0

279.unrecoverablescn:0x0000.0000000001/01/198800:00:00

280.Checkpointcnt:253scn:0x0000.04b9d85805/14/200408:36:59

281.Stopscn:0xffff.ffffffff05/13/200420:18:03

282.CreationCheckpointedatscn:0x0000.00199caf03/03/200319:55:07

283.thread:0rba:(0x0.0.0)

284.enabledthreads:000000000000000000000000000000000000000000000000

285.0000000000000000

286.Offlinescn:0x0000.04ada795prev_range:0

287.OnlineCheckpointedatscn:0x0000.04ada79607/13/200314:34:39

288.thread:1rba:(0x1.2.0)

289.enabledthreads:010000000000000000000000000000000000000000000000

290.0000000000000000

291.HotBackupendmarkerscn:0x0000.00000000

292.aux_fileisNOTDEFINED

293.DATAFILE#11:

294.(name#7)E:ORACLEORA92TESTUNDOTBS02.DBF

295.creationsize=0blocksize=8192status=0xehead=7tail=7dup=1

296.tablespace8,index=11krfil=11prev_file=0

297.unrecoverablescn:0x0000.0000000001/01/198800:00:00

298.Checkpointcnt:237scn:0x0000.04b9d85805/14/200408:36:59

299.Stopscn:0xffff.ffffffff05/13/200420:18:03

300.CreationCheckpointedatscn:0x0000.049f6bf803/27/200309:48:22

301.thread:0rba:(0x0.0.0)

302.enabledthreads:000000000000000000000000000000000000000000000000

303.0000000000000000

304.Offlinescn:0x0000.04ada795prev_range:0

305.OnlineCheckpointedatscn:0x0000.04ada79607/13/200314:34:39

306.thread:1rba:(0x1.2.0)

307.enabledthreads:010000000000000000000000000000000000000000000000

308.0000000000000000

309.HotBackupendmarkerscn:0x0000.00000000

310.aux_fileisNOTDEFINED

311.DATAFILE#12:<deleted>

312.creationsize=1280blocksize=8192status=0x800head=0tail=0dup=0

313.tablespace18,index=14krfil=12prev_file=0

314.unrecoverablescn:0x0000.0000000001/01/198800:00:00

315.Checkpointcnt:3scn:0x0000.04b7e87405/10/200416:45:12

316.Stopscn:0x0000.04b7e87405/10/200416:45:12

317.CreationCheckpointedatscn:0x0000.04b7e49605/10/200416:04:32

318.thread:1rba:(0x1a.17d.10)

319.enabledthreads:010000000000000000000000000000000000000000000000

320.0000000000000000

321.Offlinescn:0x0000.00000000prev_range:0

322.OnlineCheckpointedatscn:0x0000.00000000

323.thread:0rba:(0x0.0.0)

324.enabledthreads:000000000000000000000000000000000000000000000000

325.0000000000000000

326.HotBackupendmarkerscn:0x0000.00000000

327.aux_fileisNOTDEFINED

328.DATAFILE#13:<deleted>

329.creationsize=0blocksize=0status=0x0head=0tail=0dup=0

330.tablespace0,index=0krfil=0prev_file=0

331.unrecoverablescn:0x0000.0000000001/01/198800:00:00

332.Checkpointcnt:0scn:0x0000.0000000001/01/198800:00:00

333.Stopscn:0x0000.0000000001/01/198800:00:00

334.CreationCheckpointedatscn:0x0000.00000000

335.thread:0rba:(0x0.0.0)

336.enabledthreads:000000000000000000000000000000000000000000000000

337.0000000000000000

338.Offlinescn:0x0000.00000000prev_range:0

339.OnlineCheckpointedatscn:0x0000.00000000

340.thread:0rba:(0x0.0.0)

341.enabledthreads:000000000000000000000000000000000000000000000000

342.0000000000000000

343.HotBackupendmarkerscn:0x0000.00000000

344.aux_file=0

345.DATAFILE#14:

346.(name#6)E:ORACLEORA92TESTXPRT01.DBF

347.creationsize=0blocksize=8192status=0xehead=6tail=6dup=1

348.tablespace16,index=12krfil=14prev_file=0

349.unrecoverablescn:0x0000.0000000001/01/198800:00:00

350.Checkpointcnt:187scn:0x0000.04b9d85805/14/200408:36:59

351.Stopscn:0xffff.ffffffff05/13/200420:18:03

352.CreationCheckpointedatscn:0x0000.04a3fd9c05/28/200315:06:11

353.thread:0rba:(0x0.0.0)

354.enabledthreads:000000000000000000000000000000000000000000000000

355.0000000000000000

356.Offlinescn:0x0000.04ada795prev_range:0

357.OnlineCheckpointedatscn:0x0000.04ada79607/13/200314:34:39

358.thread:1rba:(0x1.2.0)

359.enabledthreads:010000000000000000000000000000000000000000000000

360.0000000000000000

361.HotBackupendmarkerscn:0x0000.00000000

362.aux_fileisNOTDEFINED

一时文件纪录项（该项从Oracle9i入手下手引进）
363.******************************************************************

364.TEMPFILERECORDS

365.******************************************************************

366.(blkno=0x12,size=56,max=100,in-use=1,last-recid=1)

367.TEMPFILE#1:ExternalFile#201

368.(name#18)E:ORACLEORA92TESTTEMP.DBF

369.creationsize=2560blocksize=8192status=0xehead=18tail=18dup=1

370.tablespace2,index=13krfil=1prev_file=0

371.unrecoverablescn:0x0000.0000000001/01/198800:00:00

表空间纪录项（该项从Oracle8入手下手引进）
372.******************************************************************

373.TABLESPACERECORDS

374.******************************************************************

375.(blkno=0x11,size=68,max=100,in-use=16,last-recid=9)

376.TABLESPACE#0SYSTEM:recno=1

377.Firstdatafilelink=1TablespaceFlag=0

378.TablespacePITRmodestartscn:0x0000.0000000001/01/198800:00:00

379.TablespacePITRlastcompletionscn:0x0000.0000000001/01/198800:00:00

380.TABLESPACE#1UNDOTBS1:recno=2

381.Firstdatafilelink=2TablespaceFlag=0

382.TablespacePITRmodestartscn:0x0000.0000000001/01/198800:00:00

383.TablespacePITRlastcompletionscn:0x0000.0000000001/01/198800:00:00

384.TABLESPACE#3DRSYS:recno=3

385.Firstdatafilelink=3TablespaceFlag=0

386.TablespacePITRmodestartscn:0x0000.0000000001/01/198800:00:00

387.TablespacePITRlastcompletionscn:0x0000.0000000001/01/198800:00:00

388.TABLESPACE#4INDX:recno=4

389.Firstdatafilelink=4TablespaceFlag=0

390.TablespacePITRmodestartscn:0x0000.0000000001/01/198800:00:00

391.TablespacePITRlastcompletionscn:0x0000.0000000001/01/198800:00:00

392.TABLESPACE#5TOOLS:recno=5

393.Firstdatafilelink=5TablespaceFlag=0

394.TablespacePITRmodestartscn:0x0000.0000000001/01/198800:00:00

395.TablespacePITRlastcompletionscn:0x0000.0000000001/01/198800:00:00

396.TABLESPACE#6USERS:recno=6

397.Firstdatafilelink=6TablespaceFlag=0

398.TablespacePITRmodestartscn:0x0000.0000000001/01/198800:00:00

399.TablespacePITRlastcompletionscn:0x0000.0000000001/01/198800:00:00

400.TABLESPACE#7XDB:recno=7

401.Firstdatafilelink=7TablespaceFlag=0

402.TablespacePITRmodestartscn:0x0000.0000000001/01/198800:00:00

403.TablespacePITRlastcompletionscn:0x0000.0000000001/01/198800:00:00

404.TABLESPACE#11TEST:recno=8

405.Firstdatafilelink=8TablespaceFlag=0

406.TablespacePITRmodestartscn:0x0000.0000000001/01/198800:00:00

407.TablespacePITRlastcompletionscn:0x0000.0000000001/01/198800:00:00

408.TABLESPACE#9RMAN:recno=9

409.Firstdatafilelink=9TablespaceFlag=0

410.TablespacePITRmodestartscn:0x0000.0000000001/01/198800:00:00

411.TablespacePITRlastcompletionscn:0x0000.0000000001/01/198800:00:00

412.TABLESPACE#12PERFSTAT:recno=10

413.Firstdatafilelink=10TablespaceFlag=0

414.TablespacePITRmodestartscn:0x0000.0000000001/01/198800:00:00

415.TablespacePITRlastcompletionscn:0x0000.0000000001/01/198800:00:00

416.TABLESPACE#8UNDOTBS2:recno=11

417.Firstdatafilelink=11TablespaceFlag=0

418.TablespacePITRmodestartscn:0x0000.0000000001/01/198800:00:00

419.TablespacePITRlastcompletionscn:0x0000.0000000001/01/198800:00:00

420.TABLESPACE#16XPRT:recno=12

421.Firstdatafilelink=14TablespaceFlag=0

422.TablespacePITRmodestartscn:0x0000.0000000001/01/198800:00:00

423.TablespacePITRlastcompletionscn:0x0000.0000000001/01/198800:00:00

424.TABLESPACE#2TEMP:recno=13

425.Firstdatafilelink=1TablespaceFlag=1

426.TablespacePITRmodestartscn:0x0000.0000000001/01/198800:00:00

427.TablespacePITRlastcompletionscn:0x0000.0000000001/01/198800:00:00

428.TABLESPACE#2147483647UNDO_TEST:recno=14

429.Firstdatafilelink=0TablespaceFlag=0

430.TablespacePITRmodestartscn:0x0000.0000000001/01/198800:00:00

431.TablespacePITRlastcompletionscn:0x0000.0000000001/01/198800:00:00

432.TABLESPACE#2147483647SORT:recno=15

433.Firstdatafilelink=0TablespaceFlag=1

434.TablespacePITRmodestartscn:0x0000.0000000001/01/198800:00:00

435.TablespacePITRlastcompletionscn:0x0000.0000000001/01/198800:00:00

436.TABLESPACE#2147483647LUNARTEMP:recno=16

437.Firstdatafilelink=0TablespaceFlag=1

438.TablespacePITRmodestartscn:0x0000.0000000001/01/198800:00:00

439.TablespacePITRlastcompletionscn:0x0000.0000000001/01/198800:00:00

Rman设置纪录项（该项从Oracle9i入手下手引进）
440.******************************************************************

441.RMANCONFIGURATIONRECORDS

442.******************************************************************

443.(blkno=0x13,size=1108,max=50,in-use=0,last-recid=0)

日记文件汗青纪录项
444.******************************************************************

445.LOGFILEHISTORYRECORDS

446.******************************************************************

447.(blkno=0x1a,size=36,max=226,in-use=31,last-recid=31)

448.Earliestrecord:

449.RECID#1Recno1Recordtimestamp07/20/0309:30:37Thread=1Seq#=1Link-Recid=0

450.Lowscn:0x0000.04ada79607/13/0314:34:39Nextscn:0x0000.04ae05fb

451.Latestrecord:

452.RECID#31Recno31Recordtimestamp05/14/0408:36:59Thread=1Seq#=31Link-Recid=30

453.Lowscn:0x0000.04b9870a05/13/0419:43:45Nextscn:0x0000.04b9d857

454.RECID#30Recno30Recordtimestamp05/13/0419:43:45Thread=1Seq#=30Link-Recid=29

455.Lowscn:0x0000.04b9301605/13/0416:31:24Nextscn:0x0000.04b9870a

456.RECID#29Recno29Recordtimestamp05/13/0416:31:24Thread=1Seq#=29Link-Recid=28

457.Lowscn:0x0000.04b8b9ad05/11/0414:27:28Nextscn:0x0000.04b93016

458.RECID#28Recno28Recordtimestamp05/11/0414:27:29Thread=1Seq#=28Link-Recid=27

459.Lowscn:0x0000.04b854e405/11/0408:14:52Nextscn:0x0000.04b8b9ad

460.RECID#27Recno27Recordtimestamp05/11/0408:14:52Thread=1Seq#=27Link-Recid=26

461.Lowscn:0x0000.04b7efc305/10/0418:00:17Nextscn:0x0000.04b854e4

462.RECID#26Recno26Recordtimestamp05/10/0418:00:17Thread=1Seq#=26Link-Recid=25

463.Lowscn:0x0000.04b7d71605/10/0413:16:04Nextscn:0x0000.04b7efc3

464.RECID#25Recno25Recordtimestamp05/10/0413:16:05Thread=1Seq#=25Link-Recid=24

465.Lowscn:0x0000.04b759e605/09/0408:41:38Nextscn:0x0000.04b7d716

466.RECID#24Recno24Recordtimestamp05/09/0408:41:38Thread=1Seq#=24Link-Recid=23

467.Lowscn:0x0000.04b6d74d05/08/0409:45:10Nextscn:0x0000.04b759e6

468.RECID#23Recno23Recordtimestamp05/08/0409:45:10Thread=1Seq#=23Link-Recid=22

469.Lowscn:0x0000.04b67d9805/02/0415:36:17Nextscn:0x0000.04b6d74d

470.RECID#22Recno22Recordtimestamp05/02/0415:36:18Thread=1Seq#=22Link-Recid=21

471.Lowscn:0x0000.04b6218905/02/0408:19:22Nextscn:0x0000.04b67d98

472.RECID#21Recno21Recordtimestamp05/02/0408:19:22Thread=1Seq#=21Link-Recid=20

473.Lowscn:0x0000.04b5a5f004/30/0407:32:34Nextscn:0x0000.04b62189

474.RECID#20Recno20Recordtimestamp04/30/0407:32:34Thread=1Seq#=20Link-Recid=19

475.Lowscn:0x0000.04b551b504/29/0417:10:52Nextscn:0x0000.04b5a5f0

476.RECID#19Recno19Recordtimestamp04/29/0417:10:52Thread=1Seq#=19Link-Recid=18

477.Lowscn:0x0000.04b4dfcd04/29/0408:47:27Nextscn:0x0000.04b551b5

478.RECID#18Recno18Recordtimestamp04/29/0408:47:27Thread=1Seq#=18Link-Recid=17

479.Lowscn:0x0000.04b47afe04/28/0415:47:36Nextscn:0x0000.04b4dfcd

480.RECID#17Recno17Recordtimestamp04/28/0415:47:36Thread=1Seq#=17Link-Recid=16

481.Lowscn:0x0000.04b426a904/28/0410:46:54Nextscn:0x0000.04b47afe

482.RECID#16Recno16Recordtimestamp04/28/0410:46:54Thread=1Seq#=16Link-Recid=15

483.Lowscn:0x0000.04b3d74504/28/0410:24:23Nextscn:0x0000.04b426a9

484.RECID#15Recno15Recordtimestamp04/28/0410:24:24Thread=1Seq#=15Link-Recid=14

485.Lowscn:0x0000.04b34c5404/27/0409:25:18Nextscn:0x0000.04b3d745

486.RECID#14Recno14Recordtimestamp04/27/0409:25:18Thread=1Seq#=14Link-Recid=13

487.Lowscn:0x0000.04b2db0204/17/0411:54:17Nextscn:0x0000.04b34c54

488.RECID#13Recno13Recordtimestamp04/17/0411:54:17Thread=1Seq#=13Link-Recid=12

489.Lowscn:0x0000.04b2778604/16/0419:06:32Nextscn:0x0000.04b2db02

490.RECID#12Recno12Recordtimestamp04/16/0419:06:32Thread=1Seq#=12Link-Recid=11

491.Lowscn:0x0000.04b225c504/03/0413:17:32Nextscn:0x0000.04b27786

492.RECID#11Recno11Recordtimestamp04/03/0413:17:32Thread=1Seq#=11Link-Recid=10

493.Lowscn:0x0000.04b1caec04/02/0413:37:07Nextscn:0x0000.04b225c5

494.RECID#10Recno10Recordtimestamp04/02/0413:37:08Thread=1Seq#=10Link-Recid=9

495.Lowscn:0x0000.04b1759e02/27/0413:42:16Nextscn:0x0000.04b1caec

496.RECID#9Recno9Recordtimestamp02/27/0413:42:16Thread=1Seq#=9Link-Recid=8

497.Lowscn:0x0000.04b10a6b02/14/0410:34:55Nextscn:0x0000.04b1759e

498.RECID#8Recno8Recordtimestamp02/14/0410:34:55Thread=1Seq#=8Link-Recid=7

499.Lowscn:0x0000.04b0a35402/13/0411:24:29Nextscn:0x0000.04b10a6b

500.RECID#7Recno7Recordtimestamp02/13/0411:24:29Thread=1Seq#=7Link-Recid=6

501.Lowscn:0x0000.04b046f002/11/0413:19:35Nextscn:0x0000.04b0a354

502.RECID#6Recno6Recordtimestamp02/11/0413:19:35Thread=1Seq#=6Link-Recid=5

503.Lowscn:0x0000.04af02f410/08/0308:53:42Nextscn:0x0000.04b046f0

504.RECID#5Recno5Recordtimestamp10/08/0308:53:42Thread=1Seq#=5Link-Recid=4

505.Lowscn:0x0000.04aeadbb08/08/0315:15:38Nextscn:0x0000.04af02f4

506.RECID#4Recno4Recordtimestamp08/08/0315:15:38Thread=1Seq#=4Link-Recid=3

507.Lowscn:0x0000.04ae599c07/20/0310:47:36Nextscn:0x0000.04aeadbb

508.RECID#3Recno3Recordtimestamp07/20/0310:47:36Thread=1Seq#=3Link-Recid=2

509.Lowscn:0x0000.04ae07a907/20/0309:43:05Nextscn:0x0000.04ae599c

510.RECID#2Recno2Recordtimestamp07/20/0309:43:05Thread=1Seq#=2Link-Recid=1

511.Lowscn:0x0000.04ae05fb07/20/0309:30:37Nextscn:0x0000.04ae07a9

512.RECID#1Recno1Recordtimestamp07/20/0309:30:37Thread=1Seq#=1Link-Recid=0

513.Lowscn:0x0000.04ada79607/13/0314:34:39Nextscn:0x0000.04ae05fb

脱机局限纪录项（该项从Oracle8入手下手引进）
514.******************************************************************

515.OFFLINERANGERECORDS

516.******************************************************************

517.(blkno=0x1b,size=56,max=145,in-use=0,last-recid=0)

回档日记纪录项（该项从Oracle8入手下手引进）
518.******************************************************************

519.ARCHIVEDLOGRECORDS

520.******************************************************************

521.(blkno=0x1c,size=584,max=237,in-use=31,last-recid=31)

522.Earliestrecord:

523.RECID#1Recno1Recordtimestamp07/20/0309:30:39Thread=1Seq#=1

524.Flags:<producedbyarchiveoperation><createdbytheARCHprocess>

525.Resetlogsscnandtimescn:0x0000.04ada79607/13/0314:34:39

526.filenameE:ORACLEORADATATESTARCHIVE1_1.ARC

527.Lowscn:0x0000.04ada79607/13/0314:34:39Nextscn:0x0000.04ae05fb07/20/0309:30:37

528.Blockcount=608Blocksize=512

529.Latestrecord:

530.RECID#31Recno31Recordtimestamp05/14/0408:37:00Thread=1Seq#=31

531.Flags:<producedbyarchiveoperation><createdbytheARCHprocess>

532.Resetlogsscnandtimescn:0x0000.04ada79607/13/0314:34:39

533.filenameE:ORACLEORADATATESTARCHIVE1_31.ARC

534.Lowscn:0x0000.04b9870a05/13/0419:43:45Nextscn:0x0000.04b9d85705/14/0408:36:59

535.Blockcount=306Blocksize=512

536.RECID#30Recno30Recordtimestamp05/13/0419:43:47Thread=1Seq#=30

537.Flags:<producedbyarchiveoperation><createdbytheARCHprocess>

538.Resetlogsscnandtimescn:0x0000.04ada79607/13/0314:34:39

539.filenameE:ORACLEORADATATESTARCHIVE1_30.ARC

540.Lowscn:0x0000.04b9301605/13/0416:31:24Nextscn:0x0000.04b9870a05/13/0419:43:45

541.Blockcount=346Blocksize=512

542.RECID#29Recno29Recordtimestamp05/13/0416:31:26Thread=1Seq#=29

543.Flags:<producedbyarchiveoperation><createdbytheARCHprocess>

544.Resetlogsscnandtimescn:0x0000.04ada79607/13/0314:34:39

545.filenameE:ORACLEORADATATESTARCHIVE1_29.ARC

546.Lowscn:0x0000.04b8b9ad05/11/0414:27:28Nextscn:0x0000.04b9301605/13/0416:31:24

547.Blockcount=1062Blocksize=512

548.RECID#28Recno28Recordtimestamp05/11/0414:27:33Thread=1Seq#=28

549.Flags:<producedbyarchiveoperation><createdbytheARCHprocess>

550.Resetlogsscnandtimescn:0x0000.04ada79607/13/0314:34:39

551.filenameE:ORACLEORADATATESTARCHIVE1_28.ARC

552.Lowscn:0x0000.04b854e405/11/0408:14:52Nextscn:0x0000.04b8b9ad05/11/0414:27:28

553.Blockcount=785Blocksize=512

554.RECID#27Recno27Recordtimestamp05/11/0408:15:01Thread=1Seq#=27

555.Flags:<producedbyarchiveoperation><createdbytheARCHprocess>

556.Resetlogsscnandtimescn:0x0000.04ada79607/13/0314:34:39

557.filenameE:ORACLEORADATATESTARCHIVE1_27.ARC

558.Lowscn:0x0000.04b7efc305/10/0418:00:17Nextscn:0x0000.04b854e405/11/0408:14:52

559.Blockcount=38044Blocksize=512

560.RECID#26Recno26Recordtimestamp05/10/0418:00:30Thread=1Seq#=26

561.Flags:<producedbyarchiveoperation><createdbytheARCHprocess>

562.Resetlogsscnandtimescn:0x0000.04ada79607/13/0314:34:39

563.filenameE:ORACLEORADATATESTARCHIVE1_26.ARC

564.Lowscn:0x0000.04b7d71605/10/0413:16:04Nextscn:0x0000.04b7efc305/10/0418:00:17

565.Blockcount=61433Blocksize=512

566.RECID#25Recno25Recordtimestamp05/10/0413:16:07Thread=1Seq#=25

567.Flags:<producedbyarchiveoperation><createdbytheARCHprocess>

568.Resetlogsscnandtimescn:0x0000.04ada79607/13/0314:34:39

569.filenameE:ORACLEORADATATESTARCHIVE1_25.ARC

570.Lowscn:0x0000.04b759e605/09/0408:41:38Nextscn:0x0000.04b7d71605/10/0413:16:04

571.Blockcount=909Blocksize=512

572.RECID#24Recno24Recordtimestamp05/09/0408:41:43Thread=1Seq#=24

573.Flags:<producedbyarchiveoperation><createdbytheARCHprocess>

574.Resetlogsscnandtimescn:0x0000.04ada79607/13/0314:34:39

575.filenameE:ORACLEORADATATESTARCHIVE1_24.ARC

576.Lowscn:0x0000.04b6d74d05/08/0409:45:10Nextscn:0x0000.04b759e605/09/0408:41:38

577.Blockcount=21946Blocksize=512

578.RECID#23Recno23Recordtimestamp05/08/0409:45:14Thread=1Seq#=23

579.Flags:<producedbyarchiveoperation><createdbytheARCHprocess>

580.Resetlogsscnandtimescn:0x0000.04ada79607/13/0314:34:39

581.filenameE:ORACLEORADATATESTARCHIVE1_23.ARC

582.Lowscn:0x0000.04b67d9805/02/0415:36:17Nextscn:0x0000.04b6d74d05/08/0409:45:10

583.Blockcount=11872Blocksize=512

584.RECID#22Recno22Recordtimestamp05/02/0415:36:19Thread=1Seq#=22

585.Flags:<producedbyarchiveoperation><createdbytheARCHprocess>

586.Resetlogsscnandtimescn:0x0000.04ada79607/13/0314:34:39

587.filenameE:ORACLEORADATATESTARCHIVE1_22.ARC

588.Lowscn:0x0000.04b6218905/02/0408:19:22Nextscn:0x0000.04b67d9805/02/0415:36:17

589.Blockcount=373Blocksize=512

590.RECID#21Recno21Recordtimestamp05/02/0408:19:24Thread=1Seq#=21

591.Flags:<producedbyarchiveoperation><createdbytheARCHprocess>

592.Resetlogsscnandtimescn:0x0000.04ada79607/13/0314:34:39

593.filenameE:ORACLEORADATATESTARCHIVE1_21.ARC

594.Lowscn:0x0000.04b5a5f004/30/0407:32:34Nextscn:0x0000.04b6218905/02/0408:19:22

595.Blockcount=645Blocksize=512

596.RECID#20Recno20Recordtimestamp04/30/0407:32:37Thread=1Seq#=20

597.Flags:<producedbyarchiveoperation><createdbytheARCHprocess>

598.Resetlogsscnandtimescn:0x0000.04ada79607/13/0314:34:39

599.filenameE:ORACLEORADATATESTARCHIVE1_20.ARC

600.Lowscn:0x0000.04b551b504/29/0417:10:52Nextscn:0x0000.04b5a5f004/30/0407:32:34

601.Blockcount=378Blocksize=512

602.RECID#19Recno19Recordtimestamp04/29/0417:10:54Thread=1Seq#=19

603.Flags:<producedbyarchiveoperation><createdbytheARCHprocess>

604.Resetlogsscnandtimescn:0x0000.04ada79607/13/0314:34:39

605.filenameE:ORACLEORADATATESTARCHIVE1_19.ARC

606.Lowscn:0x0000.04b4dfcd04/29/0408:47:27Nextscn:0x0000.04b551b504/29/0417:10:52

607.Blockcount=711Blocksize=512

608.RECID#18Recno18Recordtimestamp04/29/0408:47:31Thread=1Seq#=18

609.Flags:<producedbyarchiveoperation><createdbytheARCHprocess>

610.Resetlogsscnandtimescn:0x0000.04ada79607/13/0314:34:39

611.filenameE:ORACLEORADATATESTARCHIVE1_18.ARC

612.Lowscn:0x0000.04b47afe04/28/0415:47:36Nextscn:0x0000.04b4dfcd04/29/0408:47:27

613.Blockcount=471Blocksize=512

614.RECID#17Recno17Recordtimestamp04/28/0415:47:38Thread=1Seq#=17

615.Flags:<producedbyarchiveoperation><createdbytheARCHprocess>

616.Resetlogsscnandtimescn:0x0000.04ada79607/13/0314:34:39

617.filenameE:ORACLEORADATATESTARCHIVE1_17.ARC

618.Lowscn:0x0000.04b426a904/28/0410:46:54Nextscn:0x0000.04b47afe04/28/0415:47:36

619.Blockcount=336Blocksize=512

620.RECID#16Recno16Recordtimestamp04/28/0410:46:56Thread=1Seq#=16

621.Flags:<producedbyarchiveoperation><createdbytheARCHprocess>

622.Resetlogsscnandtimescn:0x0000.04ada79607/13/0314:34:39

623.filenameE:ORACLEORADATATESTARCHIVE1_16.ARC

624.Lowscn:0x0000.04b3d74504/28/0410:24:23Nextscn:0x0000.04b426a904/28/0410:46:54

625.Blockcount=272Blocksize=512

626.RECID#15Recno15Recordtimestamp04/28/0410:24:26Thread=1Seq#=15

627.Flags:<producedbyarchiveoperation><createdbytheARCHprocess>

628.Resetlogsscnandtimescn:0x0000.04ada79607/13/0314:34:39

629.filenameE:ORACLEORADATATESTARCHIVE1_15.ARC

630.Lowscn:0x0000.04b34c5404/27/0409:25:18Nextscn:0x0000.04b3d74504/28/0410:24:23

631.Blockcount=755Blocksize=512

632.RECID#14Recno14Recordtimestamp04/27/0409:25:22Thread=1Seq#=14

633.Flags:<producedbyarchiveoperation><createdbytheARCHprocess>

634.Resetlogsscnandtimescn:0x0000.04ada79607/13/0314:34:39

635.filenameE:ORACLEORADATATESTARCHIVE1_14.ARC

636.Lowscn:0x0000.04b2db0204/17/0411:54:17Nextscn:0x0000.04b34c5404/27/0409:25:18

637.Blockcount=7292Blocksize=512

638.RECID#13Recno13Recordtimestamp04/17/0411:54:19Thread=1Seq#=13

639.Flags:<producedbyarchiveoperation><createdbytheARCHprocess>

640.Resetlogsscnandtimescn:0x0000.04ada79607/13/0314:34:39

641.filenameE:ORACLEORADATATESTARCHIVE1_13.ARC

642.Lowscn:0x0000.04b2778604/16/0419:06:32Nextscn:0x0000.04b2db0204/17/0411:54:17

643.Blockcount=414Blocksize=512

644.RECID#12Recno12Recordtimestamp04/16/0419:06:34Thread=1Seq#=12

645.Flags:<producedbyarchiveoperation><createdbytheARCHprocess>

646.Resetlogsscnandtimescn:0x0000.04ada79607/13/0314:34:39

647.filenameE:ORACLEORADATATESTARCHIVE1_12.ARC

648.Lowscn:0x0000.04b225c504/03/0413:17:32Nextscn:0x0000.04b2778604/16/0419:06:32

649.Blockcount=285Blocksize=512

650.RECID#11Recno11Recordtimestamp04/03/0413:17:33Thread=1Seq#=11

651.Flags:<producedbyarchiveoperation><createdbytheARCHprocess>

652.Resetlogsscnandtimescn:0x0000.04ada79607/13/0314:34:39

653.filenameE:ORACLEORADATATESTARCHIVE1_11.ARC

654.Lowscn:0x0000.04b1caec04/02/0413:37:07Nextscn:0x0000.04b225c504/03/0413:17:32

655.Blockcount=350Blocksize=512

656.RECID#10Recno10Recordtimestamp04/02/0413:37:09Thread=1Seq#=10

657.Flags:<producedbyarchiveoperation><createdbytheARCHprocess>

658.Resetlogsscnandtimescn:0x0000.04ada79607/13/0314:34:39

659.filenameE:ORACLEORADATATESTARCHIVE1_10.ARC

660.Lowscn:0x0000.04b1759e02/27/0413:42:16Nextscn:0x0000.04b1caec04/02/0413:37:07

661.Blockcount=305Blocksize=512

662.RECID#9Recno9Recordtimestamp02/27/0413:42:18Thread=1Seq#=9

663.Flags:<producedbyarchiveoperation><createdbytheARCHprocess>

664.Resetlogsscnandtimescn:0x0000.04ada79607/13/0314:34:39

665.filenameE:ORACLEORADATATESTARCHIVE1_9.ARC

666.Lowscn:0x0000.04b10a6b02/14/0410:34:55Nextscn:0x0000.04b1759e02/27/0413:42:16

667.Blockcount=683Blocksize=512

668.RECID#8Recno8Recordtimestamp02/14/0410:34:57Thread=1Seq#=8

669.Flags:<producedbyarchiveoperation><createdbytheARCHprocess>

670.Resetlogsscnandtimescn:0x0000.04ada79607/13/0314:34:39

671.filenameE:ORACLEORADATATESTARCHIVE1_8.ARC

672.Lowscn:0x0000.04b0a35402/13/0411:24:29Nextscn:0x0000.04b10a6b02/14/0410:34:55

673.Blockcount=466Blocksize=512

674.RECID#7Recno7Recordtimestamp02/13/0411:24:31Thread=1Seq#=7

675.Flags:<producedbyarchiveoperation><createdbytheARCHprocess>

676.Resetlogsscnandtimescn:0x0000.04ada79607/13/0314:34:39

677.filenameE:ORACLEORADATATESTARCHIVE1_7.ARC

678.Lowscn:0x0000.04b046f002/11/0413:19:35Nextscn:0x0000.04b0a35402/13/0411:24:29

679.Blockcount=363Blocksize=512

680.RECID#6Recno6Recordtimestamp02/11/0413:19:37Thread=1Seq#=6

681.Flags:<producedbyarchiveoperation><createdbytheARCHprocess>

682.Resetlogsscnandtimescn:0x0000.04ada79607/13/0314:34:39

683.filenameE:ORACLEORADATATESTARCHIVE1_6.ARC

684.Lowscn:0x0000.04af02f410/08/0308:53:42Nextscn:0x0000.04b046f002/11/0413:19:35

685.Blockcount=2464Blocksize=512

686.RECID#5Recno5Recordtimestamp10/08/0308:53:44Thread=1Seq#=5

687.Flags:<producedbyarchiveoperation><createdbytheARCHprocess>

688.Resetlogsscnandtimescn:0x0000.04ada79607/13/0314:34:39

689.filenameE:ORACLEORADATATESTARCHIVE1_5.ARC

690.Lowscn:0x0000.04aeadbb08/08/0315:15:38Nextscn:0x0000.04af02f410/08/0308:53:42

691.Blockcount=384Blocksize=512

692.RECID#4Recno4Recordtimestamp08/08/0315:15:41Thread=1Seq#=4

693.Flags:<producedbyarchiveoperation><createdbytheARCHprocess>

694.Resetlogsscnandtimescn:0x0000.04ada79607/13/0314:34:39

695.filenameE:ORACLEORADATATESTARCHIVE1_4.ARC

696.Lowscn:0x0000.04ae599c07/20/0310:47:36Nextscn:0x0000.04aeadbb08/08/0315:15:38

697.Blockcount=302Blocksize=512

698.RECID#3Recno3Recordtimestamp07/20/0310:47:37Thread=1Seq#=3

699.Flags:<producedbyarchiveoperation><createdbytheARCHprocess>

700.Resetlogsscnandtimescn:0x0000.04ada79607/13/0314:34:39

701.filenameE:ORACLEORADATATESTARCHIVE1_3.ARC

702.Lowscn:0x0000.04ae07a907/20/0309:43:05Nextscn:0x0000.04ae599c07/20/0310:47:36

703.Blockcount=41Blocksize=512

704.RECID#2Recno2Recordtimestamp07/20/0309:43:05Thread=1Seq#=2

705.Flags:<producedbyarchiveoperation><createdbytheforegroundprocess>

706.Resetlogsscnandtimescn:0x0000.04ada79607/13/0314:34:39

707.filenameE:ORACLEORADATATESTARCHIVE1_2.ARC

708.Lowscn:0x0000.04ae05fb07/20/0309:30:37Nextscn:0x0000.04ae07a907/20/0309:43:05

709.Blockcount=385Blocksize=512

710.RECID#1Recno1Recordtimestamp07/20/0309:30:39Thread=1Seq#=1

711.Flags:<producedbyarchiveoperation><createdbytheARCHprocess>

712.Resetlogsscnandtimescn:0x0000.04ada79607/13/0314:34:39

713.filenameE:ORACLEORADATATESTARCHIVE1_1.ARC

714.Lowscn:0x0000.04ada79607/13/0314:34:39Nextscn:0x0000.04ae05fb07/20/0309:30:37

715.Blockcount=608Blocksize=512

利用Rman备份数据库的备份集纪录项（该项从Oracle8入手下手引进）
716.******************************************************************

717.BACKUPSETRECORDS

718.******************************************************************

719.(blkno=0x2d,size=40,max=204,in-use=0,last-recid=0)

利用Rman备份数据库的备份片纪录项（该项从Oracle8入手下手引进）
720.******************************************************************

721.BACKUPPIECERECORDS

722.******************************************************************

723.(blkno=0x2e,size=736,max=210,in-use=0,last-recid=0)

利用Rman备份数据库的备份数据文件的纪录项（该项从Oracle8入手下手引进）
724.******************************************************************

725.BACKUPDATAFILERECORDS

726.******************************************************************

727.(blkno=0x41,size=116,max=211,in-use=0,last-recid=0)

利用Rman备份数据库的备份回档日记文件的纪录项（该项从Oracle8入手下手引进）
728.******************************************************************

729.BACKUPLOGRECORDS

730.******************************************************************

731.(blkno=0x44,size=76,max=107,in-use=0,last-recid=0)

利用Rman备份数据库时数据文件拷贝的纪录项（该项从Oracle8入手下手引进）
732.******************************************************************

733.DATAFILECOPYRECORDS

734.******************************************************************

735.(blkno=0x45,size=660,max=210,in-use=1,last-recid=1)

736.Earliestrecord:

737.RECID#1Recno1Recordtimestamp07/20/0309:43:04

738.File=0(0)databaseid=1750352942blocksize=8192

739.Flags:

740.Filename:D:HOT_BACKUPCONTROL02.CTL

741.Creationcheckpointedatscn:0x0000.0000000007/13/0314:30:52

742.Fileheadercheckpointedatscn:0x0000.04ae079e07/20/0309:43:02

743.Resetlogsscnandtimescn:0x0000.04ada79607/13/0314:34:39

744.RecoveryFuzzyscnandtimescn:0x0000.0000000001/01/8800:00:00

745.AbsoluteFuzzyscn:0x0000.00000000

746.Newly-markedmediacorruptblocks0Totalmediacorruptblocks0

747.Totallogicallycorruptblocks0Blockimageswrittentobackup228

748.LowOfflineRangeRecid0

749.Tag:

750.Copydoesnothavekeepoptions.

751.Latestrecord:

752.RECID#1Recno1Recordtimestamp07/20/03与其他数据库相比，MySQL易学易用。

作者: 小女巫 时间: 2015-1-19 21:20
需要注意的一点，也是我使用过程中发现的一个问题。在建立function->schema->table后，如果在现有的分区表上建立没有显式声明的聚集索引时，分区表会自动变为非分区表。这一点很让我纳闷。

作者: 爱飞 时间: 2015-1-28 05:38
语句级快照和事务级快照终于为SQLServer的并发性能带来了突破。个人感觉语句级快照大家应该应用。事务级快照，如果是高并发系统还要慎用。如果一个用户总是被提示修改不成功要求重试时，会杀人的！

作者: 只想知道 时间: 2015-2-5 12:30
原来公司用过MYSQL自己也只是建个表写个SQL

作者: 第二个灵魂 时间: 2015-2-11 20:31
原来的计算字段其实和虚拟字段很像。只是管理方面好了而已，性能方面提高不多。但是SQL2005提供了计算字段的持久化，这就提高了查询的性能，但是会加重insert和update的负担。OLTP慎用。OLAP可以大规模使用。

作者: 金色的骷髅 时间: 2015-3-2 18:25
习惯敲命令行的朋友可能会爽一些。但是功能有限。适合机器跑不动SQLServerManagementStudio的朋友使用。

作者: 精灵巫婆 时间: 2015-3-11 05:27
连做梦都在想页面结构是怎么样的，绝非虚言

作者: 小魔女 时间: 2015-3-17 21:10
始终遗憾SQLServer的登陆无法分配CPU/内存占用等指标数。如果你的SQLServer给别人分配了一个只可以读几个表的权限，而这个家伙疯狂的死循环进行连接查询，会给你的系统带来很大的负担。

欢迎光临仓酷云 (http://ckuyun.com/)