Stage one: after the relevant Mina rites and hair removal, the pilgrim leaves most ihram restrictions, but marital intimacy remains restricted.
Stage two: fulfillment of Tawaf al-Ziyarah's relevant legal requirement leads to the lifting of that remaining restriction.
Whether a sacrifice is required differs by Hajj type, but the obligatory status of Tawaf al-Ziyarah does not depend on the ifrad sacrifice being voluntary.