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