recovery datafile
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: recovery datafile

  1. #1
    Join Date
    May 2000
    Location
    fremont ca
    Posts
    182
    out of 4 datafiles d1,d2,d3,d4 , one corrupted (d1).
    I want to recover d1.
    I have a backup of last night only.
    I restore from last night backup (not cuurent).
    Three data files are current and d1 is from last night.
    now I want to recover this data file to current , I have all redo logs.

    I try follwoing
    shutdown normal;
    startup mount
    recover datafile '/x/y/d1.dbf' (not working)
    recover tablespce d1 ( not working)
    recover database ( not working)
    recover database until cancel (not working)

    All the time it give me message

    ORA-00283: recovery session canceled due to errors
    ORA-01190: controlfile or data file 12 is from before the last RESETLOGS
    ORA-01110: data file 12: '/x/y/d1.dbf'


  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Error: ORA 1190
    Text: control file or datafile is from before the last RESETLOGS
    -------------------------------------------------------------------------------
    Cause: An attempt was made to perform media recovery when the redo log reset
    information in a datafile does not match the control file.
    Either the datafile or the control file must be a backup that was made
    before the most recent ALTER DATABASE OPEN RESETLOGS.
    Action: Restore the file from a more recent backup.


    You can't apply the recovery from archived redo logs and SCNs are not compatible as the database opened with RESETLOGS option after backup taken.
    Reddy,Sam

  3. #3
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    This is an important rule:

    ALWAYS AFTER DOING AN ALTER DATABASE OPEN RESETLOGS, TAKE A BACKUP OF YOUR DB.

    Cheers

    Angel

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