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

Problem

SQL> alter database open;

ORA-00283: recovery session canceled due to errors
ORA-01122: database file 1 failed verification check
ORA-01110: data file 1: ‘/app/oracle/oradata/rac10g/system01.dbf’
ORA-01207: file is more recent than control file – old control file

Solution: recreate the control file.

1) dump controlfile to trace

SQL> alter database backup controlfile to trace as ‘/tmp/create_controlf.sql';

2) startup database nomount

SQL> startup nomount

3) create the control file

copy the script to create control file from trace file

SQL> CREATE CONTROLFILE REUSE DATABASE “RAC10G” NORESETLOGS  NOARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 ‘/app/oracle/oradata/rac10g/redo01.log’  SIZE 50M,
GROUP 2 ‘/app/oracle/oradata/rac10g/redo02.log’  SIZE 50M,
GROUP 3 ‘/app/oracle/oradata/rac10g/redo03.log’  SIZE 50M
DATAFILE
‘/app/oracle/oradata/rac10g/system01.dbf’,
‘/app/oracle/oradata/rac10g/undotbs01.dbf’,
‘/app/oracle/oradata/rac10g/sysaux01.dbf’,
‘/app/oracle/oradata/rac10g/users01.dbf’
CHARACTER SET WE8ISO8859P1
;

Control file created.

4) recover database using backup controlfile

sys@rac10g> recover database using backup controlfile;

ORA-00279: change 460683 generated at 09/02/2011 19:50:43 needed for thread 1
ORA-00289: suggestion :
/app/oracle/flash_recovery_area/RAC10G/archivelog/2011_09_02/o1_mf_1_33_%u_.arc
ORA-00280: change 460683 for thread 1 is in sequence #33

———- Give the last redo log file to apply (get from v$logfile)

/app/oracle/oradata/rac10g/redo03.log
Log applied.
Media recovery complete.

5) open the database

SQL> alter database open resetlogs;
Database altered.

About these ads

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: