How to Restore spfile from autobackup in ORACLE

How to Restore spfile from autobackup in ORACLE

If you have lost the SPFILE (server parameter file), and your Database abnormally shutdown. Then you will try to startup your Database but you got an error regarding spfile not found. You can restore spfile from autobackup using RMAN. NOTE:- Database must be in archivelog mode and must be configured Controlfile Autobackup on. Error : … Read more