Besides Life, what other Mysteries would work well for a Buffing/Support Oracle who just stands in the back and casts spells? I'm not opposed to a little ranged debuffing, but I'd like to avoid actual (gasp) violence, leaving that to my minions, err, fellow party members.
Also, the character in question is a gnome with the haunted curse, if that helps.
I like the Time mystery.
Spoiler:
Time Sight (Su): You can peer through the mists of time to see things as they truly are, as if using the true seeing spell. At 15th level, this functions like moment of prescience. At 18th level, this functions like foresight. You can use this ability for a number of minutes per day equal to your oracle level, but these minutes do not need to be consecutive. You must be at least 11th level to select this revelation.
True Seeing is usually costly to cast, and you only need it some of the time, so this is a great ability to call forth. The later options are not as good, but I don't think you're forced to use them instead.
Spoiler:
Time Hop (Su): As a move action, you can teleport up to 10 feet per oracle level that you possess per day. This teleportation must be used in 5-foot increments. This movement does not provoke attacks of opportunity. You must have line of sight to your destination to use this ability. You can bring other willing creatures with you, but you must expend an equal amount of distance for each creature brought. You must be at least 7th level to select this revelation.
Very tactically useful. It's Su, so you can use it grappled, it doesn't provoke AoOs, and you can take others with you if needed.
Spoiler:
Temporal Celerity (Su): Whenever you roll for initiative, you can roll twice and take either result. At 7th level, you can always act in the surprise round, but if you fail to notice the ambush, you act last, regardless of your initiative result (you act in the normal order in following rounds). At 11th level, you can roll for initiative three times and take any one of the results.
Every caster likes to go first.
Spoiler:
Speed or Slow Time (Sp): As a standard action, you can speed up or slow down time, as either the haste or slow spell. You can use this ability once per day, plus one additional time per day at 12th level and 17th level. You must be at least 7th level before selecting this revelation.
Not the greatest thing, but still helpful. At late levels, might be worth getting Quicken SLA feat for it.
Spoiler:
Knowledge of the Ages (Su): You can search through time to recall some bit of forgotten lore or information. You can retry any Knowledge skill check you have made within the past minute, gaining an insight bonus on the check equal to your Charisma modifier. You can use this ability a number times per day equal to your Charisma modifier.
Great for identifying enemies.
Spoiler:
Erase from Time (Su): As a melee touch attack, you can temporarily remove a creature from time altogether. The target creature must make a Fortitude save or vanish completely for a number of rounds equal to 1/2 your oracle level (minimum 1 round). No magic or divinations can detect the creature during this time, as it exists outside of time and space—in effect, the creature ceases to exist for the duration of this ability. At the end of the duration, the creature reappears unharmed in the space it last occupied (or the nearest possible space, if the original space is now occupied). You can use this ability once per day, plus one additional time per day at 11th level.
This is useful to get someone out of harm's way or get rid of a dmonated PC and the like, along with using it on enemies.