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?
Make sure that you are restoring the datafiles from backup which was taken prior to the time to which you want to recover.
Click Here to Expand Forum to Full Width