Database Duplication Is Failing with Errors ORA-32015 While Restoring spfile

 

RMAN Command Id : 2025-12-02T16:27:31

RMAN Command Id : 2025-12-02T16:27:31

RMAN Command Id : 2025-12-02T16:27:31

released channel: CH1

released channel: CH2

released channel: CH3

released channel: CH4

released channel: CH5

released channel: CH6

released channel: CH7

released channel: CH8

released channel: CH9

released channel: CH10

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of Duplicate Db command at 12/02/2025 16:28:00

RMAN-05501: aborting duplication of target database

RMAN-03015: error occurred in stored script Memory Script

ORA-19870: error while restoring backup piece CONTROLFILE_c-1559836067-20251202-0a

ORA-32015: unable to restore SPFILE

ORA-17502: ksfdcre:4 Failed to create file +DATA/ORCL/PARAMETERFILE/spfile.266.1168338843

ORA-15046: ASM file name '+DATA/ORCL/PARAMETERFILE/spfile.266.1168338843' is not in single-file creation form

RMAN Client Diagnostic Trace file : /applications/oracle/d19.3.0/oracle_base/diag/clients/user_oracle/RMAN_486667218_110/trace/ora_rman_3055249_0.trc

RMAN Server Diagnostic Trace file : /applications/oracle/d19.3.0/oracle_base/diag/rdbms/ORCL/ORCL/trace/ORCL_ora_3055258.trc

RMAN Server Diagnostic Trace file : /applications/oracle/d19.3.0/oracle_base/diag/rdbms/ORCL/ORCL/trace/ORCL_ora_3055253.trc

Database Duplication Is Failing with Errors ORA-32015 While Restoring spfile (Doc ID 2981581.1)

 

Solution

Action Plan which helped to resolve the issue given in the above Bug was :

If the spfile is specified within CRS on the auxiliary instance, this will cause the error for the spfile. Clearing it removes the issue.

Run the below command at the Auxiliary DB to confirm if spfile has been configured in CRS

$ srvctl config database -db '<db_unique_name/db_name>';

 

The above command showed that spfile setting was configured in CRS.

Clear the spfile setting in CRS using the below command : 

At the Auxiliary DB

========

$ srvctl modify database -db <db_unique_name/db_name> -spfile '' # it is two single quotes

 

 Then the spfile got Restored and RMAN Duplicate was successful.