I just want to know if I cast a spell as a purely divine caster (this case oracle) that only appears on arcane spell lists (achieved through bonus spells or what have you) does the spell come out arcane or divine ( for the purposes of arcane spell failure)?
If you cast a spell as a divine class from a class ability that grants you knowledge of the spell (such as a domain or mystery spell), that spell is divine.
Any spell cast using divine spell slots would be a divine spell, and not subject to arcane spell failure chance. That the spell is typically an arcane spell only and not generally available to divine spell casters is unimportant. However you acquired it on your spell list, it is divine.