DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

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

  1. #1
    Join Date
    Feb 2007
    Posts
    1

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

    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

  2. #2
    Join Date
    Nov 2004
    Location
    Mumbai, India
    Posts
    452
    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
    Your controlfile in not current.
    Use the current controlfile or recover using backup controlfile

    $ oerr ora 1207
    01207, 00000, "file is more recent than controlfile - old controlfile"
    // *Cause: The controlfile change sequence number in the data file is
    // greater than the number in the controlfile. This implies that
    // the wrong controlfile is being used. Note that repeatedly causing
    // this error can make it stop happening without correcting the real
    // problem. Every attempt to open the database will advance the
    // controlfile change sequence number until it is great enough.
    // *Action: Use the current controlfile or do backup controlfile recovery to
    // make the controlfile current. Be sure to follow all restrictions
    // on doing a backup controlfile recovery.
    There are three kinds of lies: Lies, damned lies, and benchmarks...

    Unix is user friendly. It's just very particular about who it's friends are.

    Oracle DBA

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width