RMAN Active Duplicate for Standby - ORA-19595 On Clone Of SPFILE To Disk Group That Does Not Exist Anywhere (Doc ID 1930486.1)

Last updated on AUGUST 02, 2020

Applies to:

Goal

Duplicate the Target database to Standby from the active database using the script below.  

The script is known to work on many other databases but is failing here when looking for
the init.ora at the target database for parameters.  

This is because RMAN reads the parameter files in a specific order.  
The precedence is to read the init.ora if exist, if not read the spfile.  

In this case there is an spfile used to start the target database in $ORACLE_HOME/dbs
but there is also a pfile "init<standby_sid>.ora" in the same directory.

connect auxiliary sys/<password>@<standby_service>
connect target sys/<password>@<primary_service>

RMAN> run {
2> DUPLICATE TARGET DATABASE FOR STANDBY FROM ACTIVE DATABASE
3> SPFILE
4> PARAMETER_VALUE_CONVERT '<primary_parameter>','<standby_parameter>'
5> SET db_unique_name='<standby_db_unique_name>'
6> SET DB_CREATE_FILE_DEST='+<standby_diskgroup>'
7> SET DB_RECOVERY_FILE_DEST='+<standby_fra_diskgroup>'
8> SET CONTROL_FILES='+<standby_diskgroup>','+<standby_fra_diskgroup>'
9> SET DB_RECOVERY_FILE_DEST_SIZE='40G'
10> SET LOG_ARCHIVE_CONFIG='DG_CONFIG=(<primary_db_unique_name>,<standby_db_unique_name>)'
11> SET LOG_ARCHIVE_DEST_2='SERVICE=<primary_service> SYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=<primary_db_unique_name>'
12> SET FAL_SERVER='<primary_service>' COMMENT 'Is primary'
13> SET STANDBY_FILE_MANAGEMENT='AUTO'
14> SET DB_FILE_NAME_CONVERT='+<primary_diskgroup>','+<standby_diskgroup>'
15> SET LOG_FILE_NAME_CONVERT='+<primary_diskgroup>','+<standby_diskgroup>'
16> NOFILENAMECHECK;
17> }
...
...
RMAN-03002: failure of Duplicate Db command at 06/05/2014 09:05:36
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 06/05/2014 09:05:36
ORA-19505: failed to identify file "+<diskgroup>/<primary_db_unique_name>/spfile<primary_sid>.ora"
ORA-15001: diskgroup "<groupname>" does not exist or is not mounted
ORA-15001: diskgroup "<groupname>" does not exist or is not mounted

Diagnose:
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.

Solution

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