Restore from previous full backup of database (archivelog mode)
I was hoping some one could check over the logic of the following restore scenario. I have successful full back of my database in archivelog mode timestamp='Mar 15 2013 3:45:28' . I want to restore from that backup and overwrite the current database. Here is my script :-
startup nomount;
rman target=/ nocatalog
set DBID 99999999
run {
allocate channel ............;
set until time "to_date('Mar 15 2013 ','Mon DD YYYY HH24:MI:SS')";
restore controlfile from autobackup;
alter database mount;
restore database;
recover database noredo;
alter database open resetlogs;
}