数据库重启以后报

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博客

ORA-01122 ORA-01110 ORA-01207