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.