Skip to Main Content

rman duplicate failed while running stored script Memory Script to create spfile

LavieJun 8 2020 — edited Jun 10 2020


rman duplicate failed while running stored script Memory Script to create spfile, as shown below:

[oracle@exa0501adm01vm01 ~]$ tail -f clone_d3lab01a.log

allocated channel: t08

channel t08: SID=1580 instance=d3e02a1 device type=DISK

allocated channel: stby4

channel stby4: SID=432 device type=DISK

Starting Duplicate Db at 08-JUN-2020 17:23:14

current log archived

contents of Memory Script:


   backup as copy reuse

   targetfile  '+DATAC2/d3e02a/spfiled3e02a.ora' auxiliary format

'/u01/app/oracle/product/12.1.0/dbhome_1/dbs/spfiled3lab01a1.ora'   ;

   sql clone "alter system set spfile= ''/u01/app/oracle/product/12.1.0/dbhome_1/dbs/spfiled3lab01a1.ora''";


executing Memory Script

Starting backup at 08-JUN-2020 17:23:47

released channel: t01

released channel: t02

released channel: t03

released channel: t04

released channel: t05

released channel: t06

released channel: t07

released channel: t08

released channel: stby4

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

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

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

RMAN-03002: failure of Duplicate Db command at 06/08/2020 17:23:48

RMAN-05501: aborting duplication of target database

RMAN-03015: error occurred in stored script Memory Script

RMAN-03009: failure of backup command on t01 channel at 06/08/2020 17:23:48

ORA-19505: failed to identify file "+DATAC2/d3e02a/spfiled3e02a.ora"

ORA-15173: entry 'spfiled3e02a.ora' does not exist in directory 'd3e02a'

Recovery Manager complete.

In fact, there is no alias spfiled3e02a.ora under +DATAC2/d3e02a

My question is why the memory script uses targetfile  '+DATAC2/d3e02a/spfiled3e02a.ora' instead of +DATAC2/D3E02A/PARAMETERFILE/spfile.341.917883357 which is the source database spfile and how to overcome this issue?

files under +DATAC2/D3E02A:



ASMCMD> ls -l

Type  Redund  Striped  Time  Sys  Name

                             Y    CHANGETRACKING/

                             Y    CONTROLFILE/

                             Y    DATAFILE/

                             Y    ONLINELOG/

                             Y    PARAMETERFILE/

                             N    PASSWORD/

                             Y    TEMPFILE/


SQL> show parameter unique

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

db_unique_name                       string      d3e02a

SQL> show parameter spfile

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

spfile                               string      +DATAC2/D3E02A/PARAMETERFILE/s


oracle@exa0501adm01vm01 ~]$ srvctl config database -db d3e02a

Database unique name: d3e02a

Database name: d3e02a

Oracle home: /u01/app/oracle/product/

Oracle user: oracle

Spfile: +DATAC2/D3E02A/PARAMETERFILE/spfile.341.917883357.  <<--- spfile

Password file: +DATAC2/D3E02A/PASSWORD/orapwd3e02a

Thanks in advance



Post Details
Added on Jun 8 2020