Oracle Failsafe

Today i got an opportunity to work on Oracle FailSafe... The concept wise i looked it as some what similar to RAC that is virtual IP, clusterware installation, primary and seconday configuration and switching to secondary node for failover etc..

I was initially scared and motivated myself to take it as a challenge and an opportunity to learn something new today on Oracle.

The Oracle FailSafe was so simple mostly uncheck or tick the checkbox, click option button etc.. It is very user friendly and simple but a good fun learning experience.

Thought of sharing one of the task of shutdown and database recovery task with you..

1. Before shutdown of the database, stop the monitoring of the oracle Failsafe.
a. On the failsafe server, Goto start, then programs and Oracle - OfsHome33
b. On the Oracle File Safe Manager, select the Clusters then Server which you need to manage and then expand Cluster Resources
c. Select the database, on the right side, click the policies tab
d. Under Restart Policy, select the option "Do not restart the resources on the current node"
e. And under Failover Policy, uncheck the box for "If the resource fails and is not restarted, failover the group.

Thats it...then all ususal oracle database steps, execute your shutdown command connected to the database using sqlplus.

And recover the database from your backup. Once finished with the database side, donot forget to undo the changes on the Oracle Failsafe.

To enable Oracle Failsafe for the database,

Under Restart Policy as specified above, now select the option, "Attempt to restart the resource on the current node" with your configuration of no of attempts with the seconds.

And also check the box for "If the resource fails and is not restarted, fail over the group".

Done...