Moving User Activity to the Live Standby

To move user activity to the live standby:

(Optional) If you need to perform system maintenance on the secondary system, you can do so now or at the specified time later in these procedures, after moving users from the secondary system back to the primary system. In either case, be aware of the following risks if you must shut down the secondary system for any length of time:
- The local trail on the primary system could run out of disk space as data accumulates while the standby is offline. This will cause the primary Extract to abend.
- If the primary system fails while the standby is offline, the data changes will not be available to be applied to the live standby when it is functional again, thereby breaking the synchronized state and requiring a full re-instantiation of the live standby.
On the primary system, stop the user applications, but leave the primary Extract and the data pump on that system running so that they capture any backlogged transaction data.
On the primary 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_1
```
Note:

Since capture continues to read REDO, the non-production workload continues to work. In this case, there is possibility that At EOF is never returned even though the production workload has already stopped8.5.1..
On the primary system, stop the primary Extract process
```
STOP EXTRACT ext_1
```
On the primary 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 live standby.
```
LAG EXTRACT pump_1
```
On the live standby 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_1
```
On the live standby system, stop Replicat.
```
STOP REPLICAT rep_1
```
On the live standby 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.
Switch user activity to the live standby system.
On the primary system, perform the system maintenance.