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

最新推荐文章于 2021-04-04 01:19:35 发布

宋小荣

最新推荐文章于 2021-04-04 01:19:35 发布

阅读量6.4k

点赞数

CC 4.0 BY-SA版权

分类专栏：备份恢复文章标签： ORA-01122 ORA-01207

本文链接：https://blog.youkuaiyun.com/robo23/article/details/39617819

备份恢复专栏收录该内容

10 篇文章

订阅专栏

本文详细记录了一次数据库恢复过程，包括强制关闭数据库、控制文件与数据文件不一致问题解决、重建控制文件以及数据库成功打开的步骤。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

数据库

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.youkuaiyun.com/robo23

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