Advertisements
Skip to content
July 13, 2012 / Shivananda Rao P

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, 2013, 2014. 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.

Advertisements

2 Comments

Leave a Comment
  1. Suresh / Feb 10 2013 6:49 am

    Hi Shiva,

    Your explanation was nice. I struggled with this error for 3 days. I searched oracle documentation, metalink…. What ever I found I implemented. But this one has given me solution in 3 mins. Thanks for your explaination. Much appreciated.

    Thanks & Regards,
    Suresh.

  2. Shivananda Rao P / Feb 10 2013 7:16 am

    Thank you Suresh. Good to hear that it helped.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: