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