Home » Server Options » Data Guard » ORA-01103 create physical standby database (Oracle 12.2, Linux)
ORA-01103 create physical standby database [message #676394] Fri, 07 June 2019 06:14 Go to previous message
petar97
Messages: 120
Registered: October 2018
Senior Member

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

 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Enterprise Oracle DB replication - what do you all use?
Next Topic: Archive log shipping
Goto Forum:
  


Current Time: Thu Mar 28 16:34:31 CDT 2024