Winds are set to reverse and blow cooler air back into the Bay Area, putting a temporary hold on a spell of warm weather.