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 16, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A 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 = ''+<diskgroup/path>/dr1<db_name>.da t'' comment= '''' scope=spfile
sql statement: alter system set dg_broker_config_file2 = ''+<diskgroup/path>/dr2<db_name>.da t'' comment= '''' scope=spfile
sql statement: alter system set log_archive_format = ''<db_name>_arch_%t_%s_%r.arc'', ''<db_name> _arch_%t_%s_%r.arc'', ''<db_name>_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 = '<db_name>_arch_%t_%s_%r.arc', '<db_name>_arch_%t_%s_%r.arc', '<db__name>_arch_%t_%s_%r.arc' com ment= '' scope=spfile
ORA-02095: specified initialization parameter cannot be modified



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.