How to be able to drink again after having felt sick?

So I’ve been a light drinker for all my life but about 3 months ago I decided to do something dumb and test my limits by drinking A LOT, this caused me to get extremely sick and to live the worst night of my life. Since then I haven’t been able to drink much alcohol without feeling extremely nauseous. I want everything to be back to normal tho so any advice?