ORA-16014: not archived, no available destinations

问题现象：

同步数据失败，查看alert_orcl.log显示如下错误

ORACLE Instance orcl - Archival Error
ORA-16014: log 4 sequence# 10 not archived, no available destinations
ORA-00312: online log 4 thread 1: '/opt/oracle/oradata/orcl/standby_log04.log'

 

 

问题原因：

参数log_archive_dest_1路径填写错误，或引号不配对之类

解决方法：

确认archive_dest_1路径正确，且日志文件处于该目录下

SQL> show parameter archive_dest_1

NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_1		 string	 location=/opt/oracle/oradata/orcl

如果不正确可按如下方式修改，然后重启数据库

SQL> alter system SET log_archive_dest_1='location=/opt/oracle/oradata/orcl' scope=spfile;

System altered.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 1553305600 bytes
Fixed Size		    2253544 bytes
Variable Size		  973081880 bytes
Database Buffers	  570425344 bytes
Redo Buffers		    7544832 bytes
Database mounted.
Database opened.
SQL>