ORA-01110: data file 1: '/free/oracle/oradata/orcl/system01.dbf'

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

出现了ORA-01207错误：

SQL> shutdown abort

ORACLE instance shut down.

SQL> quit

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options

首先删除old control file，其实也可以不删除，个人习惯，然后重建控制文件。

重建控制文件可以在数据库到mount状态下执行alter database backup controlfile to trace生成sql文件，具体操作很简单，不再描述。

IXDBA.NET技术社区

[oracle@localhost orcl]$ rm -rf control0*

[oracle@localhost orcl]$ vi create.sql

STARTUP NOMOUNT

CREATE CONTROLFILE REUSE DATABASE "ORCL" NORESETLOGS  ARCHIVELOG

    MAXLOGFILES 16

    MAXLOGMEMBERS 3

    MAXDATAFILES 100

    MAXINSTANCES 8

    MAXLOGHISTORY 292

LOGFILE

  GROUP 1 '/free/oracle/oradata/orcl/redo01.log'  SIZE 50M,

  GROUP 2 '/free/oracle/oradata/orcl/redo02.log'  SIZE 50M,

  GROUP 3 '/free/oracle/oradata/orcl/redo03.log'  SIZE 50M

-- STANDBY LOGFILE

DATAFILE

  '/free/oracle/oradata/orcl/system01.dbf',

  '/free/oracle/oradata/orcl/undotbs01.dbf',

  '/free/oracle/oradata/orcl/sysaux01.dbf',

  '/free/oracle/oradata/orcl/users01.dbf',

  '/free/oracle/oradata/orcl/gaojfdb.dbf'

CHARACTER SET AL32UTF8

;