Time for action – monitoring Redo Apply
We'll install Data Guard configuration beginning with Chapter 2, Configuring Oracle Data Guard Physical Standby Database. So, you will not be able to perform the actions in this chapter on the test environment. Please just read the actions to consolidate the given theoretical information mentioned earlier.
We'll query the
v$managed_standby view on the standby database for monitoring. The Data Guard configuration is in the Maximum Performance mode with
LGWR attributes. We'll change the redo transport and apply characteristic and monitor the behavior of Data Guard.
- For our first test, a one hour delay is defined. Let's check this by running the following query on the primary database:
SQL> select name, ...