#操作描述：搭建DG，主库修改参数log_archive_dest_1线程路径报错

ORA-16019: cannot use LOG_ARCHIVE_DEST_1 with LOG_ARCHIVE_DEST or LOG_ARCHIVE_DUPLEX_DEST

 

#原因：参数

#数据库当前使用的归档参数为log_archive_dest ，此参数与dest_1/2/3---参数不兼容

 

show parameter log_archivelog_archive_dest                     string  /u01/app/oracle/oradata/archlog_archive_dest_1                   string

 

 #解决：需要重启库！！！

#因此需要重写参数文件：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           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