RMAN Duplicate Command fails with ORA-02778

SIS

Hi,

I am trying to configure physical standby database without data guard. Below are my environment details.

OS: Windows 2019 Server (Primary and Standby Machines)

Oracle Database: Oracle 19c

Primary Database Name: primary

Standby Database: standby1

After doing all the necessary steps on primary database and standby database, when I try to run RMAN DUPLICATE TARGET DATABASE command (ref: "command"), I am getting the following error (ref: "error").

command:

run {
  allocate channel prmy1 type disk;
	allocate channel prmy2 type disk;
	allocate channel prmy3 type disk;
	allocate channel prmy4 type disk;
	allocate auxiliary channel stby type disk;
	duplicate target database for standby from active database
	spfile
		parameter_value_convert 'primary','standby1'
		set db_name='primary'
		set db_unique_name='standby1'
		set db_file_name_convert='\primary\','\standby1\'
		set log_file_name_convert='\primary\','\standby1\'
		set control_files='C:\app\administrator\oradata\standby1\standby1.ctl'
		set log_archive_max_processes='5'
		set fal_client='standby1'
		set fal_server='primary'
		set standby_file_management='AUTO'
		set log_archive_config='dg_config=(primary,standby1)'
		set log_archive_dest_2='service=primary ASYNC valid_for=(ONLINE_LOGFILE,PRIMARY_ROLE) db_unique_name=primary'
  ;
  }

error:

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at dd/mm/yyyy hh24:mi:ss
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 dd/mm/yyyy hh24:mi:ss
RMAN-11003: failure during parse/execution of SQL statement: alter system set core_dump_dest = 'C:\app\administrator\diag\rdbms\standby1\primary\cdump' comment= '' scope=spfile
ORA-32017: failure in updating SPFILE
ORA-02778: Name given for the log directory is invalid

Kindly suggest, if someone had faced the similar error or if you can suggest something.

Thanks

SIS

SIS

Hi All,

I managed to resolve it by adding the "set core_dump_dest" in the RMAN script itself.

Thanks

SIS

Shaik Ahmed Ali Bajubair

did you check, is the directory is created ??