Oracle 数据字典中X$表 介绍

1、Oracle数据字典中乂$表介绍一-x$表说明乂$表包含了特定实例的各方面的信息，X$表在oracle的不同版本里很可能是不一样的，是Oracle数据库的运行基础，如当前的配置信息，连接到实例的会话，以及丰富而有价值的性能信息。X$表并不是驻留在数据库文件的永久表或临时表。X$表仅仅驻留在内存中，当实例启动时，由Oracle应用程序动态创建，在内存中进行实时的维护。它们中的大多数至少需要装载或已经打开的数据库。X$表为SYS用户所拥有，并且是只读的。不能进行DML（更新，插入，删除）。X$表对数据库来说至关重要，所以Oracle不允许SYSDBA之外的用户直接访问，显示授权不被允许。可以从v$

2、fixed_table中查到X$：SQLselect*fromv$version;BANNEROracleDatabase10gEnterpriseEditionRelease1020.5.0-ProdPL/SQLRelease.0-ProductionCORE1020.5.0ProductionTNSforLinux:Version1020.5.0-ProductionNLSRTLVersion1020.5.0-ProductionSQLselectcount(*)fromv$fixed_tablewherenamelikeX$%;COUNT(*)620以上是Oracle版本里的乂$表的数量

3、，在Oracle11g里又有大幅增加:SQLselectcount(*)fromv$fixed_tablewherenamelikeX$%;COUNT(*)945关于乂$表，其创建信息我们也可以通过bootstrap$查看，该表中记录了数据库启动的基本及驱动信息。bootstrap$实际上存储的是数据字典的基表的定义，如OBJ$,C_OBJ$,TAB等。Oracle通过读取这些定义创建数据字典的基表，进而创建数据字典。有关bootstrap$会另篇说明。SQLselect*frombootstrap$;二.Oracle10gX$KCVFH说明X$KCVFH是GV$DATAFILE_HEADER

4、的内部视图，不同版本的Oracle,X$KCVFH的结构可能不同，如下说明基于Oracle10gR2版本。这部分工作是dbsnake做的，直接摘取自dbsnake的blog。2.1字典结构及含义SQLdescx$kcvfh相关字段的描述：ColumnNameDataTypeDescriptionADDRRAW(4)ADDRESSINDXNUMBERINDEXINST_IDNUMBERINSTANCEIDHXFILNUMBERFILE#，Datafilenumber(fromcontrolfile)HXONSNUMBERONLINE|OFFLINE(fromcontrolfile),HXONS为

5、0表示OFFLINE，为其他值表示ONLINEHXSTSVARCHAR2(16)HXERRNUMBERERROR，decode(HXERR,0,NULL,FILEMISSING,OFFLINENORMAL,NOTVERIFIED,FILENOTFOUND,CANNOTOPENFILE,CANNOTREADHEADER,乙CORRUPTHEADER,WRONGFILETYPE,WRONGDATABASE,WRONGFILENUMBER,WRONGFILECREATE,WRONGFILECREATE,16,DELAYEDOPEN,WRONGRESETLOGS,OLDCONTROLFILE,UNKN

6、OWNERROR)HXVERNUMBERFORMAT，Indicatestheformatfortheheaderblock.Thepossiblevaluesare6,7,8,or0.-indicatesOracleVersion6；-indicatesOracleVersion7；-indicatesOracleVersion8；0-indicatestheformatcouldnotbedetermined(forexample,theheadercouldnotberead)FHSWVNUMBERFHCVNNUMBERCompatibilityVsnFHDBINUMBERDBIDFHD

7、BNVARCHAR2(9)DBNAMEFHCSQNUMBERcontrolfilesequeneenumberFHFSZNUMBERBLOCKS,CurrentdatafilesizeinblocksFHBSZNUMBERdatafileblocksizeFHFNONUMBERTablespacedatafilenumberFHTYPNUMBERType:controlfileredologfilevanilladbfile;thatis,normaldata,index,andundoblocksbackupcontrolfilebackuppiecetemporarydbfileFHRDB

