What should a worshiper who has forgotten a pillar of prayer do?
If he/she remembered the forgotten pillar before offering it in the following Rakah (unit of prayer), then he/she should offer it, and continue the prayer, then offer Sujood As-Sahw (Prostration of forgetfulness) at the end of it. But, if he/she remembered that forgotten pillar after having offered it in the following Rakah, then he/she should offer a new Rakah in its (the one in which he forgot a pillar) place, and offer Sujood As-Sahw.
Should missed Sunnah prayer be made up?
Making up missed voluntary acts of worship is from Sunnah.
Is it permissible to repeat the Istikhara (seeking guidance) prayer, and is it a condition that one should sleep after offering it?
All perfect praise be to Allah,The Lord of The Worlds Istikhara is offered once, but it is permissible to repeat it, and sleeping after offering it is not a condition for its validity. And Allah Knows Best.
What should one who forgot to offer the second Sajda during congregational prayer, and remembered it before the end of the prayer do?
All perfect praise be to Allah, The Lord of The Worlds. Whoever forgets a pillar of prayer while in congregation must follow the lead of the Imam, and after the latter offers Tasleem, he should offer one Rakah, then perform Sujood As-Sahw (prostration of forgetfulness). And Allah Knows Best.