ORA-01122 database file 1 failed verification check,ORA-01207: file is more recent than control file

数据库

 SQL> startup force;
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.

Total System Global Area  260046848 bytes
Fixed Size      2095472 bytes
Variable Size    113247888 bytes
Database Buffers   134217728 bytes
Redo Buffers     10485760 bytes
Database mounted.
ORA-01122: database file 1 failed verification check
ORA-01110: data file 1:
'/backup/copy/copy_ORA10G_data_D-ORA10G_I-4160719624_TS-SYSTEM_FNO-1_2hpbolmn'
ORA-01207: file is more recent than control file - old control file

SQL> recover database;

ORA-00283: recovery session canceled due to errors
ORA-01122: database file 1 failed verification check
ORA-01110: data file 1:
'/backup/copy/copy_ORA10G_data_D-ORA10G_I-4160719624_TS-SYSTEM_FNO-1_2hpbolmn'
ORA-01207: file is more recent than control file - old control file

 

startup forc=shutdown abort + startup

强行关闭数据库,导致控制文件与数据文件不一致,数据库无法打开,尝试恢复数据库也失败

 

dbv检测1号数据文件:

[oracle@tivoli02 newdb]$ dbv file=/backup/copy/copy_ORA10G_data_D-ORA10G_I-4160719624_TS-SYSTEM_FNO-1_2hpbolmn blocksize=8192

DBVERIFY: Release 10.2.0.5.0 - Production on Sat Sep 27 21:05:36 2014

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

DBVERIFY - Verification starting : FILE = /backup/copy/copy_ORA10G_data_D-ORA10G_I-4160719624_TS-SYSTEM_FNO-1_2hpbolmn


DBVERIFY - Verification complete

Total Pages Examined         : 53760
Total Pages Processed (Data) : 35763
Total Pages Failing   (Data) : 0
Total Pages Processed (Index): 6413
Total Pages Failing   (Index): 0
Total Pages Processed (Other): 2857
Total Pages Processed (Seg)  : 1
Total Pages Failing   (Seg)  : 0
Total Pages Empty            : 8727
Total Pages Marked Corrupt   : 0
Total Pages Influx           : 0
Highest block SCN            : 13165633 (0.13165633)

并未发现坏块

 

重建控制文件:

SQL> show parameter contro;

NAME         TYPE
------------------------------------ ---------------------------------
VALUE
------------------------------
control_file_record_keep_time      integer
7
control_files        string
/u01/app/oracle/product/10.2.0
/db_1/dbs/cntrlora10g.dbf
SQL> alter database backup current controlfile to trace as '/tmp/a.ctl';
alter database backup current controlfile to trace as '/tmp/a.ctl'
                      *
ERROR at line 1:
ORA-00905: missing keyword

SQL> alter database backup controlfile to trace as '/tmp/a.ctl';

Database altered.

SQL> startup force nomount;
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.

Total System Global Area  260046848 bytes
Fixed Size      2095472 bytes
Variable Size    113247888 bytes
Database Buffers   134217728 bytes
Redo Buffers     10485760 bytes

SQL>

CREATE CONTROLFILE REUSE DATABASE "ORA10G" NORESETLOGS  ARCHIVELOG
    MAXLOGFILES 16
    MAXLOGMEMBERS 3
    MAXDATAFILES 100
    MAXINSTANCES 8
    MAXLOGHISTORY 584
LOGFILE
  GROUP 7 '/backup/copy/redo07.log'  SIZE 50M,
  GROUP 8 '/backup/copy/redo08.log'  SIZE 50M,
  GROUP 9 '/backup/copy/redo09.log'  SIZE 50M
DATAFILE
  '/backup/copy/copy_ORA10G_data_D-ORA10G_I-4160719624_TS-SYSTEM_FNO-1_2hpbolmn',
  '/backup/copy/copy_ORA10G_data_D-ORA10G_I-4160719624_TS-UNDOTBS1_FNO-2_2gpbolmn',
  '/backup/copy/copy_ORA10G_data_D-ORA10G_I-4160719624_TS-SYSAUX_FNO-3_2ipbolmn',
  '/backup/copy/copy_ORA10G_data_D-ORA10G_I-4160719624_TS-TSA_FNO-5_2jpbolmn',
  '/backup/copy/copy_ORA10G_data_D-ORA10G_I-4160719624_TS-TSB_FNO-6_2kpbolmo',
  '/backup/copy/copy_ORA10G_data_D-ORA10G_I-4160719624_TS-TSC_FNO-7_2lpbolnh',
  '/backup/copy/copy_ORA10G_data_D-ORA10G_I-4160719624_TS-TSD_FNO-8_2mpbolnh'
CHARACTER SET N8PC865
;

Control file created.

SQL>
SQL>
SQL> alter database mount;
alter database mount
*
ERROR at line 1:
ORA-01100: database already mounted

 

SQL> recover database;
Media recovery complete.
SQL> alter database open;

Database altered.

SQL> SELECT * FROM T;

  I D
---------- ---------------
  1 05-JUL-14
  2 27-SEP-14
  3 27-SEP-14
  4 27-SEP-14

数据库恢复以后可以顺利打开.

 

-------------------------------------------------------------------------------------------------

本文来自于我的技术博客 http://blog.csdn.net/robo23

转载请标注源文链接,否则追究法律责任!