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易学易用。 需要注意的一点，也是我使用过程中发现的一个问题。在建立function->schema->table后，如果在现有的分区表上建立没有显式声明的聚集索引时，分区表会自动变为非分区表。这一点很让我纳闷。 语句级快照和事务级快照终于为SQLServer的并发性能带来了突破。个人感觉语句级快照大家应该应用。事务级快照，如果是高并发系统还要慎用。如果一个用户总是被提示修改不成功要求重试时，会杀人的！ 原来公司用过MYSQL自己也只是建个表写个SQL 原来的计算字段其实和虚拟字段很像。只是管理方面好了而已，性能方面提高不多。但是SQL2005提供了计算字段的持久化，这就提高了查询的性能，但是会加重insert和update的负担。OLTP慎用。OLAP可以大规模使用。 习惯敲命令行的朋友可能会爽一些。但是功能有限。适合机器跑不动SQLServerManagementStudio的朋友使用。 连做梦都在想页面结构是怎么样的，绝非虚言 始终遗憾SQLServer的登陆无法分配CPU/内存占用等指标数。如果你的SQLServer给别人分配了一个只可以读几个表的权限，而这个家伙疯狂的死循环进行连接查询，会给你的系统带来很大的负担。
页:
[1]