After completing this lesson, you should be able to do the following: Explain the advantages of SQL Apply Explain when to use a logical standby database Create a logical standby database by using Enterprise Manager | Creating a Logical Standby Database by Using Enterprise Manager Oracle Database 10g: Data Guard Administration 7 - Objectives After completing this lesson, you should be able to do the following: Explain the advantages of SQL Apply Explain when to use a logical standby database Create a logical standby database by using Enterprise Manager Oracle Database 10g: Data Guard Administration 7 - Benefits of Implementing a Logical Standby Database Provides an efficient use of system resources: Open, independent, and active production database Additional indexes and materialized views can be created for improved query performance. Reduces workload on the primary database by offloading the following workloads to a logical standby database Reporting Summations Queries Benefits of Implementing a Logical Standby Database A logical standby database provides disaster recovery, high availability, and data protection benefits that are similar to those of a physical standby database. It also . | Creating a Logical Standby Database by Using Enterprise Manager Oracle Database 10g: Data Guard Administration 7 - Objectives After completing this lesson, you should be able to do the following: Explain the advantages of SQL Apply Explain when to use a logical standby database Create a logical standby database by using Enterprise Manager Oracle Database 10g: Data Guard Administration 7 - Benefits of Implementing a Logical Standby Database Provides an efficient use of system resources: Open, independent, and active production database Additional indexes and materialized views can be created for improved query performance. Reduces workload on the primary database by offloading the following workloads to a logical standby database Reporting Summations Queries Benefits of Implementing a Logical Standby Database A logical standby database provides disaster recovery, high availability, and data protection benefits that are similar to those of a physical standby database. It also provides the following specialized benefits: Efficient utilization of system resources: A logical standby database is an open, independent, and active production database. It can host multiple database schemas, and users can perform normal data manipulation operations on tables in schemas that are not updated from the primary database. It remains open while the tables are updated from the primary database, and those tables are simultaneously available for read-access. Because the data can be presented with a different physical layout, additional indexes and materialized views can be created to improve your reporting and query requirements and to suit your specific business requirements. Reduction in primary database workload: The logical standby tables that are updated from the primary database can be used for other tasks (such as reporting, summations, and queries), thereby reducing the primary database workload. Oracle Database 10g: Data Guard Administration 7 - Benefits of .
