ORA-01122 ORA-01110 ORA-01207

数据库重启以后报

SQL> startup

ORACLE instance started.

Total System Global Area 3340451840 bytes

Fixed Size                  2232960 bytes

Variable Size            1845497216 bytes

Database Buffers         1476395008 bytes

Redo Buffers               16326656 bytes

Database mounted.

ORA-01122: database file 1 failed verification check

ORA-01110: data file 1: '/data/u01/app/oracle/oradata/ora11g/system01.dbf'

ORA-01207: file is more recent than control file - old control file

解决办法

备份控制文件信息

mount下

alter database backup controlfile to trace as '/home/oracle/tracecontrol.trc';

shutdown immediate

STARTUP NOMOUNT

CREATE CONTROLFILE REUSE DATABASE "ORA11G" NORESETLOGS  ARCHIVELOG

    MAXLOGFILES 16

    MAXLOGMEMBERS 3

    MAXDATAFILES 100

    MAXINSTANCES 8

    MAXLOGHISTORY 292

LOGFILE

  GROUP 1 '/data/u01/app/oracle/oradata/ora11g/redo01.log'  SIZE 50M BLOCKSIZE 512,

  GROUP 2 '/data/u01/app/oracle/oradata/ora11g/redo02.log'  SIZE 50M BLOCKSIZE 512,

  GROUP 3 '/data/u01/app/oracle/oradata/ora11g/redo03.log'  SIZE 50M BLOCKSIZE 512

-- STANDBY LOGFILE

DATAFILE

  '/data/u01/app/oracle/oradata/ora11g/system01.dbf',

  '/data/u01/app/oracle/oradata/ora11g/sysaux01.dbf',

  '/data/u01/app/oracle/oradata/ora11g/undotbs01.dbf',

  '/data/u01/app/oracle/oradata/ora11g/users01.dbf'

CHARACTER SET ZHS16GBK

;

RECOVER DATABASE

ALTER DATABASE OPEN;

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

转载于:http://blog.itpub.net/16719800/viewspace-715531/