recover database until time

[PaulH]

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

[PAVB]

I'm not sure you got the concept of point-in-time recovery... it relies on having hot backups followed by archivelog backups. It seams to me you are attempting point-in-time recovery with a cold backup.

[PaulH]

These are the instructions I found on-line, granted they are old but what step am I missing.

Incomplete Recovery Using Time-Based

Scenario: The current time is 12 pm on 9-Mar-01 and someone dropped the
EMP table around 11:45 am. The table must be recovered.
If the database is open, shut it down using either the "normal" or "immediate" options: SVRMGR> shutdown normal;

Mount the database:
SVRMGR> startup mount pfile=Oracle\admin\mike\pfile\init.ora;
Restore all datafiles(*.dbf) from the most recent backup. (Do not restore
the Control file, Redo Logs, or Parameter files.)
UNIX> !cp /disk1/backup/*.dbf /disk1/data/
NT > !copy c:\backup\*.dbf c:\data\

Recover the database: SVRMGR> recover database until time '2001-03-09:11:44:00';

To synchronize datafiles with control files and redo logs, open database using
"resetlogs" options:
SVRMGR> alter database open resetlogs;

Any data entered after the recovery time (11:44 am) will need to be reentered.
Perform a closed whole backup

[PAVB]

The hot backup part perhaps?