recover datafile into new tablespace
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: recover datafile into new tablespace

  1. #1
    Join Date
    Sep 2000
    Location
    Chicago, IL
    Posts
    316
    one of the datafiles was lost in a move !

    and since this was a test database, I dropped the datafile and tablespace from the control file...so at this point the database has forgotten about the tablespace and datafile.

    But, them my sys admin tells me he can get the file from a backup tape...we do have the arch files also.

    I create a new tablespace, with the same datafile name that was lost...next I rename the orignal file (from backup) as the file of the tablespace that I just created. Then I did a checkpoint ! It complained about:

    ORA-01122: database file 71 failed verification check
    ORA-01203: wrong incarnation of this file - wrong creation SCN

    Is this because the tablespace was created after the SCN of the datafile ?

  2. #2
    Join Date
    Jul 2002
    Location
    California
    Posts
    128
    khussain,

    The old datafile has a different creation scn than the datafile from the new tablespace. Since the tablespace was dropped, the database does not know or care about the previous datafile. When you created the new tablespace, that is the new point of reference for the database.

    ORA-01203: wrong incarnation of this file - wrong creation SCN is because the database is expecting the creation scn from the newly created tablespace and your datafile contains an older creation scn.


  3. #3
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    [XYZ:/oracle/orahome/admin/TEMP]$oerr ora 1122
    01122, 00000, "database file %s failed verification check"
    // *Cause: The information in this file is inconsistent with information
    // from the controlfile. See accompanying message for reason.
    // *Action: Make certain that the db files and controlfiles are the correct
    // files for this database.
    [XYZ:/oracle/orahome/admin/TEMP]$oerr ora 1203
    01203, 00000, "wrong incarnation of this file - wrong creation SCN"
    // *Cause: The creation SCN in the file header is not the same as the
    // creation SCN in the controlfile. This is probably a copy of a
    // file that was dropped.
    // *Action: Restore a current copy of the data file and do recovery as needed.

    The creation SCN in the file header is not the same

    You have to restore it from the backup to recover it...
    Reddy,Sam

  4. #4
    Join Date
    Sep 2000
    Location
    Chicago, IL
    Posts
    316
    Originally posted by sreddy
    You have to restore it from the backup to recover it...
    I did recover it from backup...can I still restore it, even though I dropped the tablespace ?

  5. #5
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Originally posted by khussain
    can I still restore it, even though I dropped the tablespace ?
    You can if you have backup... You restore it to a previous backup and then recover it using the logs to a specific point in time (which is a point just before you dropped it)
    Reddy,Sam

  6. #6
    Join Date
    Sep 2000
    Location
    Chicago, IL
    Posts
    316
    Oooh ! I got it...that makes sense.

    I have to restore the whole database, then apply the arch logs up untill before the tablespace was dropped - thanks.

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