ORA-16019: cannot use LOG_ARCHIVE_DEST_1 with LOG_ARCHIVE_DEST or LOG_ARCHIVE_DU

ORA-16019: cannot use LOG_ARCHIVE_DEST_1 with LOG_ARCHIVE_DEST or LOG_ARCHIVE_DUPLEX_DEST。主要是由于log_archive_dest与log_archive_dest_n这两个参数是不能够同时设置值、共存的。

 

解决办法：

 

SQL> create pfile='d:\init.ora' from spfile;

 文件已创建。

然后用文本编辑器打开init.ora，去掉、注释掉log_archive_dest这行设置，启动db.

SQL> create spfile from pfile='d:\init.ora'
File created.
SQL> startup;
ORACLE instance started.

Total System Global Area  570425344 bytes
Fixed Size                  2067336 bytes
Variable Size             176161912 bytes
Database Buffers          385875968 bytes
Redo Buffers                6320128 bytes
Database mounted.
Database opened.