配置DG参数文件initprod1.ora添加部分

#dg add
*.DB_UNIQUE_NAME=prodpri
*.LOG_ARCHIVE_CONFIG='DG_CONFIG=(prodpri,proddg)'
*.LOG_ARCHIVE_DEST_1='LOCATION=/oracle/app/oracle/oradata/prod/arch  valid_for= (all_logfiles,all_roles)  db_unique_name=prodpri'
*.LOG_ARCHIVE_DEST_2='SERVICE=tns_standby LGWR  SYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=proddg'
*.LOG_ARCHIVE_DEST_STATE_1=ENABLE
*.LOG_ARCHIVE_DEST_STATE_2=ENABLE
*.FAL_SERVER=tns_standby
*.FAL_CLIENT=tns_primary
*.STANDBY_FILE_MANAGEMENT=AUTO
*.log_archive_max_processes=30
#*.db_create_file_dest='/oracle/app/oracle/oradata/prod/'
*.db_file_name_convert='/oracle/app/oracle/oradata/prod/','/oracle/app/oracle/oradata/prod/'
*.log_file_name_convert='/oracle/app/oracle/oradata/prod/','/oracle/app/oracle/oradata/prod/'

启动示例总是报错

SQL> startup;
ORA-16024: parameter LOG_ARCHIVE_DEST_1 cannot be parsed

分析了好久,终于发现问题

*.LOG_ARCHIVE_DEST_1这一行的问题

错误配置

valid_for= (all_logfiles,all_roles)

正确配置

valid_for=(all_logfiles,all_roles)

等号后面不能有空格