ORA-01207: file is more recent than controlfile - old controlfile. Urgent!

[Former Member]

Hello to all!

I am requesting urgent help for error that this me being generated.

I am testing of recovery of Backup Online and Offline of my Server SAP of Production in 4.6B and Oracle 8.1.7.

For it I have of test a server where recreates my database exactly equal PRD in another server, taking for it a Full Backup Offline of the original system. Which I obtained successfully my exact copy of my system PRD with a backup offline of Sunday, the 05th, this I include the control files, data file, redo logs, etc.

Once up my PRD instance, he generate the following redo log of agreement to the sequence with the number 8420.

Then initiate the second test of recovery, which was to take a backup online of the original system of production to my PRD's new copy, for it take a Backup Online of type ALL of Wednesday, the 07th Feb in the night, and execute a BRRESTORE with the following command BRRESTORE - m all-b sesion.anf in PRD's copy, with the database in mode MOUNT. My utility of backup is Legato Networker.

Once finished my brrestore and trying to startup database, I am the following error:

ORA-01122: database file 1 failed verification check

ORA-01110: data file 1: 'E:\ORACLE\PRD\SAPDATA1\SYSTEM_1\SYSTEM.DATA1'

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

Server Manager complete.

When I connect in sql, and I apply the command:

Select * from v$log; he show me:

SQL> select * from v$log;

GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS

-

---

-

---

-

---

-

---

-

---

--- -

---

FIRST_CHANGE# FIRST_TIM

-

---

-

---

11 1 8421 20971520 2 NO CURRENT

25324322 07-FEB-07

12 1 8419 20971520 2 YES INACTIVE

25297374 04-FEB-07

13 1 8418 20971520 2 YES INACTIVE

25288754 03-FEB-07

GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS

-

---

-

---

-

---

-

---

-

---

--- -

---

FIRST_CHANGE# FIRST_TIM

-

---

-

---

14 1 8420 20971520 2 YES INACTIVE

25302582 04-FEB-07

I take the redo log 8421of my original PRD, and copy it in my directory saparch, but the date of the redo log 8421 is of the 04th of Feb 7:00 pm and the one that shows me in the V$LOG is of the 07th of feb.

Is it my first test of restore online and not that I must do????

I appreciated very much for the help that they could give me, since I must deliver these tests as soon as possible.

Desiree

[Former Member]

Hi Ammey.

I execute recover database until cancel using backup controlfile; but the error is tha same....

I am going to repeat the process the restore with the option -m FULL to try.

Because the brrestore -m ALL, restore all tablespaces without the control file and redo log files from the backup and -m FULL including both.

I hope that everything works well

Regards,

Desiree

[Former Member]

Hi,

You can use restore by below command

brrestore -b <backuplogfile> -m full

It will restore all datafiles, backup controle file and online redolog files.

Regards

Upender Reddy

[Former Member]

Hi,

FOR THE ERROR:

ORA-01122: database file 1 failed verification check

ORA-01110: data file 1: 'E:\ORACLE\PRD\SAPDATA1\SYSTEM_1\SYSTEM.DATA1'

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

Server Manager complete.

It seems the scn in the control file and the data file do not matches.

Hence the said error is fired.

For this we have to adjust the control file.

Pl try the following

START the database in mount mode

executr the following:

SQL> ALTER DATABASE BACKUP CONTROL FILE TO TRACE;

SHUTDOWN IMMEDIATE;

The trace file so created will be located in the directory specified in the initialization parameter USER_DUMP_DEST.

To know the USER_DUMP_DEST check the pfile.

open the same in note pad.

copy the followng from that file it will be something like the following:

STARTUP NOMOUNT;

CREATE CONTROLFILE REUSE DATABASE "DEV" NORESETLOGS NOARCHIVELOG

-- SET STANDBY TO MAXIMIZE PERFORMANCE

MAXLOGFILES 5

MAXLOGMEMBERS 3

MAXDATAFILES 100

MAXINSTANCES 1

MAXLOGHISTORY 226

LOGFILE

GROUP 1 'D:\ORACLE\ORADATA\DEV\REDO01.LOG' SIZE 100M,

GROUP 2 'D:\ORACLE\ORADATA\DEV\REDO02.LOG' SIZE 100M,

GROUP 3 'D:\ORACLE\ORADATA\DEV\REDO03.LOG' SIZE 100M

-- STANDBY LOGFILE

DATAFILE

'D:\ORACLE\ORADATA\DEV\SYSTEM01.DBF',

'D:\ORACLE\ORADATA\DEV\UNDOTBS01.DBF',

'D:\ORACLE\ORADATA\DEV\INDX01.DBF',

'D:\ORACLE\ORADATA\DEV\TOOLS01.DBF',

'D:\ORACLE\ORADATA\DEV\USERS01.DBF'

CHARACTER SET WE8MSWIN1252;

Paste the avove lines so copied in SQL prompt and execute.

Then execute the following:

SQL> RECOVER DATABASE

SQL> alter database open;

This will help.

Pl award a point if helpful/.

Regards

[Former Member]

Hello Dcardena,

You DO NOT have to start the restore all over again.

brrestore has the facility to restore individual files. (controlfiles, datafiles, etc)

Go through SAP Help for brrestore options. This will save your time.

If you have not already started the restore, let me know if you want the exact commands to restore individual files. (That are missing)

Regards,

Ammey Kesarkar

<i>'Award points for useful info'</i>

[Former Member]

Hi Ammey

I have start de Restore once again with the option -m FULL.

I hope run and working ok when startup database.

I will warn the result you.

Regards,

Desiree

[v_veeramalla]

Hello,

We are facing the same issue , please let me know the exact command so that will try to resolve the issue.

/Veeramalla

[Former Member]

Hello D,

As per the given senario & errors, it seems to be that the controlfile present on the target is older than the restored datafiles.

You will be required to provide the controlfile of the backup that was used for restore.

Check if you are using the right controlfile for recovery.

You have used online backup, hence you have to recover the database by applying redolog files till consistancy and then start the database.

e.g: recover database using backup controlfile until <used backup's end timestamp>;

Regards,

Ammey Kesarkar

<i>'Award points for useful info'</i>