My Oracle Support Banner

RMAN Duplicate for Standby From Active Database fails with ORA-02095 RMAN-11003 (Doc ID 1924740.1)

Last updated on FEBRUARY 03, 2019

Applies to:

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


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


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

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