Hi
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> pwd
+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/
ASMCMD>
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
pfile.341.917883357
oracle@exa0501adm01vm01 ~]$ srvctl config database -db d3e02a
Database unique name: d3e02a
Database name: d3e02a
Oracle home: /u01/app/oracle/product/12.1.0.2/dbhome_2
Oracle user: oracle
Spfile: +DATAC2/D3E02A/PARAMETERFILE/spfile.341.917883357. <<--- spfile
Password file: +DATAC2/D3E02A/PASSWORD/orapwd3e02a
Thanks in advance
Regads,
Lavie