Make certain that the primary and live standby systems are ready for immediate user access in the event of a planned switchover or an unplanned source failure. The following components of a high-availability plan should be made easily available for use on each system:

• Scripts that grant insert, update, and delete privileges.

• (Optional) Scripts that enable triggers and cascaded delete constraints on the live standby system. (These may have been disabled during the setup procedures that were outlined in the Oracle GoldenGate installation and configuration document for your database type.)

  Note:

  Scripts to enable triggers and cascaded delete constraints on the live standby system are not required with Oracle. It's controlled by the DEFERREFCONST and SUPRESSTRIGGERS parameter settings.

• Scripts that switch over the application server, start applications, and copy essential files that are not part of the replication environment.

• A failover procedure for moving users to the live standby if the source system fails.