The following script will recover your database to a specific time in the past.

rman catalog rman/rman@rman target sys/change@prod

run
{
shutdown immediate;
startup mount;
set until time “to_date(’03/15/2006 15:00:00″), ‘mm/dd/yyyy hh24:mi:ss’)”;
# set until scn 1000; # alternatively, you can specify SCN
# set until sequence 4578; # alternatively, you can specify log sequence number
restore database;
recover database;
alter database open resetlogs;
}