311. DATA FILE #12: <deleted
312.creation size=1280 block size=8192 status=0x800 head=0 tail=0 dup=0
313.tablespace 18, index=14 krfil=12 prev_file=0
314.unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
315.Checkpoint cnt:3 scn: 0x0000.04b7e874 05/10/2004 16:45:12
316.Stop scn: 0x0000.04b7e874 05/10/2004 16:45:12
317.Creation Checkpointed at scn: 0x0000.04b7e496 05/10/2004 16:04:32
318.thread:1 rba:(0x1a.17d.10)
319.enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000
320.00000000 00000000
321.Offline scn: 0x0000.00000000 prev_range: 0
322.Online Checkpointed at scn: 0x0000.00000000
323.thread:0 rba:(0x0.0.0)
324.enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000
325.00000000 00000000
326.Hot Backup end marker scn: 0x0000.00000000
327.aux_file is NOT DEFINED
328. DATA FILE #13: <deleted
329.creation size=0 block size=0 status=0x0 head=0 tail=0 dup=0
330.tablespace 0, index=0 krfil=0 prev_file=0
331.unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
332.Checkpoint cnt:0 scn: 0x0000.00000000 01/01/1988 00:00:00
333.Stop scn: 0x0000.00000000 01/01/1988 00:00:00
334.Creation Checkpointed at scn: 0x0000.00000000
335.thread:0 rba:(0x0.0.0)
336.enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000
337.00000000 00000000
338.Offline scn: 0x0000.00000000 prev_range: 0
339.Online Checkpointed at scn: 0x0000.00000000
340.thread:0 rba:(0x0.0.0)
341.enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000
342.00000000 00000000
343.Hot Backup end marker scn: 0x0000.00000000
344.aux_file=0
345. DATA FILE #14:
346.(name #6) E:\Oracle\ORA92\TEST\XPRT01.DBF
347.creation size=0 block size=8192 status=0xe head=6 tail=6 dup=1
348.tablespace 16, index=12 krfil=14 prev_file=0
349.unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
350.Checkpoint cnt:187 scn: 0x0000.04b9d858 05/14/2004 08:36:59
351.Stop scn: 0xffff.ffffffff 05/13/2004 20:18:03
352.Creation Checkpointed at scn: 0x0000.04a3fd9c 05/28/2003 15:06:11
353.thread:0 rba:(0x0.0.0)
354.enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000
355.00000000 00000000
356.Offline scn: 0x0000.04ada795 prev_range: 0
357.Online Checkpointed at scn: 0x0000.04ada796 07/13/2003 14:34:39
358.thread:1 rba:(0x1.2.0)
359.enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000
360.00000000 00000000
361.Hot Backup end marker scn: 0x0000.00000000
362.aux_file is NOT DEFINED
临时文件记录项(该项从Oracle9i开始引入)
363. ******************************************************************
364. TEMP FILE RECORDS
365. ******************************************************************
366.(blkno = 0x12,
size = 56, max = 100, in-use = 1, last-recid= 1)
367.TEMP FILE #1: External File #201
368.(name #18) E:\ORACLE\ORA92\TEST\TEMP.DBF
369.creation size=2560 block size=8192 status=0xe head=18 tail=18 dup=1
370.tablespace 2, index=13 krfil=1 prev_file=0
371.unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
表空间记录项(该项从Oracle8开始引入)
372. ******************************************************************
373. TABLESPACE RECORDS
374. ******************************************************************
375.(blkno = 0x11, size = 68, max = 100, in-use = 16, last-recid= 9)
376.TABLESPACE #0 SYSTEM: recno=1
377.First datafile link=1 Tablespace Flag=0
378.Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00
379.Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00
380.TABLESPACE #1 UNDOTBS1: recno=2
381.First datafile link=2 Tablespace Flag=0
382.Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00
383.Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00
384.TABLESPACE #3 DRSYS: recno=3
385.First datafile link=3 Tablespace Flag=0
386.Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00
387.Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00
388.TABLESPACE #4 INDX: recno=4
389.First datafile link=4 Tablespace Flag=0
390.Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00
391.Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00
392.TABLESPACE #5 TOOLS: recno=5
393.First datafile link=5 Tablespace Flag=0
394.Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00
395.Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00
396.TABLESPACE #6 USERS: recno=6
397.First datafile link=6 Tablespace Flag=0
398.Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00
399.Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00
400.TABLESPACE #7 XDB: recno=7
401.First datafile link=7 Tablespace Flag=0
402.Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00
403.Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00
404.TABLESPACE #11 TEST: recno=8
405.First datafile link=8 Tablespace Flag=0
406.Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00
407.Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00
408.TABLESPACE #9 RMAN: recno=9
409.First datafile link=9 Tablespace Flag=0
410.Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00
411.Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00
412.TABLESPACE #12 PERFSTAT: recno=10
413.First datafile link=10 Tablespace Flag=0
414.Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00
415.Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00
416.TABLESPACE #8 UNDOTBS2: recno=11
417.First datafile link=11 Tablespace Flag=0
418.Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00
419.Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00
420.TABLESPACE #16 XPRT: recno=12
421.First datafile link=14 Tablespace Flag=0
422.Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00
423.Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00
424.TABLESPACE #2 TEMP: recno=13
425.First datafile link=1 Tablespace Flag=1
426.Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00
427.Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:
right"(出处:清风软件下载学院)