8、NUMBERRootdba:Thisfieldonlyoccursindatafile#1,andisthelocationofblocksrequiredduringbootstrappingthedatadictionary(bootstrap$)FHCRSVARCHAR2(16)CREATION_CHANGE#,Datafilecreationchange#FHCRTVARCHAR2(20)CREATION_TIME,DatafilecreationtimestampFHRLCVARCHAR2(20)RESETLOGS_TIME,ResetlogstimestampFHRLC_INUMB

9、ERresetlogscountFHRLSVARCHAR2(16)RESETLOGS_CHANGE#,Resetlogschange#FHPRCVARCHAR2(20)prevresetlogstimestampFHPRC_INUMBERprevresetlogscountFHPRSVARCHAR2(16)prevresetlogsSCNFHBTIVARCHAR2(20)Timethebackupstarted,UpdatedwhenexecutingBEGINBACKUPonthetablespace.RMANdoesnotupdatethisfield.FHBSCVARCHAR2(16)S

10、ystemchangenumberwhenbackupstarted,UpdatedwhenexecutingBEGINBACKUPonthetablespace.RMANdoesnotupdatethisfield.FHBTHNUMBERThreadwhenwhenbackupstarted,UpdatedwhenexecutingBEGINBACKUPonthetablespace.RMANdoesnotupdatethisfield.FHSTANUMBERThevalueforthecolumnX$KCVFH.FHSTA(fileheaderstatus)foranopendatabas

11、ewithanonlinedatafilesinversionspriortoversion10wereall4,indicatinganonlinefuzzystatus.Withversion10ofOraclethefirstsystemtablespacedatafilewillhaveadifferentstatusof8196ifthedatafileisonlineandthedatabaseisopenandnotinbackupmode.InOracle10g,theX$KCVFH.FHSTAcolumnwillshow8196forsystemdatafileifCOMPA

12、TIBLEissettoorhigher.Thevalueof8196isavalueof0 x04,asinpreviousreleases,plusanANDdvalueof0 x2000(8192)forinternaluses.IfCOMPATIBLEissetto9.2.0(lowestpossiblevalueforOracle10g),theFHSTAcolumnforsystemdatafilewillhaveavalueof4.InOraclelOg,theCOMPATIBLEvalueisirreversibleifadvaneedtoahighervalue.Sothev

13、alueof8196forthefhsta(status)columnforthefirstsystemtablespacedatafileisnormal.FHSCNVARCHAR2(16)CHECKPOINT_CHANGE#,Datafilecheckpointchange#,Updatedoneverycheckpoint,butnotwheninHotbackupstate(notonlinebackups).Thismustremainuntouchedwhenyouareinhotbackupmode,becauseyoumightgetcheckpointsbetweentheB

14、EGINBACKUPandwhenyouactuallystartthecopyingprocess.FHTIMVARCHAR2(20)CHECKPOINT_TIME,DatafilecheckpointtimestampFHTHRNUMBERTHREAD#FHRBA_SEQNUMBERSEQUENCE,即RedologsequeneenumberFHRBA_BNONUMBERBlocknumber，即theredologfileblocknumberFHRBA_BOFNUMBERByteoffset,thebyteoffsetintotheblockatwhichtheredorecords

15、tartsFHETBRAW(132)enablethreadsbyte(这个不确定)FHCPCNUMBERCHECKPOINT_COUNT,DatafilecheckpointcountFHRTSVARCHAR2(20)RecoverdtimestampFHCCCNUMBERControlfileCheckpointCount:Savedcopyofthecontrolfilerecordofthecheckpointcount.Helpsdetectoldcontrolfiles.FHBCP_SCNVARCHAR2(16)BackupCheckpointSCN:Updatedwiththec

