解读Oracle 9201的控制文件 (二)


311. DATA FILE #12:

  1<deleted>
  2
  3312.creation size=1280 block size=8192 status=0x800 head=0 tail=0 dup=0 
  4
  5313.tablespace 18, index=14 krfil=12 prev_file=0 
  6
  7314.unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00 
  8
  9315.Checkpoint cnt:3 scn: 0x0000.04b7e874 05/10/2004 16:45:12 
 10
 11316.Stop scn: 0x0000.04b7e874 05/10/2004 16:45:12 
 12
 13317.Creation Checkpointed at scn: 0x0000.04b7e496 05/10/2004 16:04:32 
 14
 15318.thread:1 rba:(0x1a.17d.10) 
 16
 17319.enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000 
 18
 19320.00000000 00000000 
 20
 21321.Offline scn: 0x0000.00000000 prev_range: 0 
 22
 23322.Online Checkpointed at scn: 0x0000.00000000 
 24
 25323.thread:0 rba:(0x0.0.0) 
 26
 27324.enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000 
 28
 29325.00000000 00000000 
 30
 31326.Hot Backup end marker scn: 0x0000.00000000 
 32
 33327.aux_file is NOT DEFINED 
 34
 35328\. DATA FILE #13: <deleted>
 36
 37329.creation size=0 block size=0 status=0x0 head=0 tail=0 dup=0 
 38
 39330.tablespace 0, index=0 krfil=0 prev_file=0 
 40
 41331.unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00 
 42
 43332.Checkpoint cnt:0 scn: 0x0000.00000000 01/01/1988 00:00:00 
 44
 45333.Stop scn: 0x0000.00000000 01/01/1988 00:00:00 
 46
 47334.Creation Checkpointed at scn: 0x0000.00000000 
 48
 49335.thread:0 rba:(0x0.0.0) 
 50
 51336.enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000 
 52
 53337.00000000 00000000 
 54
 55338.Offline scn: 0x0000.00000000 prev_range: 0 
 56
 57339.Online Checkpointed at scn: 0x0000.00000000 
 58
 59340.thread:0 rba:(0x0.0.0) 
 60
 61341.enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000 
 62
 63342.00000000 00000000 
 64
 65343.Hot Backup end marker scn: 0x0000.00000000 
 66
 67344.aux_file=0 
 68
 69345\. DATA FILE #14: 
 70
 71346.(name #6) E:\ORACLE\ORA92\TEST\XPRT01.DBF 
 72
 73347.creation size=0 block size=8192 status=0xe head=6 tail=6 dup=1 
 74
 75348.tablespace 16, index=12 krfil=14 prev_file=0 
 76
 77349.unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00 
 78
 79350.Checkpoint cnt:187 scn: 0x0000.04b9d858 05/14/2004 08:36:59 
 80
 81351.Stop scn: 0xffff.ffffffff 05/13/2004 20:18:03 
 82
 83352.Creation Checkpointed at scn: 0x0000.04a3fd9c 05/28/2003 15:06:11 
 84
 85353.thread:0 rba:(0x0.0.0) 
 86
 87354.enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000 
 88
 89355.00000000 00000000 
 90
 91356.Offline scn: 0x0000.04ada795 prev_range: 0 
 92
 93357.Online Checkpointed at scn: 0x0000.04ada796 07/13/2003 14:34:39 
 94
 95358.thread:1 rba:(0x1.2.0) 
 96
 97359.enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000 
 98
 99360.00000000 00000000 
100
101361.Hot Backup end marker scn: 0x0000.00000000 
102
103362.aux_file is NOT DEFINED 
104
105临时文件记录项(该项从Oracle9i开始引入)   
106363\. ****************************************************************** 
107
108364\. TEMP FILE RECORDS 
109
110365\. ****************************************************************** 
111
112366.(blkno = 0x12, size = 56, max = 100, in-use = 1, last-recid= 1) 
113
114367.TEMP FILE #1: External File #201 
115
116368.(name #18) E:\ORACLE\ORA92\TEST\TEMP.DBF 
117
118369.creation size=2560 block size=8192 status=0xe head=18 tail=18 dup=1 
119
120370.tablespace 2, index=13 krfil=1 prev_file=0 
121
122371.unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00 
123
124表空间记录项(该项从Oracle8开始引入)   
125372\. ****************************************************************** 
126
127373\. TABLESPACE RECORDS 
128
129374\. ****************************************************************** 
130
131375.(blkno = 0x11, size = 68, max = 100, in-use = 16, last-recid= 9) 
132
133376.TABLESPACE #0 SYSTEM: recno=1 
134
135377.First datafile link=1 Tablespace Flag=0 
136
137378.Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00 
138
139379.Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00 
140
141380.TABLESPACE #1 UNDOTBS1: recno=2 
142
143381.First datafile link=2 Tablespace Flag=0 
144
145382.Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00 
146
147383.Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00 
148
149384.TABLESPACE #3 DRSYS: recno=3 
150
151385.First datafile link=3 Tablespace Flag=0 
152
153386.Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00 
154
155387.Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00 
156
157388.TABLESPACE #4 INDX: recno=4 
158
159389.First datafile link=4 Tablespace Flag=0 
160
161390.Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00 
162
163391.Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00 
164
165392.TABLESPACE #5 TOOLS: recno=5 
166
167393.First datafile link=5 Tablespace Flag=0 
168
169394.Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00 
170
171395.Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00 
172
173396.TABLESPACE #6 USERS: recno=6 
174
175397.First datafile link=6 Tablespace Flag=0 
176
177398.Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00 
178
179399.Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00 
180
181400.TABLESPACE #7 XDB: recno=7 
182
183401.First datafile link=7 Tablespace Flag=0 
184
185402.Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00 
186
187403.Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00 
188
189404.TABLESPACE #11 TEST: recno=8 
190
191405.First datafile link=8 Tablespace Flag=0 
192
193406.Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00 
194
195407.Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00 
196
197408.TABLESPACE #9 RMAN: recno=9 
198
199409.First datafile link=9 Tablespace Flag=0 
200
201410.Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00 
202
203411.Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00 
204
205412.TABLESPACE #12 PERFSTAT: recno=10 
206
207413.First datafile link=10 Tablespace Flag=0 
208
209414.Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00 
210
211415.Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00 
212
213416.TABLESPACE #8 UNDOTBS2: recno=11 
214
215417.First datafile link=11 Tablespace Flag=0 
216
217418.Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00 
218
219419.Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00 
220
221420.TABLESPACE #16 XPRT: recno=12 
222
223421.First datafile link=14 Tablespace Flag=0 
224
225422.Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00 
226
227423.Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00 
228
229424.TABLESPACE #2 TEMP: recno=13 
230
231425.First datafile link=1 Tablespace Flag=1 
232
233426.Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00 
234
235427.Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00 
236
237428.TABLESPACE #2147483647 UNDO_TEST: recno=14 
238
239429.First datafile link=0 Tablespace Flag=0 
240
241430.Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00 
242
243431.Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00 
244
245432.TABLESPACE #2147483647 SORT: recno=15 
246
247433.First datafile link=0 Tablespace Flag=1 
248
249434.Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00 
250
251435.Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00 
252
253436.TABLESPACE #2147483647 LUNARTEMP: recno=16 
254
255437.First datafile link=0 Tablespace Flag=1 
256
257438.Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00 
258
259439.Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00 
260
261Rman配置记录项(该项从Oracle9i开始引入)   
262440\. ****************************************************************** 
263
264441\. RMAN CONFIGURATION RECORDS 
265
266442\. ****************************************************************** 
267
268443.(blkno = 0x13, size = 1108, max = 50, in-use = 0, last-recid= 0) 
269
270日志文件历史记录项   
271444\. ****************************************************************** 
272
273445\. LOG FILE HISTORY RECORDS 
274
275446\. ****************************************************************** 
276
277447.(blkno = 0x1a, size = 36, max = 226, in-use = 31, last-recid= 31) 
278
279448.Earliest record: 
280
281449.RECID #1 Recno 1 Record timestamp 07/20/03 09:30:37 Thread=1 Seq#=1 Link-Recid=0 
282
283450.Low scn: 0x0000.04ada796 07/13/03 14:34:39 Next scn: 0x0000.04ae05fb 
284
285451.Latest record: 
286
287452.RECID #31 Recno 31 Record timestamp 05/14/04 08:36:59 Thread=1 Seq#=31 Link-Recid=30 
288
289453.Low scn: 0x0000.04b9870a 05/13/04 19:43:45 Next scn: 0x0000.04b9d857 
290
291454.RECID #30 Recno 30 Record timestamp 05/13/04 19:43:45 Thread=1 Seq#=30 Link-Recid=29 
292
293455.Low scn: 0x0000.04b93016 05/13/04 16:31:24 Next scn: 0x0000.04b9870a 
294
295456.RECID #29 Recno 29 Record timestamp 05/13/04 16:31:24 Thread=1 Seq#=29 Link-Recid=28 
296
297457.Low scn: 0x0000.04b8b9ad 05/11/04 14:27:28 Next scn: 0x0000.04b93016 
298
299458.RECID #28 Recno 28 Record timestamp 05/11/04 14:27:29 Thread=1 Seq#=28 Link-Recid=27 
300
301459.Low scn: 0x0000.04b854e4 05/11/04 08:14:52 Next scn: 0x0000.04b8b9ad 
302
303460.RECID #27 Recno 27 Record timestamp 05/11/04 08:14:52 Thread=1 Seq#=27 Link-Recid=26 
304
305461.Low scn: 0x0000.04b7efc3 05/10/04 18:00:17 Next scn: 0x0000.04b854e4 
306
307462.RECID #26 Recno 26 Record timestamp 05/10/04 18:00:17 Thread=1 Seq#=26 Link-Recid=25 
308
309463.Low scn: 0x0000.04b7d716 05/10/04 13:16:04 Next scn: 0x0000.04b7efc3 
310
311464.RECID #25 Recno 25 Record timestamp 05/10/04 13:16:05 Thread=1 Seq#=25 Link-Recid=24 
312
313465.Low scn: 0x0000.04b759e6 05/09/04 08:41:38 Next scn: 0x0000.04b7d716 
314
315466.RECID #24 Recno 24 Record timestamp 05/09/04 08:41:38 Thread=1 Seq#=24 Link-Recid=23 
316
317467.Low scn: 0x0000.04b6d74d 05/08/04 09:45:10 Next scn: 0x0000.04b759e6 
318
319468.RECID #23 Recno 23 Record timestamp 05/08/04 09:45:10 Thread=1 Seq#=23 Link-Recid=22 
320
321469.Low scn: 0x0000.04b67d98 05/02/04 15:36:17 Next scn: 0x0000.04b6d74d 
322
323470.RECID #22 Recno 22 Record timestamp 05/02/04 15:36:18 Thread=1 Seq#=22 Link-Recid=21 
324
325471.Low scn: 0x0000.04b62189 05/02/04 08:19:22 Next scn: 0x0000.04b67d98 
326
327472.RECID #21 Recno 21 Record timestamp 05/02/04 08:19:22 Thread=1 Seq#=21 Link-Recid=20 
328
329473.Low scn: 0x0000.04b5a5f0 04/30/04 07:32:34 Next scn: 0x0000.04b62189 
330
331474.RECID #20 Recno 20 Record timestamp 04/30/04 07:32:34 Thread=1 Seq#=20 Link-Recid=19 
332
333475.Low scn: 0x0000.04b551b5 04/29/04 17:10:52 Next scn: 0x0000.04b5a5f0 
334
335476.RECID #19 Recno 19 Record timestamp 04/29/04 17:10:52 Thread=1 Seq#=19 Link-Recid=18 
336
337477.Low scn: 0x0000.04b4dfcd 04/29/04 08:47:27 Next scn: 0x0000.04b551b5 
338
339478.RECID #18 Recno 18 Record timestamp 04/29/04 08:47:27 Thread=1 Seq#=18 Link-Recid=17 
340
341479.Low scn: 0x0000.04b47afe 04/28/04 15:47:36 Next scn: 0x0000.04b4dfcd 
342
343480.RECID #17 Recno 17 Record timestamp 04/28/04 15:47:36 Thread=1 Seq#=17 Link-Recid=16 
344
345481.Low scn: 0x0000.04b426a9 04/28/04 10:46:54 Next scn: 0x0000.04b47afe 
346
347482.RECID #16 Recno 16 Record timestamp 04/28/04 10:46:54 Thread=1 Seq#=16 Link-Recid=15 
348
349483.Low scn: 0x0000.04b3d745 04/28/04 10:24:23 Next scn: 0x0000.04b426a9 
350
351484.RECID #15 Recno 15 Record timestamp 04/28/04 10:24:24 Thread=1 Seq#=15 Link-Recid=14 
352
353485.Low scn: 0x0000.04b34c54 04/27/04 09:25:18 Next scn: 0x0000.04b3d745 
354
355486.RECID #14 Recno 14 Record timestamp 04/27/04 09:25:18 Thread=1 Seq#=14 Link-Recid=13 
356
357487.Low scn: 0x0000.04b2db02 04/17/04 11:54:17 Next scn: 0x0000.04b34c54 
358
359488.RECID #13 Recno 13 Record timestamp 04/17/04 11:54:17 Thread=1 Seq#=13 Link-Recid=12 
360
361489.Low scn: 0x0000.04b27786 04/16/04 19:06:32 Next scn: 0x0000.04b2db02 
362
363490.RECID #12 Recno 12 Record timestamp 04/16/04 19:06:32 Thread=1 Seq#=12 Link-Recid=11 
364
365491.Low scn: 0x0000.04b225c5 04/03/04 13:17:32 Next scn: 0x0000.04b27786 
366
367492.RECID #11 Recno 11 Record timestamp 04/03/04 13:17:32 Thread=1 Seq#=11 Link-Recid=10 
368
369493.Low scn: 0x0000.04b1caec 04/02/04 13:37:07 Next scn: 0x0000.04b225c5 
370
371494.RECID #10 Recno 10 Record timestamp 04/02/04 13:37:08 Thread=1 Seq#=10 Link-Recid=9 
372
373495.Low scn: 0x0000.04b1759e 02/27/04 13:42:16 Next scn: 0x0000.04b1caec 
374
375496.RECID #9 Recno 9 Record timestamp 02/27/04 13:42:16 Thread=1 Seq#=9 Link-Recid=8 
376
377497.Low scn: 0x0000.04b10a6b 02/14/04 10:34:55 Next scn: 0x0000.04b1759e 
378
379498.RECID #8 Recno 8 Record timestamp 02/14/04 10:34:55 Thread=1 Seq#=8 Link-Recid=7 
380
381499.Low scn: 0x0000.04b0a354 02/13/04 11:24:29 Next scn: 0x0000.04b10a6b 
382
383500.RECID #7 Recno 7 Record timestamp 02/13/04 11:24:29 Thread=1 Seq#=7 Link-Recid=6 
384
385501.Low scn: 0x0000.04b046f0 02/11/04 13:19:35 Next scn: 0x0000.04b0a354 
386
387502.RECID #6 Recno 6 Record timestamp 02/11/04 13:19:35 Thread=1 Seq#=6 Link-Recid=5 
388
389503.Low scn: 0x0000.04af02f4 10/08/03 08:53:42 Next scn: 0x0000.04b046f0 
390
391504.RECID #5 Recno 5 Record timestamp 10/08/03 08:53:42 Thread=1 Seq#=5 Link-Recid=4 
392
393505.Low scn: 0x0000.04aeadbb 08/08/03 15:15:38 Next scn: 0x0000.04af02f4 
394
395506.RECID #4 Recno 4 Record timestamp 08/08/03 15:15:38 Thread=1 Seq#=4 Link-Recid=3 
396
397507.Low scn: 0x0000.04ae599c 07/20/03 10:47:36 Next scn: 0x0000.04aeadbb 
398
399508.RECID #3 Recno 3 Record timestamp 07/20/03 10:47:36 Thread=1 Seq#=3 Link-Recid=2 
400
401509.Low scn: 0x0000.04ae07a9 07/20/03 09:43:05 Next scn: 0x0000.04ae599c 
402
403510.RECID #2 Recno 2 Record timestamp 07/20/03 09:43:05 Thread=1 Seq#=2 Link-Recid=1 
404
405511.Low scn: 0x0000.04ae05fb 07/20/03 09:30:37 Next scn: 0x0000.04ae07a9 
406
407512.RECID #1 Recno 1 Record timestamp 07/20/03 09:30:37 Thread=1 Seq#=1 Link-Recid=0 
408
409513.Low scn: 0x0000.04ada796 07/13/03 14:34:39 Next scn: 0x0000.04ae05fb 
410
411脱机范围记录项(该项从Oracle8开始引入)   
412514\. ****************************************************************** 
413
414515\. OFFLINE RANGE RECORDS 
415
416516\. ****************************************************************** 
417
418517.(blkno = 0x1b, size = 56, max = 145, in-use = 0, last-recid= 0) 
419
420归档日志记录项(该项从Oracle8开始引入)   
421518\. ****************************************************************** 
422
423519\. ARCHIVED LOG RECORDS 
424
425520\. ****************************************************************** 
426
427521.(blkno = 0x1c, size = 584, max = 237, in-use = 31, last-recid= 31) 
428
429522.Earliest record: 
430
431523.RECID #1 Recno 1 Record timestamp 07/20/03 09:30:39 Thread=1 Seq#=1 
432
433524.Flags: <produced archive="" by="" operation=""> <created arch="" by="" process="" the="">
434
435525.Resetlogs scn and time scn: 0x0000.04ada796 07/13/03 14:34:39 
436
437526.filename E:\ORACLE\ORADATA\TEST\ARCHIVE_1.ARC 
438
439527.Low scn: 0x0000.04ada796 07/13/03 14:34:39 Next scn: 0x0000.04ae05fb 07/20/03 09:30:37 
440
441528.Block count=608 Blocksize=512 
442
443529.Latest record: 
444
445530.RECID #31 Recno 31 Record timestamp 05/14/04 08:37:00 Thread=1 Seq#=31 
446
447531.Flags: <produced archive="" by="" operation=""> <created arch="" by="" process="" the="">
448
449532.Resetlogs scn and time scn: 0x0000.04ada796 07/13/03 14:34:39 
450
451533.filename E:\ORACLE\ORADATA\TEST\ARCHIVE_31.ARC 
452
453534.Low scn: 0x0000.04b9870a 05/13/04 19:43:45 Next scn: 0x0000.04b9d857 05/14/04 08:36:59 
454
455535.Block count=306 Blocksize=512 
456
457536.RECID #30 Recno 30 Record timestamp 05/13/04 19:43:47 Thread=1 Seq#=30 
458
459537.Flags: <produced archive="" by="" operation=""> <created arch="" by="" process="" the="">
460
461538.Resetlogs scn and time scn: 0x0000.04ada796 07/13/03 14:34:39 
462
463539.filename E:\ORACLE\ORADATA\TEST\ARCHIVE_30.ARC 
464
465540.Low scn: 0x0000.04b93016 05/13/04 16:31:24 Next scn: 0x0000.04b9870a 05/13/04 19:43:45 
466
467541.Block count=346 Blocksize=512 
468
469542.RECID #29 Recno 29 Record timestamp 05/13/04 16:31:26 Thread=1 Seq#=29 
470
471543.Flags: <produced archive="" by="" operation=""> <created arch="" by="" process="" the="">
472
473544.Resetlogs scn and time scn: 0x0000.04ada796 07/13/03 14:34:39 
474
475545.filename E:\ORACLE\ORADATA\TEST\ARCHIVE_29.ARC 
476
477546.Low scn: 0x0000.04b8b9ad 05/11/04 14:27:28 Next scn: 0x0000.04b93016 05/13/04 16:31:24 
478
479547.Block count=1062 Blocksize=512 
480
481548.RECID #28 Recno 28 Record timestamp 05/11/04 14:27:33 Thread=1 Seq#=28 
482
483549.Flags: <produced archive="" by="" operation=""> <created arch="" by="" process="" the="">
484
485550.Resetlogs scn and time scn: 0x0000.04ada796 07/13/03 14:34:39 
486
487551.filename E:\ORACLE\ORADATA\TEST\ARCHIVE_28.ARC 
488
489552.Low scn: 0x0000.04b854e4 05/11/04 08:14:52 Next scn: 0x0000.04b8b9ad 05/11/04 14:27:28 
490
491553.Block count=785 Blocksize=512 
492
493554.RECID #27 Recno 27 Record timestamp 05/11/04 08:15:01 Thread=1 Seq#=27 
494
495555.Flags: <produced archive="" by="" operation=""> <created arch="" by="" process="" the="">
496
497556.Resetlogs scn and time scn: 0x0000.04ada796 07/13/03 14:34:39 
498
499557.filename E:\ORACLE\ORADATA\TEST\ARCHIVE_27.ARC 
500
501558.Low scn: 0x0000.04b7efc3 05/10/04 18:00:17 Next scn: 0x0000.04b854e4 05/11/04 08:14:52 
502
503559.Block count=38044 Blocksize=512 
504
505560.RECID #26 Recno 26 Record timestamp 05/10/04 18:00:30 Thread=1 Seq#=26 
506
507561.Flags: <produced archive="" by="" operation=""> <created arch="" by="" process="" the="">
508
509562.Resetlogs scn and time scn: 0x0000.04ada796 07/13/03 14:34:39 
510
511563.filename E:\ORACLE\ORADATA\TEST\ARCHIVE_26.ARC 
512
513564.Low scn: 0x0000.04b7d716 05/10/04 13:16:04 Next scn: 0x0000.04b7efc3 05/10/04 18:00:17 
514
515565.Block count=61433 Blocksize=512 
516
517566.RECID #25 Recno 25 Record timestamp 05/10/04 13:16:07 Thread=1 Seq#=25 
518
519567.Flags: <produced archive="" by="" operation=""> <created arch="" by="" process="" the="">
520
521568.Resetlogs scn and time scn: 0x0000.04ada796 07/13/03 14:34:39 
522
523569.filename E:\ORACLE\ORADATA\TEST\ARCHIVE_25.ARC 
524
525570.Low scn: 0x0000.04b759e6 05/09/04 08:41:38 Next scn: 0x0000.04b7d716 05/10/04 13:16:04 
526
527571.Block count=909 Blocksize=512 
528
529572.RECID #24 Recno 24 Record timestamp 05/09/04 08:41:43 Thread=1 Seq#=24 
530
531573.Flags: <produced archive="" by="" operation=""> <created arch="" by="" process="" the="">
532
533574.Resetlogs scn and time scn: 0x0000.04ada796 07/13/03 14:34:39 
534
535575.filename E:\ORACLE\ORADATA\TEST\ARCHIVE_24.ARC 
536
537576.Low scn: 0x0000.04b6d74d 05/08/04 09:45:10 Next scn: 0x0000.04b759e6 05/09/04 08:41:38 
538
539577.Block count=21946 Blocksize=512 
540
541578.RECID #23 Recno 23 Record timestamp 05/08/04 09:45:14 Thread=1 Seq#=23 
542
543579.Flags: <produced archive="" by="" operation=""> <created arch="" by="" process="" the="">
544
545580.Resetlogs scn and time scn: 0x0000.04ada796 07/13/03 14:34:39 
546
547581.filename E:\ORACLE\ORADATA\TEST\ARCHIVE_23.ARC 
548
549582.Low scn: 0x0000.04b67d98 05/02/04 15:36:17 Next scn: 0x0000.04b6d74d 05/08/04 09:45:10 
550
551583.Block count=11872 Blocksize=512 
552
553584.RECID #22 Recno 22 Record timestamp 05/02/04 15:36:19 Thread=1 Seq#=22 
554
555585.Flags: <produced archive="" by="" operation=""> <created arch="" by="" process="" the="">
556
557586.Resetlogs scn and time scn: 0x0000.04ada796 07/13/03 14:34:39 
558
559587.filename E:\ORACLE\ORADATA\TEST\ARCHIVE_22.ARC 
560
561588.Low scn: 0x0000.04b62189 05/02/04 08:19:22 Next scn: 0x0000.04b67d98 05/02/04 15:36:17 
562
563589.Block count=373 Blocksize=512 
564
565590.RECID #21 Recno 21 Record timestamp 05/02/04 08:19:24 Thread=1 Seq#=21 
566
567591.Flags: <produced archive="" by="" operation=""> <created arch="" by="" process="" the="">
568
569592.Resetlogs scn and time scn: 0x0000.04ada796 07/13/03 14:34:39 
570
571593.filename E:\ORACLE\ORADATA\TEST\ARCHIVE_21.ARC 
572
573594.Low scn: 0x0000.04b5a5f0 04/30/04 07:32:34 Next scn: 0x0000.04b62189 05/02/04 08:19:22 
574
575595.Block count=645 Blocksize=512 
576
577596.RECID #20 Recno 20 Record timestamp 04/30/04 07:32:37 Thread=1 Seq#=20 
578
579597.Flags: <produced archive="" by="" operation=""> <created arch="" by="" process="" the="">
580
581598.Resetlogs scn and time scn: 0x0000.04ada796 07/13/03 14:34:39 
582
583599.filename E:\ORACLE\ORADATA\TEST\ARCHIVE_20.ARC 
584
585600.Low scn: 0x0000.04b551b5 04/29/04 17:10:52 Next scn: 0x0000.04b5a5f0 04/30/04 07:32:34 
586
587601.Block count=378 Blocksize=512 
588
589602.RECID #19 Recno 19 Record timestamp 04/29/04 17:10:54 Thread=1 Seq#=19 
590
591603.Flags: <produced archive="" by="" operation=""> <created arch="" by="" process="" the="">
592
593604.Resetlogs scn and time scn: 0x0000.04ada796 07/13/03 14:34:39 
594
595605.filename E:\ORACLE\ORADATA\TEST\ARCHIVE_19.ARC 
596
597606.Low scn: 0x0000.04b4dfcd 04/29/04 08:47:27 Next scn: 0x0000.04b551b5 04/29/04 17:10:52 
598
599607.Block count=711 Blocksize=512 
600
601608.RECID #18 Recno 18 Record timestamp 04/29/04 08:47:31 Thread=1 Seq#=18 
602
603609.Flags: <produced archive="" by="" operation=""> <created arch="" by="" process="" the="">
604
605610.Resetlogs scn and time scn: 0x0000.04ada796 07/13/03 14:34:39 
606
607611.filename E:\ORACLE\ORADATA\TEST\ARCHIVE_18.ARC 
608
609612.Low scn: 0x0000.04b47afe 04/28/04 15:47:36 Next scn: 0x0000.04b4dfcd 04/29/04 08:47:27 
610
611613.Block count=471 Blocksize=512 
612
613614.RECID #17 Recno 17 Record timestamp 04/28/04 15:47:38 Thread=1 Seq#=17 
614
615615.Flags: <produced archive="" by="" operation=""> <created arch="" by="" process="" the="">
616
617616.Resetlogs scn and time scn: 0x0000.04ada796 07/13/03 14:34:39 
618
619617.filename E:\ORACLE\ORADATA\TEST\ARCHIVE_17.ARC 
620
621618.Low scn: 0x0000.04b426a9 04/28/04 10:46:54 Next scn: 0x0000.04b47afe 04/28/04 15:47:36 
622
623619.Block count=336 Blocksize=512 
624
625620.RECID #16 Recno 16 Record timestamp 04/28/04 10:46:56 Thread=1 Seq#=16 
626
627621.Flags: <produced archive="" by="" operation=""> <created arch="" by="" process="" the="">
628
629622.Resetlogs scn and time scn: 0x0000.04ada796 07/13/03 14:34:39 
630
631623.filename E:\ORACLE\ORADATA\TEST\ARCHIVE_16.ARC 
632
633624.Low scn: 0x0000.04b3d745 04/28/04 10:24:23 Next scn: 0x0000.04b426a9 04/28/04 10:46:54 
634
635625.Block count=272 Blocksize=512 
636
637626.RECID #15 Recno 15 Record timestamp 04/28/04 10:24:26 Thread=1 Seq#=15 
638
639627.Flags: <produced archive="" by="" operation=""> <created arch="" by="" process="" the="">
640
641628.Resetlogs scn and time scn: 0x0000.04ada796 07/13/03 14:34:39 
642
643629.filename E:\ORACLE\ORADATA\TEST\ARCHIVE_15.ARC 
644
645630.Low scn: 0x0000.04b34c54 04/27/04 09:25:18 Next scn: 0x0000.04b3d745 04/28/04 10:24:23 
646
647631.Block count=755 Blocksize=512 
648
649632.RECID #14 Recno 14 Record timestamp 04/27/04 09:25:22 Thread=1 Seq#=14 
650
651633.Flags: <produced archive="" by="" operation=""> <created arch="" by="" process="" the="">
652
653634.Resetlogs scn and time scn: 0x0000.04ada796 07/13/03 14:34:39 
654
655635.filename E:\ORACLE\ORADATA\TEST\ARCHIVE_14.ARC 
656
657636.Low scn: 0x0000.04b2db02 04/17/04 11:54:17 Next scn: 0x0000.04b34c54 04/27/04 09:25:18 
658
659637.Block count=7292 Blocksize=512 
660
661638.RECID #13 Recno 13 Record timestamp 04/17/04 11:54:19 Thread=1 Seq#=13 
662
663639.Flags: <produced archive="" by="" operation=""> <created arch="" by="" process="" the="">
664
665640.Resetlogs scn and time scn: 0x0000.04ada796 07/13/03 14:34:39 
666
667641.filename E:\ORACLE\ORADATA\TEST\ARCHIVE_13.ARC 
668
669642.Low scn: 0x0000.04b27786 04/16/04 19:06:32 Next scn: 0x0000.04b2db02 04/17/04 11:54:17 
670
671643.Block count=414 Blocksize=512 
672
673644.RECID #12 Recno 12 Record timestamp 04/16/04 19:06:34 Thread=1 Seq#=12 
674
675645.Flags: <produced archive="" by="" operation=""> <created arch="" by="" process="" the="">
676
677646.Resetlogs scn and time scn: 0x0000.04ada796 07/13/03 14:34:39 
678
679647.filename E:\ORACLE\ORADATA\TEST\ARCHIVE_12.ARC 
680
681648.Low scn: 0x0000.04b225c5 04/03/04 13:17:32 Next scn: 0x0000.04b27786 04/16/04 19:06:32 
682
683649.Block count=285 Blocksize=512 
684
685650.RECID #11 Recno 11 Record timestamp 04/03/04 13:17:33 Thread=1 Seq#=11 
686
687651.Flags: <produced archive="" by="" operation=""> <created arch="" by="" process="" the="">
688
689652.Resetlogs scn and time scn: 0x0000.04ada796 07/13/03 14:34:39 
690
691653.filename E:\ORACLE\ORADATA\TEST\ARCHIVE_11.ARC 
692
693654.Low scn: 0x0000.04b1caec 04/02/04 13:37:07 Next scn: 0x0000.04b225c5 04/03/04 13:17:32 
694
695655.Block count=350 Blocksize=512 
696
697656.RECID #10 Recno 10 Record timestamp 04/02/04 13:37:09 Thread=1 Seq#=10 
698
699657.Flags: <produced archive="" by="" operation=""> <created arch="" by="" process="" the="">
700
701658.Resetlogs scn and time scn: 0x0000.04ada796 07/13/03 14:34:39 
702
703659.filename E:\ORACLE\ORADATA\TEST\ARCHIVE_10.ARC 
704
705660.Low scn: 0x0000.04b1759e 02/27/04 13:42:16 Next scn: 0x0000.04b1caec 04/02/04 13:37:07 
706
707661.Block count=305 Blocksize=512 
708
709662.RECID #9 Recno 9 Record timestamp 02/27/04 13:42:18 Thread=1 Seq#=9 
710
711663.Flags: <produced archive="" by="" operation=""> <created arch="" by="" process="" the="">
712
713664.Resetlogs scn and time scn: 0x0000.04ada796 07/13/03 14:34:39 
714
715665.filename E:\ORACLE\ORADATA\TEST\ARCHIVE_9.ARC 
716
717666.Low scn: 0x0000.04b10a6b 02/14/04 10:34:55 Next scn: 0x0000.04b1759e 02/27/04 13:42:16 
718
719667.Block count=683 Blocksize=512 
720
721668.RECID #8 Recno 8 Record timestamp 02/14/04 10:34:57 Thread=1 Seq#=8 
722
723669.Flags: <produced archive="" by="" operation=""> <created arch="" by="" process="" the="">
724
725670.Resetlogs scn and time scn: 0x0000.04ada796 07/13/03 14:34:39 
726
727671.filename E:\ORACLE\ORADATA\TEST\ARCHIVE_8.ARC 
728
729672.Low scn: 0x0000.04b0a354 02/13/04 11:24:29 Next scn: 0x0000.04b10a6b 02/14/04 10:34:55 
730
731673.Block count=466 Blocksize=512 
732
733674.RECID #7 Recno 7 Record timestamp 02/13/04 11:24:31 Thread=1 Seq#=7 
734
735675.Flags: <produced archive="" by="" operation=""> <created arch="" by="" process="" the="">
736
737676.Resetlogs scn and time scn: 0x0000.04ada796 07/13/03 14:34:39 
738
739677.filename E:\ORACLE\ORADATA\TEST\ARCHIVE_7.ARC 
740
741678.Low scn: 0x0000.04b046f0 02/11/04 13:19:35 Next scn: 0x0000.04b0a354 02/13/04 11:24:29 
742
743679.Block count=363 Blocksize=512 
744
745680.RECID #6 Recno 6 Record timestamp 02/11/04 13:19:37 Thread=1 Seq#=6 
746
747681.Flags: <produced archive="" by="" operation=""> <created arch="" by="" process="" the="">
748
749682.Resetlogs scn and time scn: 0x0000.04ada796 07/13/03 14:34:39 
750
751683.filename E:\ORACLE\ORADATA\TEST\ARCHIVE_6.ARC 
752
753684.Low scn: 0x0000.04af02f4 10/08/03 08:53:42 Next scn: 0x0000.04b046f0 02/11/04 13:19:35 
754
755685.Block count=2464 Blocksize=512 
756
757686.RECID #5 Recno 5 Record timestamp 10/08/03 08:53:44 Thread=1 Seq#=5 
758
759687.Flags: <produced archive="" by="" operation=""> <created arch="" by="" process="" the="">
760
761688.Resetlogs scn and time scn: 0x0000.04ada796 07/13/03 14:34:39 
762
763689.filename E:\ORACLE\ORADATA\TEST\ARCHIVE_5.ARC 
764
765690.Low scn: 0x0000.04aeadbb 08/08/03 15:15:38 Next scn: 0x0000.04af02f4 10/08/03 08:53:42 
766
767691.Block count=384 Blocksize=512 
768
769692.RECID #4 Recno 4 Record timestamp 08/08/03 15:15:41 Thread=1 Seq#=4 
770
771693.Flags: <produced archive="" by="" operation=""> <created arch="" by="" process="" the="">
772
773694.Resetlogs scn and time scn: 0x0000.04ada796 07/13/03 14:34:39 
774
775695.filename E:\ORACLE\ORADATA\TEST\ARCHIVE_4.ARC 
776
777696.Low scn: 0x0000.04ae599c 07/20/03 10:47:36 Next scn: 0x0000.04aeadbb 08/08/03 15:15:38 
778
779697.Block count=302 Blocksize=512 
780
781698.RECID #3 Recno 3 Record timestamp 07/20/03 10:47:37 Thread=1 Seq#=3 
782
783699.Flags: <produced archive="" by="" operation=""> <created arch="" by="" process="" the="">
784
785700.Resetlogs scn and time scn: 0x0000.04ada796 07/13/03 14:34:39 
786
787701.filename E:\ORACLE\ORADATA\TEST\ARCHIVE_3.ARC 
788
789702.Low scn: 0x0000.04ae07a9 07/20/03 09:43:05 Next scn: 0x0000.04ae599c 07/20/03 10:47:36 
790
791703.Block count=41 Blocksize=512 
792
793704.RECID #2 Recno 2 Record timestamp 07/20/03 09:43:05 Thread=1 Seq#=2 
794
795705.Flags: <produced archive="" by="" operation=""> <created by="" foreground="" process="" the="">
796
797706.Resetlogs scn and time scn: 0x0000.04ada796 07/13/03 14:34:39 
798
799707.filename E:\ORACLE\ORADATA\TEST\ARCHIVE_2.ARC 
800
801708.Low scn: 0x0000.04ae05fb 07/20/03 09:30:37 Next scn: 0x0000.04ae07a9 07/20/03 09:43:05 
802
803709.Block count=385 Blocksize=512 
804
805710.RECID #1 Recno 1 Record timestamp 07/20/03 09:30:39 Thread=1 Seq#=1 
806
807711.Flags: <produced archive="" by="" operation=""> <created arch="" by="" process="" the="">
808
809712.Resetlogs scn and time scn: 0x0000.04ada796 07/13/03 14:34:39 
810
811713.filename E:\ORACLE\ORADATA\TEST\ARCHIVE_1.ARC 
812
813714.Low scn: 0x0000.04ada796 07/13/03 14:34:39 Next scn: 0x0000.04ae05fb 07/20/03 09:30:37 
814
815715.Block count=608 Blocksize=512 
816
817使用Rman备份数据库的备份集记录项(该项从Oracle8开始引入)   
818716\. ****************************************************************** 
819
820717\. BACKUP SET RECORDS 
821
822718\. ****************************************************************** 
823
824719.(blkno = 0x2d, size = 40, max = 204, in-use = 0, last-recid= 0) 
825
826使用Rman备份数据库的备份片记录项(该项从Oracle8开始引入)   
827720\. ****************************************************************** 
828
829721\. BACKUP PIECE RECORDS 
830
831722\. ****************************************************************** 
832
833723.(blkno = 0x2e, size = 736, max = 210, in-use = 0, last-recid= 0) 
834
835使用Rman备份数据库的备份数据文件的记录项(该项从Oracle8开始引入)   
836724\. ****************************************************************** 
837
838725\. BACKUP DATAFILE RECORDS 
839
840726\. ****************************************************************** 
841
842727.(blkno = 0x41, size = 116, max = 211, in-use = 0, last-recid= 0) 
843
844使用Rman备份数据库的备份归档日志文件的记录项(该项从Oracle8开始引入)   
845728\. ****************************************************************** 
846
847729\. BACKUP LOG RECORDS 
848
849730\. ****************************************************************** 
850
851731.(blkno = 0x44, size = 76, max = 107, in-use = 0, last-recid= 0) 
852
853使用Rman备份数据库时数据文件拷贝的记录项(该项从Oracle8开始引入)   
854732\. ****************************************************************** 
855
856733\. DATAFILE COPY RECORDS 
857
858734\. ****************************************************************** 
859
860735.(blkno = 0x45, size = 660, max = 210, in-use = 1, last-recid= 1) 
861
862736.Earliest record: 
863
864737.RECID #1 Recno 1 Record timestamp 07/20/03 09:43:04 
865
866738.File=0 (0) database id=1750352942 block size=8192 
867
868739.Flags: 
869
870740.Filename: D:\HOT_BACKUP\CONTROL02.CTL 
871
872741.Creation checkpointed at scn: 0x0000.00000000 07/13/03 14:30:52 
873
874742.File header checkpointed at scn: 0x0000.04ae079e 07/20/03 09:43:02 
875
876743.Resetlogs scn and time scn: 0x0000.04ada796 07/13/03 14:34:39 
877
878744.Recovery Fuzzy scn and time scn: 0x0000.00000000 01/01/88 00:00:00 
879
880745.Absolute Fuzzy scn: 0x0000.00000000 
881
882746.Newly-marked media corrupt blocks 0 Total media corrupt blocks 0 
883
884747.Total logically corrupt blocks 0 Block images written to backup 228 
885
886748.Low Offline Range Recid 0 
887
888749.Tag: 
889
890750.Copy does not have keep options. 
891
892751.Latest record: 
893
894752.RECID #1 Recno 1 Record timestamp 07/20/03 09:43:04 
895
896753.File=0 (0) database id=1750352942 block size=8192 
897
898754.Flags: 
899
900755.Filename: D:\HOT_BACKUP\CONTROL02.CTL 
901
902756.Creation checkpointed at scn: 0x0000.00000000 07/13/03 14:30:52 
903
904757.File header checkpointed at scn: 0x0000.04ae079e 07/20/03 09:43:02 
905
906758.Resetlogs scn and time scn: 0x0000.04ada796 07/13/03 14:34:39 
907
908759.Recovery Fuzzy scn and time scn: 0x0000.00000000 01/01/88 00:00:00 
909
910760.Absolute Fuzzy scn: 0x0000.00000000 
911
912761.Newly-marked media corrupt blocks 0 Total media corrupt blocks 0 
913
914762.Total logically corrupt blocks 0 Block images written to backup 228 
915
916763.Low Offline Range Recid 0 
917
918764.Tag: 
919
920765.Copy does not have keep options. 
921
922使用Rman备份数据库的备份数据文件损坏记录项(该项从Oracle8开始引入)   
923766\. ****************************************************************** 
924
925767\. BACKUP DATAFILE CORRUPTION RECORDS 
926
927768\. ****************************************************************** 
928
929769.(blkno = 0x56, size = 44, max = 185, in-use = 0, last-recid= 0) 
930
931使用Rman备份数据库的数据文件拷贝损坏记录项(该项从Oracle8开始引入)   
932770\. ****************************************************************** 
933
934771\. DATAFILE COPY CORRUPTION RECORDS 
935
936772\. ****************************************************************** 
937
938773.(blkno = 0x57, size = 40, max = 204, in-use = 0, last-recid= 0) 
939
940使用Rman备份数据库的删除记录(该项从Oracle8开始引入)   
941774\. ****************************************************************** 
942
943775\. DELETION RECORDS 
944
945776\. ****************************************************************** 
946
947777.(blkno = 0x58, size = 20, max = 408, in-use = 0, last-recid= 0) 
948
949使用Rman备份数据库的代理拷贝记录项(该项从Oracle8i开始引入)   
950778\. ****************************************************************** 
951
952779\. PROXY COPY RECORDS 
953
954780\. ****************************************************************** 
955
956781.(blkno = 0x59, size = 852, max = 210, in-use = 0, last-recid= 0) 
957
958INCARNATION RECORDS(该项从Oracle9i开始引入)   
959782\. ****************************************************************** 
960
961783\. INCARNATION RECORDS 
962
963784\. ****************************************************************** 
964
965785.(blkno = 0x72, size = 56, max = 145, in-use = 1, last-recid= 1) 
966
967786.Earliest record: 
968
969787.RECID #1 Recno 1 Record timestamp 
970
971788.Resetlogs scn and time scn: 0x0000.04ada796 07/13/03 14:34:39 
972
973789.Previous Resetlogs scn and time scn: 0x0000.04a0b855 04/11/03 09:59:18 
974
975790.Latest record: 
976
977791.RECID #1 Recno 1 Record timestamp 
978
979792.Resetlogs scn and time scn: 0x0000.04ada796 07/13/03 14:34:39 
980
981793.Previous Resetlogs scn and time scn: 0x0000.04a0b855 04/11/03 09:59:18 
982
983794\. *** END OF DUMP ***</created></produced></created></produced></created></produced></created></produced></created></produced></created></produced></created></produced></created></produced></created></produced></created></produced></created></produced></created></produced></created></produced></created></produced></created></produced></created></produced></created></produced></created></produced></created></produced></created></produced></created></produced></created></produced></created></produced></created></produced></created></produced></created></produced></created></produced></created></produced></created></produced></created></produced></created></produced></created></produced></deleted></deleted>
Published At
Categories with 数据库类
comments powered by Disqus