Rauru (Ocarina of Time)
Rauru is one of the Six Sages in Ocarina of Time and the true form of Kaepora Gaebora. After Link wakes up from his seven year slumber he will encounter Rauru in the Sacred Realm. Rauru will proceed to explain why Link was trapped in there for seven years, and also tell him that while he slept Ganondorf had free access to the Sacred Realm and consequently to the Triforce. He then gained the power to take over Hyrule. Finally, he reveals Link's destiny: to become the Hero of Time. Then he will tell Link to find the other Sages and add their power to his own, giving him the Light Medallion.
Later in the game it is Rauru who tells Link to return to the Temple of Time after awakening all of the Sage. Also, at the end Rauru helps seal Ganon away in the Dark Realm.
Other Appearances
Wind Waker
Even though Rauru doesn't make an appearance physically in-game, a stained glass window of him can be seen in Hyrule Castle, along with the Stained Glass of the other Sages.
Majora's Mask
If Kaepora Gaebora from Majora's Mask is the same one from Ocarina of Time, then we can add it to his appearances.
Other
Rauru built the temple of time before the great war.