ORA-01207: file is more recent than control file - old control file的处理方法

1. 连接数据库

sqlplus / as sysdba
2. 启动数据库，此时会报标题中的错误
startup

3.备份创建控制文件的脚本语句，并从中拷贝出相关的NORESETLOGS模式的创建控制文件的语句（如步骤6示）

alter database backup controlfile to trace as '/home/oragisc/ora_ctl_file_bak.txt';

4，关闭数据库

shutdown immediate;

5, nomount启动数据库
STARTUP NOMOUNT;
6,步骤3中产生的文件ora_ctl_file_bak.txt中拷贝出相关语句，创建新的控制文件：

CREATE CONTROLFILE REUSE DATABASE "DATADB" NORESETLOGS  NOARCHIVELOG
    MAXLOGFILES 16
    MAXLOGMEMBERS 3
    MAXDATAFILES 1000
    MAXINSTANCES 8
    MAXLOGHISTORY 292
LOGFILE
  GROUP 1 (
    '/gisc_1/ora_data/datadb/redo_online_a/redo01_a.log',
    '/gisc_1/ora_data/datadb/redo_online_b/redo01_b.log'
  ) SIZE 500M,
  GROUP 2 (
    '/gisc_1/ora_data/datadb/redo_online_a/redo02_a.log',
    '/gisc_1/ora_data/datadb/redo_online_b/redo02_b.log'
  ) SIZE 500M,
  GROUP 3 (
    '/gisc_1/ora_data/datadb/redo_online_a/redo03_a.log',
    '/gisc_1/ora_data/datadb/redo_online_b/redo03_b.log'
  ) SIZE 500M
DATAFILE
  '/gisc_1/ora_data/datadb/db_sys/system01.dbf',
  '/gisc_1/ora_data/datadb/db_sys/undotbs01.dbf',
  '/gisc_1/ora_data/datadb/db_sys/sysaux01.dbf',
  '/gisc_1/ora_data/datadb/db_sys/users01.dbf',
  '/gisc_1/ora_data/datadb/tbs_data_01/tbs_datadb_data_01_f01.dbf',
  '/gisc_1/ora_data/datadb/tbs_data_01/tbs_datadb_data_01_f02.dbf',
  '/gisc_1/ora_data/datadb/tbs_data_01/tbs_datadb_data_01_f03.dbf',
  '/gisc_1/ora_data/datadb/db_sys/users02.dbf',
  '/gisc_1/ora_data/datadb/db_sys/users03.dbf'
CHARACTER SET AL32UTF8
;
7，RECOVER DATABASE;
8，ALTER DATABASE OPEN;

9，

ALTER TABLESPACE TEMP ADD TEMPFILE '/gisc_1/ora_data/datadb/db_sys/temp01.dbf' REUSE;
ALTER TABLESPACE TBS_DATADB_TEMP_01 ADD TEMPFILE '/gisc_1/ora_data/datadb/tbs_temp_01/tbs_datadb_temp_01_f02.dbf' REUSE;
ALTER TABLESPACE TBS_DATADB_TEMP_01 ADD TEMPFILE '/gisc_1/ora_data/datadb/tbs_temp_01/tbs_datadb_temp_01_f01.dbf' REUSE;

转载于:https://www.cnblogs.com/cloudwind2011/p/7898919.html