16、heckpointdonewhilefileinHotbackupFHBCP_TIMVARCHAR2(20)BackupCheckpointTIME:UpdatedwiththecheckpointdonewhilefileinHotbackupFHBCP_THRNUMBERBackupCheckpointThread:UpdatedwiththecheckpointdonewhilefileinHotbackupFHBCP_RBA_SEQNUMBERBackupCheckpointSequenee,即Redologsequeneenumber:Updatedwiththecheckpoint

17、donewhilefileinHotbackupFHBCP_RBA_BNONUMBERtheredologfileblocknumber,UpdatedwiththecheckpointdonewhilefileinHotbackupFHBCP_RBA_BOFNUMBERByteoffset,thebyteoffsetintotheblockatwhichtheredorecordstarts,UpdatedwiththecheckpointdonewhilefileinHotbackupFHBCP_ETBRAW(132)enablethreadsbyte(不确定)FHBHZNUMBERbeg

18、inhotbackupfilesizeFHXCDRAW(16)Externalcacheid:UsedtoensurethatconcurrentinstancesaccessdatathroughconsistentexternalcacheFHTSNNUMBERTS#,TablespacenumberFHTNMVARCHAR2(30)TABLESPACE_NAME,TablespacenameFHRFNNUMBERRFILE#,TablespacerelativedatafilenumberFHAFSVARCHAR2(16)absolutefuzzysen,即MinimumPITRSCNF

19、HRFSVARCHAR2(16)TheSCNatwhichtherecoveryofthisfilewillbecomplete(nolongerfuzzy).BothabovefuzzySCNsmustbezerounlessafuzzyflagisset,andmustbegreaterthanthecheckpointSCNFHRFTVARCHAR2(20)Thetimeatwhichtherecoveryofthisfilewillbecomplete(noIongerfuzzy).HXIFZNUMBERFileisfuzzy(YES|NO),decode(hxifz,0,NO；1,Y

20、ES；NULL)HXNRCVNUMBERFileneedsmediarecovery(YES|NO),decode(hxnrcv,0,NO,1,YES,NULL)HXFNMVARCHAR2(513)NAME,DatafilenameFHPOFBNUMBERFHPNFBNUMBERFHPRE10NUMBERFHFIRSTUNRECSCNVARCHAR2(16)UNRECOVERABLE_CHANGE#,Lastunrecoverablechangenumbermadetothisdatafile.IfthedatabaseisinARCHIVELOGmode,thenthiscolumnisup

21、datedwhenanunrecoverableoperationcompletes.IfthedatabaseisnotinARCHIVELOGmode,thiscolumndoesnotgetupdated.FHFIRSTUNRECTIMEVARCHAR2(20)UNRECOVERABLE_TIME,Timestampofthelastunrecoverablechange.ThiscolumnisupdatedonlyifthedatabaseisinARCHIVELOGmode.HXLMDBANUMBERSPACE_HEADER,Theamountofspacecurrentlybei

22、ngusedandtheamountthatisfree,asidentifiedinthespaceheader.decode(hxlmdba,0,NULL,hxlmdba)HXLMLD_SCNVARCHAR2(16)LAST_DEALLOC_SCN,LastdeallocatedSCN2.2X$KCVFH的常见用法2.2.1判断datafile是否需要recover,如果需要recover,那么需要至少需要recover到什么SCN,即执行如下查询：SQLselectmax(fhafs)fromx$kcvfh;MAX(FHAFS)0如果返回返回结果大于0,则表示数据库处于不一致的状态，需要

23、recover到上述查询结果中的SCN。2.2.2判断datafile做recover需要的archivelog的sequenee是多少，也就是说做recover至U这个sequenee,那么controlfile和datafileheader中的记录就一致了。即执行如下查询：SQLselectHXFILFile_num,substr(HXFNM,1,45)File_name,FHSCNSCN,FHRBA_SEQSequeneefromX$KCVFH;FILE_NUMFILE_NAMESCNSEQUENCE13292491329249132924913292491329249696969696

