If you have
lost the server parameter file, you can restore it from the autobackup. The
procedure is similar to restoring the control file from autobackup. Set the
DBID for your database and then issue the RESTORE SPFILE FROM AUTOBACKUP
command.
If you are
restoring the SPFILE to a nondefault location, specify the command as follows:
RESTORE SPFILE TO
<file_name> FROM AUTOBACKUP
If you are
restoring the server parameter file from the Flash Recovery Area, specify the
command as follows:
RMAN> run {
2> restore spfile from
autobackup
3> recovery area =
'<flash recovery area destination>'
4> db_name = '<db_name>';
5> }
