ITPub博客

首页 > 数据库 > Oracle > ORA-1207: ORA 1207 file is more recent than control file

ORA-1207: ORA 1207 file is more recent than control file

原创 Oracle 作者:renjixinchina 时间:2014-01-26 15:30:21 0 删除 编辑

ORA-1122 :database file %s failed verification check
ORA-1110 : datafile : 
ORA-1207: ORA 1207 file is more recent than control file

 

该错误表明:

数据文件头部信息与控制文件信息部一致,数据文件头部CHECKPOINT大于controlfile

CHECKPOINT,需要重建控制文件

1.Mount the database
SQL> Startup mount


2. Save the information from the control file:

SQL> Alter database backup controlfile to trace;


3. Create a control file creation script from the tracefile generated in user_dump_dest.

Use the Noresetlogs option


4. Shutdown the database and start it in NOMOUNT mode

SQL> shutdown abort
SQL> startup nomount


5. Create the control file

alter database backup controlfile to trace;


6.Recover the database

SQL> recover database;


7. Open the database

SQL> Alter database open;

 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/15747463/viewspace-1075613/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2011-01-30

  • 博文量
    373
  • 访问量
    2057312