My Oracle Support Banner

RMAN Active Duplicate for Standby for RAC Database Unable to Find the Password File Failing with: ORA-19505, and ORA-27037 (Doc ID 1551235.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Information in this document applies to any platform.
*** Checked for relevance on 27-NOV-2015 ***

Symptoms

Running Rman Active Duplicate to Create Standby from RAC Primary.

Scan Listener is used to connect to the RAC 2 Node as Target.

RMAN Duplicate failing with: 

RMAN> connect target *
2> connect auxiliary *
3> RUN {
4> ALLOCATE CHANNEL d01 TYPE DISK PARMS="BLKSIZE=1048576";
5> ALLOCATE CHANNEL d02 TYPE DISK PARMS="BLKSIZE=1048576";
6> ALLOCATE CHANNEL d03 TYPE DISK PARMS="BLKSIZE=1048576";
7> ALLOCATE CHANNEL d04 TYPE DISK PARMS="BLKSIZE=1048576";
8> ALLOCATE CHANNEL d05 TYPE DISK PARMS="BLKSIZE=1048576";
9> ALLOCATE CHANNEL d06 TYPE DISK PARMS="BLKSIZE=1048576";
10> ALLOCATE CHANNEL d07 TYPE DISK PARMS="BLKSIZE=1048576";
11> ALLOCATE CHANNEL d08 TYPE DISK PARMS="BLKSIZE=1048576";
12> ALLOCATE AUXILIARY CHANNEL cnv01 TYPE DISK PARMS="BLKSIZE=8388608";
13> ALLOCATE AUXILIARY CHANNEL cnv02 TYPE DISK PARMS="BLKSIZE=8388608";
14> ALLOCATE AUXILIARY CHANNEL cnv03 TYPE DISK PARMS="BLKSIZE=8388608";
15> ALLOCATE AUXILIARY CHANNEL cnv04 TYPE DISK PARMS="BLKSIZE=8388608";
16> ALLOCATE AUXILIARY CHANNEL cnv05 TYPE DISK PARMS="BLKSIZE=8388608";
17> ALLOCATE AUXILIARY CHANNEL cnv06 TYPE DISK PARMS="BLKSIZE=8388608";
18> ALLOCATE AUXILIARY CHANNEL cnv07 TYPE DISK PARMS="BLKSIZE=8388608";
19> ALLOCATE AUXILIARY CHANNEL cnv08 TYPE DISK PARMS="BLKSIZE=8388608";
20> DUPLICATE TARGET DATABASE
21> FOR STANDBY
22> FROM ACTIVE DATABASE
23> DORECOVER
24> SPFILE
25> SET db_unique_name='SAMER'
26> SET control_files='+SAMER_REDO01/TEST_SAMER_01.ctl','+SAMER_REDO02/TEST_SAMER_02.ctl'
27> SET log_archive_dest_1='LOCATION=+SAMER_ARCH01 VALID_FOR=(ALL_LOGFILES,ALL_ROLES)'
28> SET log_archive_dest_2='SERVICE=TEST LGWR AFFIRM ASYNC NET_TIMEOUT=30 COMPRESSION=ENABLE DB_UNIQUE_NAME=TEST VALID_FOR=(ONLINE_LOGFILE,PRIMARY_ROLE)'
29> SET fal_server='TEST'
30> SET db_file_name_convert='+TEST_DATA','+SAMER_DATA01'
31> SET log_file_name_convert='+TEST_REDO1','+SAMER_REDO01','+TEST_REDO2','+SAMER_REDO02'
32> SET standby_file_management='AUTO'
33> SET log_archive_config='dg_config=(TEST,SAMER)'
34> SET parallel_execution_message_size="65536"
35> SET db_recovery_file_dest='+SAMER_ARCH01'
36> SET db_recovery_file_dest_size="536870912000"
37> SET DB_CREATE_ONLINE_LOG_DEST_1='+SAMER_REDO01'
38> SET DB_CREATE_ONLINE_LOG_DEST_2='+SAMER_REDO02'
39> SET DB_CREATE_FILE_DEST='+SAMER_DATA01'
40> SET diagnostic_dest='/u02/app/oracle/diag'
41> NOFILENAMECHECK;
42> }
43> ..
.
.
.
contents of Memory Script:
{
backup as copy reuse
targetfile '/u01/app/oracle/product/11.2.0/db_1/dbs/orapwTEST1' auxiliary format
'/u02/app/oracle/product/11.2.0/dbs/orapwTEST1' targetfile
'+TEST_DATA/TEST/spfileTEST.ora' auxiliary format
'/u02/app/oracle/product/11.2.0/dbs/spfileTEST1.ora' ;
sql clone "alter system set spfile= ''/u02/app/oracle/product/11.2.0/dbs/spfileTEST1.ora''";
}
executing Memory Script

Starting backup at 05-MAY-13
RMAN-03009: failure of backup command on d01 channel at 05/05/2013 04:54:54
ORA-19505: failed to identify file "/u01/app/oracle/product/11.2.0/db_1/dbs/orapwTEST1"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
continuing other job steps, job failed will not be re-run
released channel: d01
released channel: d02
released channel: d03
released channel: d04
released channel: d05
released channel: d06
released channel: d07
released channel: d08
released channel: cnv01
released channel: cnv02
released channel: cnv03
released channel: cnv04
released channel: cnv05
released channel: cnv06
released channel: cnv07
released channel: cnv08
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 05/05/2013 04:54:54
RMAN-03015: error occurred in stored script Memory Script

RMAN-03009: failure of backup command on d01 channel at 05/05/2013 04:54:54
ORA-19505: failed to identify file "/u01/app/oracle/product/11.2.0/db_1/dbs/orapwTEST1"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3 

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.