Get the timestamp to where you have to restore database.

Get the timestamp to where you have to restore database.

Login to (PROD) with oracle user.
> sqlplus '/as sysdba'
   
SQL> show parameter user_dump_dest    

NAME                         VALUE
------------------------------------ ----------- ---------------------
user_dump_dest       /diag/rdbms/trace  

    Find that statement from bottom to top to find the last "alter database backup control file....."

Look for the line "Beginning log switch checkpoint...". Above to this line you will find the time   stamp and to that point you can restore your db.                          

    view /trace/alert_SID.log                              
    Completed: alter database backup controlfile to trace
    Sat Jan 05 00:26:19 2013
    Completed checkpoint up to RBA [0x7cd.2.10], SCN: 12794086485103
    Sat Jan 05 00:31:57 2013
   
Incremental checkpoint up to RBA [0x7cd.cd2c6.0], current log tail at RBA [0x7cdd
   .e54ed.0]

    Sat Jan 05 00:41:27 2013


This is the restore time stamp.
 
Beginning log switch checkpoint up to RBA [0x7ce.2.10], SCN: 12794086881892

  Thread 1 advanced to log sequence 1998 (LGWR switch)