ORA-16047: DGID mismatch between destination setting and target database

Question

----------主库配置

orcl.__data_transfer_cache_size=0
orcl.__db_cache_size=1258291200
orcl.__inmemory_ext_roarea=0
orcl.__inmemory_ext_rwarea=0
orcl.__java_pool_size=0
orcl.__large_pool_size=16777216
orcl.__oracle_base='/oracleDB/app/oracle'#ORACLE_BASE set from environment
orcl.__pga_aggregate_target=603979776
orcl.__sga_target=1795162112
orcl.__shared_io_pool_size=100663296
orcl.__shared_pool_size=402653184
orcl.__streams_pool_size=0
orcl.__unified_pga_pool_size=0
*.audit_file_dest='/oracleDB/app/oracle/admin/orcl/adump'
*.audit_trail='DB'
*.compatible='19.0.0'
*.control_files='/oracleDB/app/oracle/oradata/ORCL/control01.ctl','/oracleDB/app/oracle/fast_recovery_area/ORCL/control02.ctl'
*.db_block_size=8192
*.db_name='orcl'
*.db_recovery_file_dest_size=8657043456
*.db_recovery_file_dest='/oracleDB/app/oracle/fast_recovery_area'
*.db_unique_name='orcl_s'
*.diagnostic_dest='/oracleDB/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'
*.fal_server='orcl_p'
*.fal_client='orcl_s'
*.local_listener='LISTENER_ORCL'
*.log_archive_config='DG_CONFIG=(orcl_p,orcl_s)'
*.log_archive_dest_1='location=/oracleDB/archive_s valid_for=(all_logfiles,all_roles) db_unique_name=orcl_s'
*.log_archive_dest_2='service=orcl_p affirm sync valid_for=(online_logfiles,primary_role) db_unique_name=orcl_p'
*.log_archive_dest_state_1='enable'
*.log_archive_dest_state_2='enable'
*.log_archive_format='%t_%s_%r.dbf'
*.nls_language='AMERICAN'
*.nls_territory='AMERICA'
*.open_cursors=300
*.pga_aggregate_target=594542592
*.processes=320
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=1795162112
*.standby_file_management='auto'
*.undo_tablespace='UNDOTBS1'

----------从库配置

orcl.__data_transfer_cache_size=0
orcl.__db_cache_size=1174405120
orcl.__inmemory_ext_roarea=0
orcl.__inmemory_ext_rwarea=0
orcl.__java_pool_size=0
orcl.__large_pool_size=16777216
orcl.__oracle_base='/oracleDB/app/oracle'#ORACLE_BASE set from environment
orcl.__pga_aggregate_target=603979776
orcl.__sga_target=1795162112
orcl.__shared_io_pool_size=100663296
orcl.__shared_pool_size=452984832
orcl.__streams_pool_size=33554432
orcl.__unified_pga_pool_size=0
*.audit_file_dest='/oracleDB/app/oracle/admin/orcl/adump'
*.audit_trail='db'
*.compatible='19.0.0'
*.control_files='/oracleDB/app/oracle/oradata/ORCL/control01.ctl','/oracleDB/app/oracle/fast_recovery_area/ORCL/control02.ctl'
*.db_block_size=8192
*.db_name='orcl'
*.db_recovery_file_dest='/oracleDB/app/oracle/fast_recovery_area'
*.db_recovery_file_dest_size=8256m
*.db_unique_name='orcl_p'
*.diagnostic_dest='/oracleDB/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'
*.fal_server='orcl_s'
*.fal_client='orcl_p'
*.local_listener='LISTENER_ORCL'
*.log_archive_config='DG_CONFIG=(orcl_p,orcl_s)'
*.log_archive_dest_1='location=/oracleDB/archive valid_for=(all_logfiles,all_roles) db_unique_name=orcl_p'
*.log_archive_dest_2='service=orcl_s affirm sync valid_for=(online_logfiles,primary_role) db_unique_name=orcl_s'
*.log_archive_dest_state_1='enable'
*.log_archive_dest_state_2='enable'
*.log_archive_format='%t_%s_%r.dbf'
*.nls_language='AMERICAN'
*.nls_territory='AMERICA'
*.open_cursors=300
*.pga_aggregate_target=567m
*.processes=320
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=1700m
*.standby_file_management='auto'
*.undo_tablespace='UNDOTBS1'

百度了很久 都没找到解决方法，请大神们帮忙看看
ORA-16047: DGID mismatch between destination setting and target database

Answer 1

*.log_archive_dest_2='service=orcl_p 主库这里错误