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;