source: RAC DB 2 nodes 12.1.0.2 DB.
SID: dware11, dware12
target: filesystem, 12.1.0.2 DB
SID: dware1
Hello Team,
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
RMAN> **end-of-file**
RMAN>
Regards,
Joe