recover database until time
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