Oracle Backup & Recovery Techniques - Oracle 10g Database Administration Concepts and Implementation Made Simple - page 327

Step 3:
The first query will let you know about current SCN (System
Change Number) whereas the second query will let know about
both oldest_flashback_scn and oldest_flashback_time.
SQL> SELECT current_scn
FROM v$database;
SQL>SELECT oldest_flashback_scn,
oldest_flashback_time
FROM v$flashback_database_log;
Step 4:
Get into RMAN.
C:\Documents and Settings\Administrator>rman
RMAN> CONNECT TARGET
Step 5:
In case you use SCN then use the following statement.
RMAN> FLASHBACK DATABASE TO SCN=451373;
In case you use the time then use the following statement.
RMAN> FLASHBACK DATABASE TO TIMESTAMP
(SYSDATE-1/24);
Or
RMAN> FLASHBACK DATABASE TO TIMESTAMP
timestamp'2004-10-05 16:00:00';
Step 6:
Finally open the database with RESETLOGS option as you
recovered the database prior point in time.
SQL> ALTER DATABASE OPEN RESETLOGS;