Cristiano Ronaldo will serve a five-match ban after Real Madrid failed in a bid to overturn the red card he received in the 3-1 Spanish Super Cup first-leg win over Barcelona.