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

Verifying the logical standby database

There are two services that we need to check for the verification of the logical standby configuration, which are the redo transport service and the SQL Apply service. There are several ways to check the status of these services. You can use alert log and trace files (whenever necessary) or you can query the views of the logical standby database that contains information about the status of the Data Guard services. Another way for controlling is modifying the primary database tables and querying the same tables on the logical standby. We'll now query the most useful views to gather information about the configuration and service status.

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