Restore spfile from rman backup
SPFILE RECOVERY: Take backup of spfile via rman rman target / backup spfile; Now in order to restore the same: Create a pfile with initSID.ora name and enter DB_NAME parameter in it. vi $ORACLE_HOME/dbs/initSID.ora DB_NAME=TEST · Start DB in nomount with force and set DBID ( It is necessary to know the DBID ). post that you can restrore spfile and then restore your controlfile and then you will be required to start your database with reset log option. rman target / startup force nomount; set dbid 2943784586; restore spfile from '/backup/backup_of_spfile.bkp'; restore controlfile from '/backup/latest_controlfile_backup.bkp'; alter database mount; alter database open resetlogs; Thanks & Regards Nikh...