Sunday, December 13, 2020

Duplicate of a Database Fails With Error: ORA-17502: ksfdcre:4 Failed to create file

 Problem:

Duplicate of a database fails with this error:
ORA-32015: unable to restore SPFILE
ORA-17502: ksfdcre:4 Failed to create file +DATA/ORCLDR/PARAMETERFILE/spfile.273.1040900343
ORA-15046: ASM file name '+DATA/ORCLDR/PARAMETERFILE/spfile.273.1040900343' is not in single-file creation form
ORA-19660: some files in the backup set could not be verified
ORA-19685: SPFILE could not be verified
ORA-19849: error while reading backup piece from service ORCL
ORA-32015: unable to restore SPFILE
ORA-17502: ksfdcre:4 Failed to create file +DATA/ORCLDR/PARAMETERFILE/spfile.273.1040900343
ORA-15046: ASM file name '+DATA/ORCLDR/PARAMETERFILE/spfile.273.1040900343' is not in single-file creation form

Analysis:

You cannot duplicate over an already exist database (with datafiles), you should run the duplicate to restore against a blank instance doesn't have any file in ASM diskgroup side.
 

Solution:

Drop the target database which is being restored, and then start up a blank instance with same name with proper parameters, then try again the duplicate command

Example:

dbca -silent -deleteDatabase -sourceDB ORCLDR -sysDBAUserName sys -sysDBAPassword password111

No comments:

Post a Comment