Cry about...
Oracle Troubleshooting

---

Thread NNN cannot allocate log, sequence XXX
All online logs need archiving

---

Symptom:

On the database server console the following message is displayed:

Thread NNN cannot allocate log, sequence XXX
All online logs need archiving

Remedy:

This appears to be similar, if not the same, as ‘Cannot allocate log, archival required’.

---

This page represents one page of many pages of notes I made whilst working with Oracle 7 through to 10i. I now no longer work with Oracle databases, but hope that these notes will continue to be of benefit to others.