【求助：Dataguard创建失败】请各位大侠帮忙

wxc2011

在创建DataGuard时，在启动数据库时报如下错误
SQL> create spfile from pfile='/u01/oracle/product/10.2.0/db_1/dbs/initsz.ora';

File created.

SQL> startup
ORA-16025: parameter LOG_ARCHIVE_DEST_2 contains repeated or conflicting attributes
SQL>
如下是我的主数据库的init初使脚本！
sz.__db_cache_size=130023424
sz.__java_pool_size=4194304
sz.__large_pool_size=4194304
sz.__shared_pool_size=62914560
sz.__streams_pool_size=0
*.audit_file_dest='/u01/admin/sz/adump'
*.background_dump_dest='/u01/admin/sz/bdump'
*.compatible='10.2.0.1.0'
*.control_files='/u01/oradata/sz/control01.ctl','/u01/oradata/sz/control02.ctl','/u01/oradata/sz/control03.ctl'#Restore Controlfile
*.core_dump_dest='/u01/admin/sz/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='sz'
*.db_recovery_file_dest='/u01/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.dispatchers='(PROTOCOL=TCP) (SERVICE=szXDB)'
*.job_queue_processes=10
*.open_cursors=300
*.pga_aggregate_target=67108864
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=203423744
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/u01/admin/sz/udump'


*.DB_UNIQUE_NAME='sz'
*.log_archive_config='DG_CONFIG=(sz,bj)'
*.log_archive_dest_1='location=/u01/wxc/ VALID_FOR=(ALL_LOGFILES,ALL_ROLES)' DB_UNIQUE_NAME='sz'
*.LOG_ARCHIVE_DEST_2='SERVICE = bj arch ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=bj'
*.LOG_ARCHIVE_DEST_STATE_1 = ENABLE
*.LOG_ARCHIVE_DEST_STATE_2 = ENABLE
*.remote_login_passwordfile='EXCLUSIVE'

*.FAL_SERVER = sz
*.FAL_CLIENT = bj
*.STANDBY_FILE_MANAGEMENT = AUTO
~

备数据库有脚本如下：
sz.__db_cache_size=130023424
sz.__java_pool_size=4194304
sz.__large_pool_size=4194304
sz.__shared_pool_size=62914560
sz.__streams_pool_size=0
*.audit_file_dest='/u01/admin/sz/adump'
*.background_dump_dest='/u01/admin/sz/bdump'
*.compatible='10.2.0.1.0'
*.control_files='/u01/oradata/sz/control01.ctl','/u01/oradata/sz/control02.ctl','/u01/oradata/sz/control03.ctl'#Restore Controlfile
*.core_dump_dest='/u01/admin/sz/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='sz'
*.db_recovery_file_dest='/u01/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.dispatchers='(PROTOCOL=TCP) (SERVICE=szXDB)'
*.job_queue_processes=10
*.open_cursors=300
*.pga_aggregate_target=67108864
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=203423744
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/u01/admin/sz/udump'

*.DB_UNIQUE_NAME = 'bj'
*.log_archive_config = 'DG_CONFIG = (sz,bj)'
*.LOG_ARCHIVE_DEST_1 = 'location=/u01/wxc/ VALID_FOR=(ALL_LOGFILES,ALL_ROLES)' DB_UNIQUE_NAME='bj'
*.LOG_ARCHIVE_DEST_2 = 'SERVICE = sz ARCH ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME = sz'
*.LOG_ARCHIVE_DEST_STATE_1 = ENABLE
*.LOG_ARCHIVE_DEST_STATE_2 = ENABLE
*.remote_login_passwordfile = 'EXCLUSIVE'


*.FAL_SERVER = bj
*.FAL_CLIENT = sz
*.STANDBY_FILE_MANAGEMENT=AUTO

renxiao2003

日志文件出错了啊。

flutter

LOG_ARCHIVE_DEST_2设置有问题，包含重复或冲突的选项。看你的日志设置，你这DG是双向的吗，DG有这功能吗，我还真不清楚呢

DB_UNIQUE_NAME应该是一致的吧