rman duplicate error

Posted by Roshan on Aug 14, 2020; 6:02am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/rman-duplicate-error-tp8638.html

Hi Erman,

I am getting error below when executing RMAN duplicate

source: RAC DB 2 nodes 12.1.0.2 DB.

SID: dware11, dware12

 

target: filesystem, 12.1.0.2 DB

SID: dware1


when performing RMAN duplicate, I am getting error below. RMAN is looking for spfile on target. Kindly advise. Spfile is located in asm disk.

RMAN> run{
2> allocate channel c1 type disk;
3> allocate channel c2 type disk;
4> allocate channel c3 type disk;
5> allocate auxiliary channel stby type disk;
6> duplicate target database for standby from active database
7> DORECOVER
8>   spfile
9>     set db_unique_name='dwaredr'
10>     set control_files='/data/DATA/dware1/control01.ctl','/data/DATA/dware1/control02.ctl'
11>     set fal_client='dwdr'
12>     set fal_server='dware1'
13> set log_archive_max_processes='5'
14>     set standby_file_management='AUTO'
15>     set log_archive_config='dg_config=(dware1,dwaredr)'
16>     set db_file_name_convert='+DATA/DWARE1/DATAFILE','/data/DATA/dware1'
17>     set log_file_name_convert='+DATA/DWARE1/DATAFILE','/data/DATA/dware1/log'
18>     set log_archive_dest_1='LOCATION=/archive/ARC/ VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=dwaredr'
19> ;
20> }

using target database control file instead of recovery catalog

allocated channel: c1

channel c1: SID=859 instance=dware12 device type=DISK

 

 

allocated channel: c2

channel c2: SID=2563 instance=dware12 device type=DISK

 

 

allocated channel: c3

channel c3: SID=3554 instance=dware11 device type=DISK

 

 

allocated channel: stby

channel stby: SID=233 device type=DISK

 

 

Starting Duplicate Db at 14-AUG-20

current log archived

 

 

contents of Memory Script:

{

   backup as copy reuse

   passwordfile auxiliary format  '/u01/app/ora12c/product/12.1.0/dbhome_1/dbs/orapwdware1'   targetfile

'/u01/app/ora12c/product/12.1.0/dbhome_1/dbs/spfiledware11.ora' auxiliary format

'/u01/app/ora12c/product/12.1.0/dbhome_1/dbs/spfiledware1.ora'   ;

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

}

executing Memory Script

 

 

Starting backup at 14-AUG-20

RMAN-03009: failure of backup command on c2 channel at 08/14/2020 06:09:04

ORA-19505: failed to identify file "/u01/app/ora12c/product/12.1.0/dbhome_1/dbs/spfiledware11.ora"

ORA-27037: unable to obtain file status

SVR4 Error: 2: No such file or directory

Additional information: 3

ORA-27037: unable to obtain file status

SVR4 Error: 2: No such file or directory

Additional information: 3

continuing other job steps, job failed will not be re-run

released channel: c1

released channel: c2

released channel: c3

released channel: stby

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

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

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

RMAN-03002: failure of Duplicate Db command at 08/14/2020 06:09:05

RMAN-05501: aborting duplication of target database

RMAN-03015: error occurred in stored script Memory Script

 

 

RMAN-03009: failure of backup command on c2 channel at 08/14/2020 06:09:04

ORA-19505: failed to identify file "/u01/app/ora12c/product/12.1.0/dbhome_1/dbs/spfiledware11.ora"

ORA-27037: unable to obtain file status

SVR4 Error: 2: No such file or directory

Additional information: 3

ORA-27037: unable to obtain file status

SVR4 Error: 2: No such file or directory

Additional information: 3

Why is RMAN looking for spfile in dbs on target?

Tried steps from (Doc ID 1930486.1). Not working.

on target:

ora12c@dware1:/u01/app/ora12c/product/12.1.0/dbhome_1/dbs$ ls
c-1280214393-20190902-01    c-1281647995-20190910-03
c-1280214393-20190902-02    core
c-1280214393-20190903-00    hc_dware_1.dat
c-1280214393-20190904-01    hc_dware1.dat
c-1280214393-20190904-03    hc_dware11.dat
c-1281647995-20190905-02    id_dware_1.dat
c-1281647995-20190905-03    id_dware1.dat
c-1281647995-20190905-04    id_dware11.dat
c-1281647995-20190905-05    init.ora
c-1281647995-20190906-00    initdware1.oraBK
c-1281647995-20190906-03    initdware11.ora
c-1281647995-20190906-05    initdware11.ora_14JULY2020
c-1281647995-20190906-06    orapwcbs
c-1281647995-20190907-03    orapwdware
c-1281647995-20190910-02    snapcf_dware1.f

On auxiliary:
ora12c@dwaredr:/u01/app/ora12c/product/12.1.0/dbhome_1/dbs$ ls
core                        initdware1.ora12AUG20
hc_dware_1.dat              initdware11.ora_14JULY2020
hc_dware1.dat               initdware11.oraBK
hc_dware11.dat              lkDWAREDR
hc_dwaredr.dat              orapwcbs
id_dware_1.dat              orapwdware
id_dware1.dat               orapwdware1
id_dware11.dat              snapcf_dware1.f
init.ora                    spfiledware1.ora
initdware1.ora

Regards,

Roshan