I trying to create physical standby db.
I follow this steps https://oracledbwr.com/step-by-step-to-configure-oracle-12c-data-guard-physical-standby/
But after execution script:
{
allocate channel p1 type disk;
allocate channel p2 type disk;
allocate channel p3 type disk;
allocate channel p4 type disk;
allocate auxiliary channel s1 type disk;
duplicate target database for standby from active database nofilenamecheck
spfile
parameter_value_convert 'prodDB','stand'
set db_unique_name='stand'
set db_file_name_convert='/u01/app/oracle/oradata/prodDB/data/',
'/u01/app/oracle/oradata/stand/data/'
set log_file_name_convert='/u01/app/oracle/fast_recovery_area/
prodDB/PRODDB/onlinelog',
'/u01/app/oracle/fast_recovery_area/stand/STAND/onlinelog'
set control_files='/u01/app/oracle/fast_recovery_area/stand/STAND/onlinelog
/standby1.ctl'
set log_archive_max_processes='5'
set fal_client='stand'
set fal_server='prodDB'
set standby_file_management='AUTO'
set log_archive_config='dg_config=(prodDB,stand)'
set compatible='12.2.0.1.0'
set memory_target='500m';
}
I get this errors:
======== RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 06/07/2019 11:41:43
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 06/07/2019
11:41:43
RMAN-11003: failure during parse/execution of SQL statement: alter database
mount standby database
ORA-01103: database name 'PRODDB' in control file is not 'STAND'
I tried to solve this problem with google search,
but I did not succeed
[Updated on: Fri, 07 June 2019 06:16]
Report message to a moderator