From the documentation:
"Archived: if a channel can't be reached for 30 days, it is automatically marked as archived. This keeps all the data but stops polling the channel for new information and removes it from autocomplete. If later you learn the channel has come back online, you may manually unarchive it."
I had a problem due to me tightening up security where my hubzilla server could not see itself. I did not notice as I was still getting stream traffic from some of my local users. My first realization was the channels I was connected to on localhost had disappeared from my Connections because they had been archived. Once I realized the problem with security permissions, I fixed it.
The problem is this, other local users (their channels), have all of their local friends(channels) in an archived state. Is this something I can easily unarchive using SQL statement?