24、9/u01/app/oracle/oradata/anqing/systemO1.dbf/u01/app/oracle/oradata/anqing/undotbsOl.dbf/u01/app/oracle/oradata/anqing/sysaux01.dbf/u01/app/oracle/oradata/anqing/users01.dbf/u01/app/oracle/oradata/anqing/example01.dbf三.X$KCVFH的出处在第二节列出了x$kcvfh大部分字段的含义。这个含义也是dbsnake自己推出来的。具体的方法就是将file#1的datafileheade

25、r（第一个block）dump出来,然后用其值与DATAFILE#1在x$kcvfh中的内容值进行比较，这个一步是dbsnake用自己的一个过程来实现的，我不知道其具体内容，但是通过BBED可以看出对应的值。也可以进行一个比较。至于为什么x$kcvfh的内容放在file#1里，这个是Oracle的规定。3.1使用BBED査看kcvfh内容OracleBBED工具说明 HYPERLINK http:/blog.csd http:/blog.csd/tianlesoftware/article/details/5006580Oraclebbed五个实用示例 HYPERLINK http:/blog

26、.csd http:/blog.csd/tianlesoftware/article/details/6684505先查看一个File#1对应的表空间，是system：SQLselectfile_id,file_namefromdba_data_files;FILEDFILE_NAME/u01/app/oracle/oradata/anqing/usersO1.dbf3/u01/app/oracle/oradata/anqing/sysauxO1.dbf2/u01/app/oracle/oradata/anqing/undotbs01.dbf1/u01/app/oracle/oradata/a

27、nqing/systemO1.dbf/u01/app/oracle/oradata/anqing/exampleO1.dbf用BBED工具查看一下File#1中kcvfh的内容和对应的值:dave:/u01catfilelist.txt1/u01/app/oracle/oradata/anqing/systemO1.dbfdave:/uO1catbbed.parblocksize=8192listfile=/uO1/filelist.txtmode=editdave:/u01bbedparfile=/u01/bbed.parPassword:BBED:Release.0-LimitedProd

28、uctiononSunOct3015:51:162011*Copyright(c)1982,2007,Oracle.Allrightsreserved.川ForOracleInternalUseonly!*BBEDshowFILE#1BLOCK#1OFFSET0DBA0 x00400001(41943051,1)FILENAME/u01/app/oracle/oradata/anqing/system01.dbfBIFILEbifile.bbdLISTFILE/u01/filelist.txtBLOCKSIZE8192MODEEditEDITUnrecoverableIBASEDecOBASE

29、DecWIDTH80COUNT512LOGFILElog.bbdSPOOLNoBBEDpkcvfhstructkcvfh,676bytes0structkcvfhbfh,20bytes0ub1type_kcbh00 x0bub1frmt_kcbh10 xa2ub1spare1_kcbh20 x00ub1spare2_kcbh30 x00ub4rdba_kcbh40 x00400001ub4bas_kcbh80 x00000000ub2wrp_kcbh120 x0000ub1seq_kcbh140 x01ub1flg_kcbh150 x04(KCBHFCKV)ub2chkval_kcbh160

30、x9614ub2spare3_kcbh180 x0000structkcvfhhdr,76bytes20ub4kccfhswv200 x00000000ub4kccfhcvn240 x0a200100ub4kccfhdbi280 x296d43c7textkccfhdbn032Atextkccfhdbn133Ntextkccfhdbn234Qtextkccfhdbn335Itextkccfhdbn436Ntextkccfhdbn537Gtextkccfhdbn638textkccfhdbn739ub4kccfhcsq400 x00000402ub4kccfhfsz440 x0000fa00s_

31、blkzkccfhbsz480 x00ub2kccfhfno520 x0001ub2kccfhtyp540 x0003ub4kccfhacid560 x00000000ub4kccfhcks600 x00000000textkccfhtag064textkccfhtag3195ub4kcvfhrdb960 x00400179structkcvfhcrs,8bytes100ub4kscnbas1000 x00000009ub2kscnwrp1040 x0000ub4kcvfhcrt1080 x2184ef93ub4kcvfhrlc1120 x2d8b028bstructkcvfhrls,8byt

32、es116ub4kscnbas1160 x0006ce7bub2kscnwrp1200 x0000ub4kcvfhbti1240 x00000000structkcvfhbsc,8bytes128ub4kscnbas1280 x00000000ub2kscnwrp1320 x0000ub2kcvfhbth1360 x0000ub2kcvfhsta1380 x2004(KCVFHOFZ)structkcvfhckp,36bytes484structkcvcpscn,8bytes484ub4kscnbas4840 x00144861ub2kscnwrp4880 x0000ub4kcvcptim49

33、20 x2da69134ub2kcvcpthr4960 x0001unionu,12bytes500structkcvcprba,12bytes500ub4kcrbaseq5000 x00000045ub4kcrbabno5040 x00000002ub2kcrbabof5080 x0010ub1kcvcpetb05120 x02ub1kcvcpetb75190 x00ub4kcvfhcpc1400 x00000089ub4kcvfhrts1440 x2da69133ub4kcvfhccc1480 x00000088structkcvfhbcp,36bytes152structkcvcpscn

34、,8bytes152ub4kscnbas1520 x00000000ub2kscnwrp1560 x0000ub4kcvcptim1600 x00000000ub2kcvcpthr1640 x0000unionu,12bytes168structkcvcprba,12bytes168ub4kcrbaseq1680 x00000000ub4kcrbabno1720 x00000000ub2kcrbabof1760 x0000ub1kcvcpetb01800 x00ub1kcvcpetb71870 x00ub4kcvfhbhz3120 x00000000structkcvfhxcd,16bytes

35、316ub4space_kcvmxcdO3160 x00000000ub4space_kcvmxcd13200 x00000000ub4space_kcvmxcd23240 x00000000ub4space_kcvmxcd33280 x00000000wordkcvfhtsn3320ub2kcvfhtIn3360 x0006textkcvfhtnm0338Stextkcvfhtnm29367ub4kcvfhrfn3680 x00000001structkcvfhrfs,8bytes372ub4kscnbas3720 x00000000ub2kscnwrp3760 x0000ub4kcvfhr

36、ft3800 x00000000structkcvfhafs,8bytes384ub4kscnbasub2kscnwrpub4kcvfhbbcub4kcvfhnebub4kcvfhmcbub4kcvfhlcbub4kcvfhbcsub2kcvfhofbub2kcvfhnfbub4kcvfhprcstructkcvfhprs,8bytesub4kscnbasub2kscnwrpstructkcvfhprfs,8bytesub4kscnbasub2kscnwrpub4kcvfhtrt3840 x000000003880 x00003920 x000000003960 x000000004000 x

37、000000004040 x000000004080 x000000004120 x000a4140 x000a4160 x2184ef744204200 x000000014240 x00004284280 x000000004320 x00004440 x00000000BBED这里我们可以从结果里看到X$KCVFH实际上是来源于kcvfh这个struct。这里的符号表示的是偏移量，后面对应的是其值，dbsnake应该是写了一个方法，直接获取了这个值。如：ub4kccfhcvn240 x0a200100查看该对象对应的值：SQLselectto_number(0a200100,xxxxxx

38、xxx)fromdual;T0_NUMBER(0A200100,XXXXXXXXX)16986956832DumpDatafileheaderOracleoradebug命令使用说明 HYPERLINK http:/blog.csd http:/blog.csd/tianlesoftware/article/details/6525628DatafileHeader是datafile中的第一个block.要dumpdatafileheader不能直接使用如下命令：altersystemdumpdatafile1block1;该命令会显示：Block1(fileheader)notdumped:

39、usedumpfileheadercommand。查看DSI文档403FileDumpAnalysis节，可以找到具体的用法:ThisdatafileheaderisinallOracledatafiles,thatis,filesbelongingtoatablespace.Theheaderisthesameforatempfile.DumpFILE_HDRSLEVELnN=1:Thecontrolfilesentryofthedatafile.ThisappearsbeforethestringFILEHEADER,andisnotshownontheslide.Itwillbecove

