Am I bound to fulfill the oath I took to refrain from playing sports, given that I was between sleep and wakefulness at the time of the oath?

If an oath is uttered intentionally and consciously, expiation is obligatory upon breaking it by doing what one swore to abandon. Breaking the oath is permissible without dislike if the sport you will practice is permissible.