unsychronized datafile and control file
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: unsychronized datafile and control file

  1. #1
    Join Date
    Apr 2001
    Posts
    257
    Hi,

    My database was in NOARCHIVEDLOG mode and I did a closed backup by copying all the datafiles, control file, and parameter file to a different location. Howerver, I forgot to copy a datafile called scott.ora. I make some changes to a table stored in user01.ora and intentionally "damaged" the datafile user01.ora to test out the backup procedure. So I restored all the datafiles and control file to the original location. Howerver, since scott.ora was not backed up, scott.ora has a different/later SCN. When I did a startup, it complains:

    ORA-01122: database file 7 failed verification check
    ORA-01110: data file 7: 'F:\ORACLE\ORADATA\TEST\SCOTT.ORA'
    ORA-01207: file is more recent than controlfile - old controlfile

    Does anybody know how to recover from this kind of situation completely, if possible?

    Thanks!


  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    You can't. You're in noarchivelog mode.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Nov 2001
    Posts
    335
    You can not recover from this situation, however, if datafile that you lost is not critical you could try to build a control file from a trace (assuming that have a trace of controlfile) and do not reference 'F:\ORACLE\ORADATA\TEST\SCOTT.ORA' .
    Of cource a bunch of objects will be invalid , but some rest of them will be O'k.
    Give it a try, you do not have anything to lose anyway.
    One, who thinks that the other one who thinks that know and does not know, does not know either!

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