All:

I am trying to get the recover database until time option to work.

I took the following steps

1) created a table and added 25 rows to it and at 10:30AM

2) I shutdown the database

3) I backed up the data file associated with the tablespace.

4) I startuped database

5) 10:35AM I dropped the table.

6) shutdown database

7) I restored datafile from back

8) startup mount database

9) recover database until time '2009-02-25:10:30:00';

I get the following erorr: ORA-00283: recovery session canceled due to errors
ORA-19907: recovery time or SCN does not belong to recovered incarnation

Is there a table I need to query first to find the correct time I can recover
too? Or is there something wrong with my test case. If so, can somebody
please correct

Thanks in advance to all who answer this post