Recover the SPFile and Control File

Loss of SPfile only:

step 1: Take Full Backup

backup database plus archivelog;

step 2: remove spfile

show parameter spfile
!rm -rf /u01/app/oracle/init.ora

step 3: shutdown the databse

shut immediate

step 4: start the db with 'force nomount'

RMAN>
startup force nomount;
restore spfile from 'take lastest control file backup piece';
startup force;

step 5: verify the spfile location.

Loss of All ControlFile Only:

step 1: shutdown the DB or Kill the db process

kill -9  <get pid>    --Use ps -ef|grep pmon
(OR)
shut immediate

step 2:start the DB with nomount stage and recover

RMAN>
startup nomount
restore controlfile from autobackup; –AUTOBACKUP OF CONTROL FILE IS ENABLED
restore controlfile from 'take lastest control file backup piece'; –use Backup piece
sql 'alter database mount';
recover database;
alter database open resetlogs;