ORA-01122 database file 1 failed verification check,ORA-01207: file is more rece

0987

数据库

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

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