Failing over Oracle after a VCS node failure during hot backup

If a node fails during a hot backup, VCS can succeed with a node failover only if you meet VCS requirements for Oracle hot backup.

See About VCS requirements for installing Oracle.

If you do not meet VCS requirements, the agent cannot open the database in the backup mode on the failover node. Therefore, VCS cannot online the Oracle group on the failover node. You may encounter the following Oracle errors in this situation:

    $ ORA-1110 "data file %s: '%s'"

or

    $ ORA-1113 "file %s needs media recovery"

In such cases, you must manually end the hot backup and then fail over Oracle to another node.

To manually fail over Oracle after a node failure that occurs during hot backup

  1. Take the datafiles in the database out of the backup mode.

    Refer to the Oracle documentation for instructions on how to change the state of the database files.

  2. Shut down the database.
  3. Bring the Oracle service group online on the failover node.

    The agent can now start the Oracle instance, mount the database, and open the datafiles.