Preparation for the configuration

Now it's time to get our hands dirty in the process of creating a logical standby database. First we'll start preparing the primary database for the configuration. Then we'll convert a physical standby database into a logical standby database. This is the method of creating logical standby Data Guard configuration.

Note

You can use the physical standby database that we created together in Chapter 2, Configuring Oracle Data Guard Physical Standby Database for this purpose. However, we'll need a physical standby in the following chapters to study on. So, it would be better to create a separate physical standby database with one of the mentioned methods to use in the logical standby configuration.

There are some prerequisites that we need to complete before starting the configuration. One of them is checking the primary database for specifying any tables that will be skipped by SQL Apply because of the unsupported data types. It doesn't make sense to build a configuration...