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 OCTOBER 02, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

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 "initsand.ora" in the same directory.

 


connect auxiliary sys/xxxxxx@orasby1
connect target sys/xxxxxx@orasand

RMAN> run {
2> DUPLICATE TARGET DATABASE FOR STANDBY FROM ACTIVE DATABASE
3> SPFILE
4> PARAMETER_VALUE_CONVERT 'ORASAND','ORASBY1'
5> SET db_unique_name='ORASBY1'
6> SET DB_CREATE_FILE_DEST='+DATADR'
7> SET DB_RECOVERY_FILE_DEST='+FRADR'
8> SET CONTROL_FILES='+DATADR','+FRADR'
9> SET DB_RECOVERY_FILE_DEST_SIZE='40G'
10> SET LOG_ARCHIVE_CONFIG='DG_CONFIG=(orasand,orasby1)'
11> SET LOG_ARCHIVE_DEST_2='SERVICE=ORASAND SYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=ORASAND'
12> SET FAL_SERVER='ORASAND' COMMENT 'Is primary'
13> SET STANDBY_FILE_MANAGEMENT='AUTO'
14> SET DB_FILE_NAME_CONVERT='+DATAT','+DATADR'
15> SET LOG_FILE_NAME_CONVERT='+DATAT','+DATADR'
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 "+DATA/orasand/spfileorasand.ora"
ORA-15001: diskgroup "DATA" does not exist or is not mounted
ORA-15001: diskgroup "DATA" does not exist or is not mounted


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

 

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms