Does this sounds as a RAC topic ......yes it was .....but now in Oracle 10g it is possible to use the Oracle Clustersoftware to protect single instance databases .
OTN has a nice sample code on how to's for a cold failover for a single db instance .
It has sample code + witepaper to get you going .The best part is that it covers couple of case studies also .