Hi,
Sorry about the confusion. It's my mistake.
I wanted to do a full database recovery using my init.ora file. To do so, i need to recover my controlfile so that i can mount my database.
RMAN> restore controlfile from autobackup;
I do a daily backup of my database. If i do a recovery on 31 AUG, the controlfile restored will be from the backup done on 30 AUG right?
In this case, can i do a PITR on my database using RMAN through the following commands
run{
set until time "to_date('08/28/07 15:00:00' , 'mm/dd/yy hh24:mi:ss')";
restore database;
recover database;
alter database open resetlogs;}
to restore the database to 29 AUG using my restored controlfile?
Thanks!