ORA-19809：limit exceeded for recovery files

测试机器启动报错：

SQL> startup
ORACLE instance started.

Total System Global Area 4294967296 bytes
Fixed Size                  2026256 bytes
Variable Size             855639280 bytes
Database Buffers         3422552064 bytes
Redo Buffers               14749696 bytes
Database mounted.
ORA-16038: log 3 sequence# 55 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 3 thread 1:
'/u01/app/oracle/product/10.2.0/oradata/orcl/redo03.log'

查看告警日志：

Errors in file /u01/app/oracle/product/10.2.0/db_1/admin/orcl/udump/orcl_ora_15880.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 2147483648 bytes is 99.67% used, and has 7127040 remaining bytes available.

flashrecovery满了，增大闪回区域，更改archivelog位置

SQL> show parameter db_recovery_file_dest;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      /u01/app/oracle/product/10.2.0
                                                 /db_1/flash_recovery_area
db_recovery_file_dest_size           big integer 2G

SQL> ALTER SYSTEM SET  db_recovery_file_dest_size=4G scope=both;

SQL> alter system set db_recovery_file_dest="/u01/app/oracle/backup/log_archive_dest";

shutdown immediate

startup 

OK