On the live standby system, stop the user applications, but leave the primary Extract running so that it captures any backlogged transaction data.
On the primary system, start Replicat in preparation to receive changes from the live standby system.
START REPLICAT rep_2
On the live standby system, start the data pump to begin moving the data that is stored in the local trail across TCP/IP to the primary system.
START EXTRACT pump_2
On the live standby system, issue the following command for the primary Extract until it returns "At EOF, no more records to process." This indicates that all transactions are now captured.
LAG EXTRACT ext_2
On the live standby system, stop the primary Extract.
STOP EXTRACT ext_2
On the live standby system, issue the following command for the data pump until it returns "At EOF, no more records to process." This indicates that the pump sent all of the captured data to the primary system.
LAG EXTRACT pump_2
On the live standby system, stop the data pump.
STOP EXTRACT pump_2
On the primary system, issue the STATUS REPLICAT command until it returns "At EOF (end of file)." This confirms that Replicat applied all of the data from the trail to the database.
STATUS REPLICAT rep_2
On the primary system, stop Replicat.
STOP REPLICAT rep_2
On the primary system, do the following:
Run the script that grants insert, update, and delete permissions to the users of the business applications.
Run the script that enables triggers and cascade delete constraints.
Run the scripts that switch over the application server, start applications, and copy essential files that are not part of the replication environment.
On the primary system, alter the primary Extract to begin capturing data based on the current timestamp. Otherwise, Extract will spend unnecessary time looking for operations that were already captured and replicated while users were working on the standby system.
ALTER EXTRACT ext_1, BEGIN NOW
On the primary system, start the primary Extract so that it is ready to capture transactional changes.
START EXTRACT ext_1
Switch user activity to the primary system.
(Optional) If system maintenance must be done on the live standby system, you can do it now, before starting the data pump on the primary system. Note that captured data will be accumulating on the primary system while the standby is offline.