RMAN Duplicate for Standby From Active Database fails with ORA-02095 RMAN-11003

(Doc ID 1924740.1)

Last updated on SEPTEMBER 05, 2017

Applies to:

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

Symptoms

RMAN duplicate fails with following error:

 

executing Memory Script

sql statement: alter system set dg_broker_config_file1 = ''+DATAC1/MYDB/BROKER/dr1MYDB.da t'' comment= '''' scope=spfile
sql statement: alter system set dg_broker_config_file2 = ''+DATAC1/MYDB/BROKER/dr2MYDB.da t'' comment= '''' scope=spfile
sql statement: alter system set log_archive_format = ''MYDB_arch_%t_%s_%r.arc'', ''MYDB _arch_%t_%s_%r.arc'', ''MYDB_arch_%t_%s_%r.arc'' comment= '''' scope=spfile
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 09/09/2014 07:06:36
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of sql command on clone_default channel at 09/09/2014 07:06:36
RMAN-11003: failure during parse/execution of SQL statement: alter system set log_archive_form at = 'MYDB_arch_%t_%s_%r.arc', 'MYDB_arch_%t_%s_%r.arc', 'MYDB_arch_%t_%s_%r.arc' com ment= '' scope=spfile
ORA-02095: specified initialization parameter cannot be modified



Cause

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