Symptom
You are getting below error in your Oracle alert log.
ORA-16038: log 10 sequence# 123456 cannot be archived
Solution
Most probably the caused of this error is due to not enough space in the archive directory.
1. Check the Oracle archive directory.
SQL> archive log list; Database log mode Archive Mode Automatic archival Enabled Archive destination /oracle/SID/oraarch/ Oldest online log sequence 620525 Next log sequence to archive 620540 Current log sequence 620540
2. Check the available space and if necessary delete the old archive logs or increase the space.
df -kh /oracle/SID/oraarch/
Note
Some of the cases is due to incorrect permission and ownership assigned. Please be sure to double check the criteria as well. Please do refer to this article for the similar cases.
