解决归档日志出错问题

SQL> startup
ORACLE instance started.

Total System Global Area  167772160 bytes
Fixed Size                   778212 bytes
Variable Size              70262812 bytes
Database Buffers           96468992 bytes
Redo Buffers                 262144 bytes
Database mounted.
ORA-16038: log 1 sequence# 221 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 1 thread 1: '/u02/oradata/orcl/redo01.log'

解决方法：

      查看归档日志路径

SQL> show parameter archive

如果已指定归档路径 log_archive_dest_1                   string      location=/u03/archive

检查/u03/archive 的权限和可用空间。

如果没有指定归档路径,指定一个归档路径：

[oracle@localhost oracle]$mkdir -p /u03/archive    

[oracle@localhost oracle]$chown -R oracle:oinstall /u03/archive

[oracle@localhost oracle]$chmod -R 775 /u03/archive

SQL>alter system set log_archive_dest_1='location=/u03/archive' scope=spfile;