Spotlight raises an Archive Critical Failure alarm when the number of working archive destinations for the database instance is about to fall below the minimum number needed to archive Oracle redo logs successfully. This occurs when:
When you see this alarm, you should make space in the archive log destination by purging – or by backing up to an offline medium – any archived files that are not immediately needed.
Suggestions for improving the archiving process
Archiving is important for safeguarding database changes and for recovery. It is important to protect and back up archive files to some offsite media.
There are three primary goals when archiving redo log files: