本篇内容介绍了“数据库中ORACLE的启动验证分析”的有关知识，在实际案例的操作过程中，不少人都会遇到这样的困境，接下来就让小编带领大家学习一下如何处理这些情况吧！希望大家仔细阅读，能够学有所成！

oradebugdumpfile_hdrs3DATAFILE#5:(name#8)/dev/raw/raw12creationsize=64000blocksize=8192status=0xehead=8tail=8dup=1tablespace5,index=6krfil=5prev_file=0unrecoverablescn:0x0000.0000000001/01/198800:00:00Checkpointcnt:43scn:0x0000.000a531009/13/201806:18:03Stopscn:0x0000.000a531009/13/201806:18:03CreationCheckpointedatscn:0x0000.0000224908/29/201809:27:02thread:1rba:(0x1.7a18.10)enabledthreads:010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000Offlinescn:0x0000.00000000prev_range:0OnlineCheckpointedatscn:0x0000.00000000thread:0rba:(0x0.0.0)enabledthreads:000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000HotBackupendmarkerscn:0x0000.00000000aux_fileisNOTDEFINEDaboveinformationfromctl------------------------------------------------------------------------------------------V10STYLEFILEHEADER:CompatibilityVsn=169870592=0xa200500DbID=880153879=0x34761517,DbName='NGKF'ActivationID=0=0x0ControlSeq=280=0x118,Filesize=64000=0xfa00FileNumber=5,Blksiz=8192,FileType=3DATATablespace#5-USERSrel_fn:5Creationatscn:0x0000.0000224908/29/201809:27:02Backuptakenatscn:0x0000.0000000001/01/198800:00:00thread:0resetlogscount:0x3abc6817scn:0x0000.00000001resetlogsterminalrcvdata:0x0scn:0x0000.00000000prevresetlogscount:0x0scn:0x0000.00000000prevresetlogsterminalrcvdata:0x0scn:0x0000.00000000recoveredat09/13/201806:11:32status:0x0rootdba:0x00000000chkptcnt:43ctlcnt:42begin-hot-backupfilesize:0Checkpointedatscn:0x0000.000a531009/13/201806:18:03thread:1rba:(0xb.185.10)enabledthreads:011000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000BackupCheckpointedatscn:0x0000.00000000thread:0rba:(0x0.0.0)enabledthreads:000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000Externalcacheid:0x00x00x00x0Absolutefuzzyscn:0x0000.00000000Recoveryfuzzyscn:0x0000.0000000001/01/198800:00:00TerminalRecoveryStamp01/01/198800:00:00PlatformInformation:CreationPlatformID:13CurrentPlatformID:13LastPlatformID:13DUMPOFTEMPFILES:1filesindatabase

当使用 file_hdrs 事件来转储数据文件头信息时，Oracle 会转储两部分信息，一部分来自控制文件，一部分来自数据文件，在数据库启动过程中，这两部分信息要用来进行启动验证。

验证过程：

第一次检查数据文件头中的 Checkpoint cnt 是否与对应控制文件中的 Checkpoint cnt

一致，如果相等,进行第二次检查;

file_hdrs.chkpt.cnt=ctl.chkpt.cnt

第二次检查数据文件头的开始SCN和对应控制文件中的结束SCN是否一致如果结束

SCN 等于开始 SCN,则不需要对那个文件进行恢复。

file_hdrs.start_scn = clt.stop.scn

对每个数据文件都完成检查后,打开数据库.同时将每个数据文件的结束 SCN 设置为无穷

大。

以上面的转储信息为例：

clt中（横线上半部分中）最重要的几个地方

这部分中包含的重要信息有:

检查点计数: Checkpoint cnt:检查点 SCN: scn:

Checkpointcnt:43scn:0x0000.000a531009/13/201806:18:03

数据文件 Stop SCN

Stopscn:0x0000.000a531009/13/201806:18:03

数据文件头的信息（横线上半部分中）最重要的几个地方

u 检查点 SCN: Checkpointed at scn

u 检查点计数: chkpt cnt

Checkpointedatscn:0x0000.000a531009/13/201806:18:03

chkptcnt:43ctlcnt:42

这两者都和控制文件中所记录的一致。如果这两者一致，数据库启动时就能通过验证，启动数据库。

如果不一致，启动的时候，会有报错

ERRORatline1:ORA-01113:file4needsmediarecoveryORA-01110:datafile4:'/opt/oracle/oradata/eygle/eygle01.dbf'

执行恢复

recover datafile 4;

“数据库中ORACLE的启动验证分析”的内容就介绍到这里了，感谢大家的阅读。如果想了解更多行业相关的知识可以关注亿速云网站，小编将为大家输出更多高质量的实用文章！