40、redinthecontrolfiledump.N=2:Thecontrolfilesentryandgenericheader.Thishasbeencoveredinthepreviousslide,andisnotshownontheaboveslide.N=3:Thecontrolfilesentry,genericheader,andtheheaderinformationinthedatafile.Thiscausesthefiletobeopenedandreadifthedatabaseisonlymounted.DataFileHeaderThisresidesinblock

41、1,somewhereafterthegenericfileheader.Tablespace:Nameofthetablespacetowhichthefilebelongs.rel_fn:RelativefilenumberCreationSCN,time:SCNatthetimethefilewascreated.TherecannotbeanyredoinformationforthisfilepriortothisSCN.Thetimestampisapproximate.Thiscanbeusedtodistinguishbetweendifferentfilescreatedwi

42、ththesamename(forexample,dropandrecreateatablespace).Backupscn,time:UpdatedwhenexecutingBEGINBACKUPonthetablespace.RMANdoesnotupdatethisfield.(Thenextfewlinesinthedumpareincorrectlyindented,erroneouslysuggestingtheybelongtothebackupSCN.)resetlogscountandscn:ThecounterwiththeSCNiscalledtheResetLogSta

43、mp,andisauniqueidentification.Thecounterisinfactatimestamp.Recoveredat:Usedduringrecoverytohelpensurethatifmanyprocessesareusedforrecovery,allareusingthesamefile,incaseofnameduplication.Status:Flags.HerearealsothefuzzyflagsKCVFHHBP001Hotbackup-in-progressonfile(fuzzyfile)KCVFHHBM002Endhotbackupmarke

44、rseen(BitonlyvalidorsetinOracle7)KCVFHOFZ004OnlinefuzzybecauseitwasonlineanddbopenKCVFHCRM008CrashRecoveryMediamarkerseen(BitonlyvalidorsetinOracle7)KCVFHMFZ010Mediarecoveryfuzzy-fileinmediarecoveryKCVFHCMF020Clearmediarecovery(BitonlyvalidorsetinOracle7)KCVFHAFZ040Absolutelyfuzzy-fuzzinessfromfiles

45、canKCVFHBCP100BadCheckpoint-noenabledthreadbitvec(InOracle7thisflagmeans:FilebelongstoSYSTEMtablespace)KCVFHFMH200Freshlymungedheader.Resetlogsarenotfinished.Bitisclearedatnextcheckpoint.AsetbitallowsanOPENRESETLOGStoberepeated(forexample,fileheaderswereupdated(thisbitwasset)butcontrolfilerecordnotu

46、pdated)KCVFHXCH400Externallycachedbyoperatingsystem.IftheserverisawareofanOScachethatdelayswritestomedia,thenthisbitgetsset,andtheserverwillforceamediarecoverywhenfileisreopened.KCVFHZBA800Zeroedblocksallowed.FilemaycontainOracle7unusedblocks,whichareallzero.Oracle8blockshaveanonzeroinitialvaluewith

47、SEQandTAIL.KCVFHPCP1000ProxycopyinprogressRootdba:Thisfieldonlyoccursindatafile#1,andisthelocationofblocksrequiredduringbootstrappingthedatadictionary(bootstrap$)CheckpointCount:Numberofcheckpointsattemptedtothisfile(somemayhavebeenskipped,ifthefilealreadyhasacheckpointatalatertimethenthecheckpointn

48、owbeingattempted).Helpstodetectfilesthathavebeenrestored.ControlfileCheckpointCount:Savedcopyofthecontrolfilerecordofthecheckpointcount.Helpsdetectoldcontrolfiles.begin-hot-backupfilesize:UpdatedwhenBackupSCNisupdated.Tocopewithdatafilesthatwereresizedduringbackup.CheckpointSCN:Updatedoneverycheckpo

