Restore DB fails with errors ORA-19504: ORA-17502: Ksfdcre:4 Failed To Create File (Doc ID 2534497.1)

Last updated on APRIL 18, 2024

Applies to:

Symptoms

Part of restore database, when trying to restore controlfile, getting below issue

RMAN> run
{
2> 3> allocate channel XXXXX;
4> restore controlfile from 'c-XXXXXXX';
5> }

using target database control file instead of recovery catalog
allocated channel: c1
...

..

Starting restore at 08-APR-19

channel c1: restoring control file
released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 04/08/2019 09:37:52
ORA-19870: error while restoring backup piece c-8961173-20190405-00
ORA-19504: failed to create file "+DATAC3"
ORA-17502: ksfdcre:4 Failed to create file +DATAC3
ORA-15001: diskgroup "DATAC3" does not exist or is not mounted
ORA-15040: diskgroup is incomplete

RMAN>

cell trace output: /opt/oracle/cell18.1.4.0.0_LINUX.X64_180125.3/log/diag/asm/cell/XXXX/trace 

Warning:  Two databases from different clusters have the same DB_UNIQUE_NAME 
parameter value of "ORCL".

Changes

Restoring Database from available backups.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.