ORA-16019搭建DG设置归档线程参数报错

#操作描述：搭建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_archive

log_archive_dest                     string  /u01/app/oracle/oradata/arch
log_archive_dest_1                   string

 

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

 

#因此需要重写参数文件：

create pfile from spfile;

cd $ORACLE_HOME/dbs

vi 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 list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /u01/app/oracle/oradata/arch #归档路径

Oldest online log sequence     207
Next log sequence to archive   209
Current 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