rman duplicate error

[Roshan]

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

[ErmanArslansOracleBlog]

That note says - >

Question:  Do you have an "init<primary_sid>.ora" in the $ORACLE_HOME/dbs directory at the target/source database host?
Answer :  Yes, there is a PFILE init<primary_sid>.ora there.

So in your case, do you have an init<SID>.ora in your source instance or not?
What is initdware11.ora there?

Note says -> Remove the pfile from the Target Database $ORACLE_HOME/dbs if the database is started using the SPFILE.
Then execute the duplicate database again.

That "target" means RMAN Target, which means source.

Also it checks the auxilariy spfile by this name -> /u01/app/ora12c/product/12.1.0/dbhome_1/dbs/spfiledware11.ora.

So it checks 11.ora not 1.ora..

Your TNS connection should be RAC-RMAN Duplicate aware as well.

Please review this one -> STEP BY STEP RMAN DUPLICATE Database From RAC ASM To RAC ASM (Doc ID 1913937.1)

[Roshan]

Issue is resolved after copying the spfile from shared disk to dbs.