ORA-16038: log 2 sequence# 41 cannot be archived

启动测试数据库时，发现日志组2不能正常归档。

ORA-16038: log 2 sequence# 41 cannot be archived

ORA-19809: limit exceeded for recovery files

ORA-00312: online log 2 thread 1: '/opt/oradata/REDO02.LOG'

SQL> show parameter db_recovery_file

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      D:/oracle/product/10.2.0/flash
                                                 _recovery_area
db_recovery_file_dest_size           big integer 2G

发现 db_recovery_file_dest 目录为默认的2G，但是清空或扩大此目录后，问题依然没有解决，随后执行以下SQL语句后，

SQL>alter database clear unarchived logfile group 2;

SQL>alter database open;

可以正常打开了数据库，问题解决。