can i recover it on same box ?

Hi guys,

i am wondering a situtation where i have rman based full backup of database with current file into it.here i am thinkning about if i delete my database and recreate the service with the same name and retaining the dir structur intact as it was for previous database.

i thouht ..

sql > set oracle_sid = 'sidname'

sql> con /as sysdba

sql>startup nomount pfile='same pfile as it used for prevoius db'

rman > run {

restore controlfile ;
restore database ;
recover database ;
}

will it work and if not,then why ?

thanks
Alok.

$ rman Received on Tue Oct 04 2005 - 01:25:18 CDT