Moving User Activity to the Live Standby

This procedure does the following:

  • Prepares the live standby for user activity.

  • Ensures that all transactions from the primary system are applied to the live standby.

  • Activates Oracle GoldenGate to capture transactional changes on the live standby.

  • Moves users to the live standby system.

Perform these steps on the live standby system

To move users to the live standby

  1. Issue the STATUS REPLICAT command until it returns "At EOF (end of file)" to confirm that Replicat applied all of the data from the trail to the database.
    STATUS REPLICAT rep_1
  2. Stop the Replicat process.
    STOP REPLICAT rep_1
  3. Run the script that grants insert, update, and delete permissions to the users of the business applications.
  4. Run the script that enables triggers and cascade delete constraints.
  5. Run the scripts that fail over the application server, start applications, and copy essential files that are not part of the replication environment.
  6. Start the primary Extract process on the live standby.
    START EXTRACT ext_2
  7. Move the users to the standby system and let them start working.

    Note:

    Do not start the data pump group on the standby. The user transactions must accumulate there until just before user activity is moved back to the primary system.