“Out Of Mind” is episode twenty two and the season finale of season two of Stargate SG-1.
Colonel O’Neill is revived from cryogenic hibernation in the SGC to be informed that the rest of SG-1 and, for that matter, probably everyone he knows, is now dead. This is because he has been in hibernation for years and it is now 2077.
He had returned through the stargate already frozen, and the means of safely reviving him did not exist at the time, so he was left in hibernation until it did. The rest of the team were sent back dead.
Jack has to try and remember what happened in his last mission, with help from the SGC – the new SGC. Especially since Earth is losing its’ war with the Goa’uld. Unfortunately, this means that to some extent this is a flashback episode.