ora-16038 ora-19502 ora-00312

ora-16038 ora-19502 ora-00312

ORA-16038: log 4 sequence# 10840 cannot be archived,ORA-19502: write error on file "", blockno (blocksize=,ORA-00312: online log 4 thread 1: '/ora01/oradata/pbm1/redo/redo04a',ORA-16014: log 4 seque

Just check the space in your archive log destination.

Make sure that it is not full.


shut immediate
startup mount
recover database until cancel;
alter database open resetlogs;


1. Increase the ARCHIVE DESTINATION size
2. Take backup of the archivelogs to different location.
3. Change archivelogs destination to some other mountpoint.
4. Delete archivelogs to make more space. ( should be the last option) and in case of standby database make sure those logs are already applied to standby.