ORA-16019 build DG SET archive thread parameter error

#操作描述: Build DG, main Library modify parameters log_archive_dest_1 thread path error

ora-16019:cannot use log_archive_dest_1 with Log_archiv e_dest or Log_archive_duplex_dest

#原因: Parameters

#数据库当前使用的归档参数为log_archive_dest, this parameter is incompatible with the DEST_1/2/3---parameter

Show parameter Log_archivelog_archive_dest                     string  /u01/app/oracle/oradata/archlog_archive_dest_1                   String

#解决: Need to restart Library!!!

#因此需要重写参数文件: Create Pfile from SPFILE;CD $ORACLE _home/dbsvi initsid.ora *.log_archive_dest_1= ' location=/u01/app/ Oracle/oradata/arch valid_for= (all_logfiles,all_roles) Db_unique_name=enmo ' #*.log_archive_dest= '/u01/app/oracle/ Oradata/arch ' sql> create SPFile from Pfile; File created. Sql> Startup

#验证参数

Sql> Archive Log listdatabase log mode              archive modeautomatic archival enabledarchive destination/u01/            App/oracle/oradata/arch #归档路径Oldest Online log sequence     207Next log sequence to archive   209Current log sequence< c5/>209         #下一个归档序列号为209 sql> alter system switch logfile; System altered. Sql> select MAX (name) from V$archived_log; MAX (NAME)------------------------------------------------------------------/u01/app/oracle/oradata/arch/1_209_ 960955299.log

ORA-16019 build DG SET archive thread parameter error