time based recovery
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: time based recovery

  1. #1
    Join Date
    Aug 2002
    Posts
    115

    Unhappy

    Hi,
    I tried this time based recovery stuff and it dint work.

    i needed to recover using a cold backup till 15:45

    so i gave the command

    RECOVER DATABASE UNTIL TIME '2002-09-02:15:45:00';

    AND IT GAVE ME THIS ERROR!

    ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
    ORA-01195: online backup of file 1 needs more recovery to be consistent
    ORA-01110: data file 1: 'D:\ORACLE\ORADATA\TEST\SYSTEM01.DBF'

    Now I want to recover data only till this time, but I thought some data associated with this would be in the next log file.
    But the system gave me error for each log file , asking for the next logfile, and in the end giving me the latest data , while I needed the data till the specified time.

    Can anyone help me with this , as to where i might have gone wrong?

    Thank you

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Make sure that you are restoring the datafiles from backup which was taken prior to the time to which you want to recover.

    Sanjay


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