ORA-17502: ksfdcre:4 Failed to create file “FILE NAME” / ORA-15173: entry ‘string’ does not exist in directory ‘string’

RMAN> restore spfile from ‘+FRA/SRPRIMT/AUTOBACKUP/2016_07_10/s_788290484.315.788290487’;
Starting restore at 10-JUL-16
using channel ORA_DISK_1
channel ORA_DISK_1: restoring spfile from AUTOBACKUP +FRA/SRPRIMT/AUTOBACKUP/2016_07_10/s_788290484.315.788290487
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 07/10/2016 17:57:17
ORA-19870: error while restoring backup piece +FRA/srprimt/autobackup/2016_07_10/s_788290484.315.788290487
ORA-32015: unable to restore SPFILE
ORA-17502: ksfdcre:4 Failed to create file +DATA/srprimt/spfilesrprimt.ora
ORA-15173: entry ‘srprimt’ does not exist in directory ‘/’
SQL> alter diskgroup DATA add directory ‘+DATA/srprimt’;
Diskgroup altered.
RMAN> restore spfile from ‘+FRA/SRPRIMT/AUTOBACKUP/2016_07_10/s_788290484.315.788290487’;
Starting restore at 10-JUL-16
using channel ORA_DISK_1
channel ORA_DISK_1: restoring spfile from AUTOBACKUP +FRA/SRPRIMT/AUTOBACKUP/2016_07_10/s_788290484.315.788290487
channel ORA_DISK_1: SPFILE restore from AUTOBACKUP complete
Finished restore at 10-JUL-16
RMAN> exit
  • October 4, 2016 | 33 views