Database open fails! :ORA-16038,19809, 00312

ORA-16038: log one sequence 3144 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312 online log 1 thread 1 <path to redo log file>


If above error occurs....


You need to do this in RMAN, not SQLPlus. The following commands will delete your archivelogs from your flash recovery area so please make sure that everything is backed up first:

RMAN> connect target sys/*******
RMAN> delete archivelog all;
RMAN> crosscheck archivelog all;

Then try to open the database.