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

ORA-15173 error normally comes when the required directory is unavailable under the ASM diskgroup.

I came across this error while restoring the SPFILE to directory +DATA. The database had crashed and had to be restored completely. The database name was SRPRIMT and the directory named SRPRIMT was unavailable under the Diskgroup +DATA where I was trying to restore the database.

RMAN> restore spfile from '+FRA/SRPRIMT/AUTOBACKUP/2012_07_10/s_788290484.315.788290487';

Starting restore at 10-JUL-12
using channel ORA_DISK_1

channel ORA_DISK_1: restoring spfile from AUTOBACKUP +FRA/SRPRIMT/AUTOBACKUP/2012_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/2012 17:57:17
ORA-19870: error while restoring backup piece +FRA/srprimt/autobackup/2012_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 '/'

In order to overcome this issue, I had to create a directory called SRPRIMT under diskgroup DATA through the ASM instance.

Connect to the ASM instance and create the directory SRPRIMT as shown below.

SQL> alter diskgroup DATA add directory '+DATA/srprimt';

Diskgroup altered.

Now, I tried to restore the spfile and was able to do it without any issues.

RMAN> restore spfile from '+FRA/SRPRIMT/AUTOBACKUP/2012_07_10/s_788290484.315.788290487';

Starting restore at 10-JUL-12
using channel ORA_DISK_1

channel ORA_DISK_1: restoring spfile from AUTOBACKUP +FRA/SRPRIMT/AUTOBACKUP/2012_07_10/s_788290484.315.788290487
channel ORA_DISK_1: SPFILE restore from AUTOBACKUP complete
Finished restore at 10-JUL-12

RMAN> exit

Creation of the specified directory at the required location (under Diskgroup) resolved the issue.

Here we go !!

COPYRIGHT

© Shivananda Rao P, 2012 to 2018. Unauthorized use and/or duplication of this material without express and written permission from this blog’s author and/or owner is strictly prohibited. Excerpts and links may be used, provided that full and clear credit is given to Shivananda Rao and http://www.shivanandarao-oracle.com with appropriate and specific direction to the original content.

DISCLAIMER

The views expressed here are my own and do not necessarily reflect the views of any other individual, business entity, or organization. The views expressed by visitors on this blog are theirs solely and may not reflect mine.