# restore an spfile – with no mount
sqlplus / as sysdba
startup nomount pfile=/path/initSID.ora
# rman command
rman target /
RESTORE SPFILE FROM ‘/u01/app/oracle/flash_recovery_area/PROD/autobackup/2015_09_13/o1_mf_s_601036454_2kkk8px2_.bkp’;
# restore a control file with no mount mode
sqlplus / as sysdba
startup nomount pfile=/path/initSID.ora
# rman commands
restore controlfile from ‘/path-to-backup/c–30392xxx’;
or
restore controlfile from autobackup;
# restore an entire db from full backup – database must be mounted
sqlplus / as sysdba
startup mount pfile= or just use spfile with no pfile option
#rman command
restore database;
recover database;
# then provided all archivelogs are there and the redologs are good too
alter database open;
or optionally – if you don’t have redologs
recover database set until sequence=;
alter database open resetlogs;