49、int,butnotwheninHotbackupstate(notonlinebackups).Thismustremainuntouchedwhenyouareinhotbackupmode,becauseyoumightgetcheckpointsbetweentheBEGINBACKUPandwhenyouactuallystartthecopyingprocess.BackupCheckpoint:UpdatedwiththecheckpointdonewhilefileinHotbackup.Externalcacheid:Usedtoensurethatconcurrentins

50、tancesaccessdatathroughconsistentexternalcache.AbsoluteFuzzySCN:Showsthisfileisabackupcopyandisfuzzy.RecoveryfuzzySCN:TheSCNatwhichtherecoveryofthisfilewillbecomplete(noIongerfuzzy).BothabovefuzzySCNsmustbezerouniessafuzzyflagisset,andmustbegreaterthanthecheckpointSCNCommentinthecodethatexaminesthef

51、uzzybits:/*Fuzzy-Wuzzywasafile.*Fuzzy-Wuzzyneedsnoredo.*Fuzzy-Wuzzywasntfuzzy,washe?*/DataFileBlocksDatafileblocksarenotcoveredinthiscourse,becausetheyhavebeencoveredinothercoursesinthisseries.这里就有两种方法来dumpDatafileheader：使用sql语句：SQLaltersystemseteventsimmediatetracenamefile_hdrslevel3;使用oradebug命令，这

52、里用oradebug命令示例SQLoradebugsetmypidStatementprocessed.SQLoradebugdumpfile_hdrs10Statementprocessed.SQLoradebugtracefile_name/u01/app/oracle/admin/anqing/udump/anqing_ora_4556.trc这里会把所有的datafile的header都dump出来，我们从trace里找到file#1的dump：DATAFILE#1:(name#7)/u01/app/oracle/oradata/anqing/system01.dbfcreations

53、ize=0blocksize=8192status=0 xehead=7tail=7dup=1tablespace0,index=1krfil=1prev_file=Ounrecoverablescn:0 x0000.0000000001/01/198800:00:00Checkpointcnt:140sen:0 x0000.0014c0c110/30/201117:46:40Stopscn:0 xffff.ffffffff10/30/201116:29:42CreationCheckpointedatsen:0 x0000.0000000906/30/200519:10:11thread:0

54、rba:(0 x0.0.0)enabledthreads:00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000Offlinesen:0 x0000.0006ce7aprev_range:0OnlineCheckpointedatsen:0 x0000.0006ce7b10/09/201113:47:55thread:1rba:(0 x1.2.0)

55、enabledthreads:01000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000HotBackupendmarkersen:0 x0000.00000000aux_fileisNOTDEFINEDV10STYLEFILEHEADER:CompatibilityVsn=169869568=0 xa200100DbID=695026631=0 x2

56、96d43c7,DbName=ANQINGActivationID=0=0 x0ControlSeq=1049=0 x419,Filesize=64000=0 xfa00FileNumber=1,Blksiz=8192,FileType=3DATATablespace#0-SYSTEMrel_fn:1Creationatsen:0 x0000.0000000906/30/200519:10:11Backuptakenatsen:0 x0000.0000000001/01/198800:00:00thread:0resetlogscount:0 x2d8b028bsen:0 x0000.0006

57、ce7bresetlogsterminalrevdata:0 x0sen:0 x0000.00000000prevresetlogscount:0 x2184ef74sen:0 x0000.00000001prevresetlogsterminalrevdata:0 x0sen:0 x0000.00000000recoveredat10/30/201117:46:38status:0 x2004rootdba:0 x00400179chkptcnt:140ctlcnt:139begin-hot-backupfilesize:0Checkpointedatsen:0 x0000.0014c0c1

58、10/30/201117:46:40thread:1rba:(0 x46.2.10)enabledthreads:01000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000BackupCheckpointedatsen:0 x0000.00000000thread:0rba:(0 x0.0.0)enabledthreads:00000000000000

59、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000Externalcacheid:0 x00 x00 x00 x0Absolutefuzzysen:0 x0000.00000000Recoveryfuzzysen:0 x0000.0000000001/01/198800:00:00TerminalRecoveryStamp01/01/198800:00:00PlatformInformation:CreationP