datafiles timestamps out of sync w/controlfiles
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: datafiles timestamps out of sync w/controlfiles

  1. #1
    Join Date
    Jul 2000
    Posts
    41

    Smile

    Hi,
    I need help!
    I did a NT backup yesterday and included all our datafiles, controlfiles and system.dbf, but forgot the index datafiles,rbs01.dbf file.

    After restoring the datafiles,controlfile and system.dbf I can't open the database because:
    ORA-01207 file is more recent than controlfile -old controlfile.

    It's attempting to open rbs.dbf file which has a newer timestamp on it than the controlfile says it has.
    I do not have another backup of the controlfile.

    How can I get the rbs.dbf file and index.dbf file in sync with the controlfile again?
    I tried to re-create the controlfile using Oracle's recommended way and get an error saying attempting to restore the system.dbf file

  2. #2
    Join Date
    Mar 2000
    Location
    Sydney
    Posts
    9
    It's as easy as this.

    When you mount the database, it says those two files need recovery.

    Put those to datafiles on to offline mode and drop.

    Then you would be able to open the database.

    Drop the tablespace and recreate them as it's an ordinary RBS tablespace.
    GK

  3. #3
    Join Date
    Oct 2000
    Location
    Cambridge, MA (Boston)
    Posts
    144
    You cannot re-create the controlfile if you have datafiles with different SCNs. If you restored all the files but your index & rbs files, that is the case.

    Dropping the datafiles can be risky. Drop the index files if you are sure there are no data segments and you can re-create the indices. Dropping the RBSs can be dicier. If you end up needing RBS for recovery, you won't be able to recover. Take another backup of what you have now (but keep the prior backup set(s)).

    Are you running in archivelog mode? If so, after your backup, attempt RECOVER DATABASE USING BACKUP CONTROLFILE; You will need all your archived redologs and online-redo logs.

    Good luck.

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