当前位置导航:炫浪网>>网络学院>>编程开发>>Oracle教程

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


  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:
相关内容
赞助商链接