Act 2:
Mission 1: River
Mission 2: Rapids
Mission 3: Nightmare
Mission 4: Struggle
Mission 5: Assault
Mission 6: Stronghold
Story related achievement BUT it can be missed!
Warning:
"Complete all Acts" requires playing through all Acts consecutively. If you use mission select at any time in your playthrough, you will not get the achievement for completing the game even though you have literally completed all Acts and have the achievements for each Act! You won't unlock the Living Legend achievement either!
The same applies to "Complete Act #". If you use mission select before having finished an entire Act, you will not get the achievement related to completing that particular Act. (Thanks to vithzeral for pointing this out).
When you use mission select, even after you have beat the game, all your weapons will be set to standard settings without any upgrades!
Courtesy of
http://www.xbox360achievements.org/game/vanquish/guide/