problem recovering datafile
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: problem recovering datafile

  1. #1
    Join Date
    Mar 2005
    Posts
    143

    problem recovering datafile

    I need to recover a datafile. I took the datafile offline, restored a backup of the datafile, and started to recover the file. I issued the following command:
    recover datafile 'F:\ORACLE\ORADATA\PSSYS1\PTTBL.DBF'
    and got the following message:
    ORA-00283: recovery session canceled due to errors
    ORA-01190: controlfile or data file 90 is from before the last RESETLOGS
    ORA-01110: data file 90: 'F:\ORACLE\ORADATA\PSSYS1\PTTBL.DBF'
    I am new at this so any help would be greatly appreciated.

  2. #2
    The error seems pretty straightforward. Has anyone performed a open database RESETLOGS since that datafile was last backed up?

  3. #3
    Join Date
    Mar 2005
    Posts
    143
    Yes, does this mean I can't recover the datafile?
    I am trying to prctice different recovery senarios. I recoved the entire database, before and at the end of that when I oppened the Db I reset the logs because that was the only way to open it. I am now trying to recover a deleted data file.

  4. #4
    Join Date
    Jun 2006
    Posts
    259
    If you open the DB with a reset logs... It is a Very good idea to immediately backup.

    Any backups taken prior to the reset logs would not be of any benefit in a future media recovery.

    It sounds like you have restored a Datafile from a backup taken before a resetlogs.
    Don't do that! Its not possible to restore this datafile since the scn information is now mismatched from the log data. There is no way nowto recovery your deleted data file.

  5. #5
    I hope when you say 'practice different recovery models' you were using a throwaway DB...

  6. #6
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612
    From 10g you can restore across resetlogs, but not in prior versions.
    Assistance is Futile...

  7. #7
    Join Date
    Jul 2002
    Posts
    335
    waitecj, must confess I wasn't aware of this in 10g, which doc is it in, I just gone through them but must have missed it.

    Bazza

  8. #8
    Join Date
    Aug 2006
    Posts
    2
    Hello
    As all other people have said, I agree its Essential Practice to Backup Database after Rsetlogs.

    There may be a way out from your scenario to recover, If your database was in archive mode and you have all the archive logs with you from the day you had taken cold backup of your database.

    Restore all copies of your all datafiles
    Perform recovery till cancle or till time (Time just before you took your datafile offline earlier)

    Regards

    Mandar

  9. #9
    Join Date
    Aug 2006
    Posts
    2
    Hello
    As all other people have said, I agree its Essential Practice to Backup Database after Rsetlogs.

    There may be a way out from your scenario to recover, If your database was in archive mode and you have all the archive logs with you from the day you had taken cold backup of your database.

    Restore all copies of your all datafiles
    Perform recovery till cancle or till time (Time just before Reset logs)
    This would be partial recovery, data after the resetlogs would be lost.

    Regards

    Mandar

  10. #10
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612
    Quote Originally Posted by bazza
    waitecj, must confess I wasn't aware of this in 10g, which doc is it in, I just gone through them but must have missed it.

    Bazza

    http://www.oracle.com/technology/pub...k9_10gdba.html

    Its also taught in the 10gR2 New Features course at OU. It works by the archivelogs having an additional identifier to show the database incarnation so that Oracle is aware that archive log 001 of incarnation 1 is different to archive log 001 of incarnation 2.
    Last edited by waitecj; 09-05-2006 at 03:28 AM.
    Assistance is Futile...

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