O'Reilly logo

Oracle Data Guard 11gR2 Administration Beginner's Guide by Nassyam Basha, Emre Baransel

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating a logical standby database

As mentioned, a physical standby database is needed to create a logical standby database. It is assumed that we have a Data Guard configuration with a primary and one or more physical standby databases, which are synchronized with the primary. In order to create a logical standby database, we should first check the primary and the physical standby databases and make them ready for a logical standby conversion. These configurations are as follows:

  • Stopping the media recovery on the standby
  • Configuring primary database initialization parameters to be ready for a logical standby role transition
  • Building the LogMiner dictionary on the primary
  • If standby is RAC, converting it to a single instance temporarily

After completing ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required