DG部署中的问题

显示全部楼层 · 2011-11-1 16:24:04

各位大侠好，我在自己的一台linux虚拟机中搭建DG，一台机器既做primary，也做standby。我在主库的pfile中添加了如下的内容，再重启的时候就抱ORA-16187: LOG_ARCHIVE_CONFIG contains duplicate, conflicting or invalid attributes得错误。
*.db_unique_name='sckprimary'
*.log_archive_dest_2='SERVICE=sckstandby ARCH VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) db_unique_name=sckstandby'
*.LOG_ARCHIVE_DEST_STATE_2=DEFER
*.FAL_SERVER=standby
*.FAL_CLIENT=primary
*.DB_FILE_NAME_CONVERT='/u01/app/oracle/oradata/sck','/u01/app/oracle/oradata/standby'
*.LOG_FILE_NAME_CONVERT='/u01/app/oracle/oradata/sck','/u01/app/oracle/oradata/standby'
*.STANDBY_FILE_MANAGEMENT=AUTO
*.log_archive_config='DB_CONFIG=(sckprimary,sckstandby)'
报错信息说LOG_ARCHIVE_CONFIG配置的有冲突，但是我实在没看出来哪里有问题，请大家帮我分析一下，谢谢。
如下为所有pfile信息。
sck.__db_cache_size=176160768
sck.__java_pool_size=4194304
sck.__large_pool_size=4194304
sck.__shared_pool_size=96468992
sck.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/sck/adump'
*.background_dump_dest='/u01/app/oracle/admin/sck/bdump'
*.compatible='10.2.0.1.0'
*.control_files='/u01/app/oracle/oradata/sck/control01.ctl','/u01/app/oracle/oradata/sck/control02.ctl','/u01/app/oracle/oradata/sck/control03.ctl'
*.core_dump_dest='/u01/app/oracle/admin/sck/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='sck'
*.db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.dispatchers='(PROTOCOL=TCP) (SERVICE=sckXDB)'
*.job_queue_processes=10
*.open_cursors=300
*.pga_aggregate_target=94371840
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=285212672
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/u01/app/oracle/admin/sck/udump'
*.db_unique_name='sckprimary'
*.log_archive_dest_2='SERVICE=sckstandby ARCH VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) db_unique_name=sckstandby'
*.LOG_ARCHIVE_DEST_STATE_2=DEFER
*.FAL_SERVER=standby
*.FAL_CLIENT=primary
*.DB_FILE_NAME_CONVERT='/u01/app/oracle/oradata/sck','/u01/app/oracle/oradata/standby'
*.LOG_FILE_NAME_CONVERT='/u01/app/oracle/oradata/sck','/u01/app/oracle/oradata/standby'
*.STANDBY_FILE_MANAGEMENT=AUTO
*.log_archive_config='DB_CONFIG=(sckprimary,sckstandby)'

千问 · 2011-11-1 16:24:04

不懂你这样搞有什么意义
你的 standby的配置贴出来

千问 · 2011-11-1 16:24:04

nannan5000 发表于 2011-10-2 15:14
不懂你这样搞有什么意义
你的 standby的配置贴出来
哥们，你好。我是一个oracle的新手。如下为我的standby的pfile配置。谢谢。
sck.__db_cache_size=176160768
sck.__java_pool_size=4194304
sck.__large_pool_size=4194304
sck.__shared_pool_size=96468992
sck.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/standby/adump'
*.background_dump_dest='/u01/app/oracle/admin/standby/bdump'
*.compatible='10.2.0.1.0'
*.control_files='/u01/app/oracle/oradata/standby/standby01.ctl','/u01/app/oracle/oradata/standby/standby02.ctl','/u01/app/oracle/oradata/standby/standby03.ct
l'
*.core_dump_dest='/u01/app/oracle/admin/standby/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='sck'
*.db_unique_name='sckstandby'
*.db_recovery_file_dest='/u01/app/oracle/flash_recovery_area/standby'
*.db_recovery_file_dest_size=2147483648
*.dispatchers='(PROTOCOL=TCP) (SERVICE=sckXDB)'
*.job_queue_processes=10
*.open_cursors=300
*.pga_aggregate_target=94371840
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=285212672
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/u01/app/oracle/admin/standby/udump'
*.log_archive_dest_2='SERVICE=sckprimary ARCH VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) db_unique_name=sckprimary'
*.LOG_ARCHIVE_DEST_STATE_2=ENABLE
*.FAL_SERVER=sckprimary
*.FAL_CLIENT=sckstandby
*.LOG_FILE_NAME_CONVERT='/u01/app/oracle/oradata/sck','/u01/app/oracle/oradata/standby','/u01/app/oracle/oradata/standby','/u01/app/oracle/oradata/sck'
*.DB_FILE_NAME_CONVERT='/u01/app/oracle/oradata/sck','/u01/app/oracle/oradata/standby','/u01/app/oracle/oradata/standby','/u01/app/oracle/oradata/sck'
*.STANDBY_FILE_MANAGEMENT=AUTO
*.log_archive_dest_1='location=/u01/app/oracle/flash_recovery_area/standby'

千问 · 2011-11-1 16:24:04

好几个地方没配好，三思笔记还是很完整的，你自己改改吧，或者参考官方文档

千问 · 2011-11-1 16:24:04

Impostor 发表于 2011-10-2 16:22
好几个地方没配好，三思笔记还是很完整的，你自己改改吧，或者参考官方文档
哥们能否帮我指点一下，哪里配置的有问题呢?谢谢。

千问 · 2011-11-1 16:24:04

lz 是 dg_config 不是db_config!

千问 · 2011-11-1 16:24:04

而且你的备库pfile有两个db_uniqname

千问 · 2011-11-1 16:24:04

nannan5000 发表于 2011-10-2 18:27
lz 是 dg_config 不是db_config!
谢谢，哥们。我自己太粗心了。