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