# 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;

Leave a Reply

Your email address will not be published. Required fields are marked *