I examined my alert log and noticed that my archive process is failing with the
ARC0: Failed to archive log message.
Question: Can someone suggest how this
alert log error can be corrected?
ARC0: Beginning to archive log# 2 seq# 313533
ARC0: Failed to archive log# 2 seq# 313533
Thur May 07 07:42:57 2015
ARC1: Failed to archive log# 3 seq# 313532
Thur May 07 07:42:57 2015
ARC1: Beginning to archive log# 2 seq# 313533
ARC1: Failed to archive log# 2 seq# 313533
Thur May 07 07:43:31 2015
ARC0: Beginning to archive log# 3 seq# 313532
ARC0: Failed to archive log# 3 seq# 313532
ARC0: Beginning to archive log# 2 seq# 313533
ARC0: Failed to archive log# 2 seq# 313533
Answer:
This alert log message "failed to archive log" is not an "error", it is just an informational message noting that there was a delay when archiving your redo log, usually due to a disk I/O slowdown.
You have not lost any
redo data, but this error does indicate that you have a redo-related bottleneck, usually disk I/O.
- Make sure that your redo is on a separate disk spindle
- If necessary, move your redo to faster disk (SSD) devices.
It seems like your logfiles are not keeping up write activity and you should either
- move your logfiles to speedy media to avoid write contention, or
- try adding another log group members or resize redo log files with bigger number.