Ora-16038:log 2 sequence# cannot be archived

When you started the test database, you found that log Group 2 was not properly archived.

Ora-16038:log 2 sequence# cannot is 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
The Db_recovery_file_dest directory is found to be the default 2G, but the problem remains unresolved after the catalog is emptied or enlarged, and then the following SQL statement is executed, Sql>alter database clear unarchived logfile Group 2;
Sql>alter database open; The database can be opened correctly, problem solved.