Raphael did not paint the Sistine Chapel ceiling. That was Michelangelo, using fresco (pigments on wet plaster)—a rapid technique as plaster dries quickly.
Raphael’s Sistine Madonna is an oil on canvas painting (not tempera as sometimes misstated): pigments mixed with drying oils, allowing more detailed, refined work than fresco. The work resides in Dresden’s Gemäldegalerie Alte Meister.