更新时间：2021-08-13 17:12:54
封面
版权信息
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Preface
Chapter 1. Getting Started
What is Data Guard?
Standby database
Oracle Data Guard evolution
Oracle Data Guard architecture
Time for action – monitoring Redo Apply
Time for action – using interfaces to monitor Data Guard
Other replication solutions and Data Guard
Summary
Chapter 2. Configuring the Oracle Data Guard Physical Standby Database
Preconfiguration for Data Guard
Time for action – enabling the archive log mode
Time for action – enabling force logging
Time for action – configuring standby redo logs on primary
Time for action – enabling FRA
Creating the physical standby database
Time for action – starting the physical standby instance and making it ready for the RMAN duplicate
Time for action – running an RMAN duplicate
Post-installation steps
Time for action – verifying the standby database configuration
Time for action – starting stopping and monitoring MRP
Time for action – verifying synchronization between the primary and standby databases
Time for action – testing real-time apply
Chapter 3. Configuring Oracle Data Guard Logical Standby Database
Logical standby database characteristics
Preparation for the configuration
Time for action – checking for the unsupported data types
Time for action – searching for and fixing any table row uniqueness problem
Creating a logical standby database
Time for action – making a physical standby database environment ready for conversion
Time for action – converting a physical standby database into a logical standby database
Verifying the logical standby database
Time for action – checking the redo transport service status
Time for action – checking the SQL Apply service status
Customization and management in a logical standby database
Time for action – working with skip rules on a logical standby database
Time for action – changing the Database Guard setting
Time for action – creating objects on the logical standby database
Chapter 4. Oracle Data Guard Broker
Introduction to Data Guard broker
Data Guard broker features and benefits
Data Guard broker components
Implementation of Oracle Data Guard broker
Time for action – initial setup of Data Guard broker
Time for action – connecting to Data Guard broker
Time for action – basic monitoring with Data Guard broker
Management with Data Guard broker
Time for action – disabling broker configuration
Time for action – disabling and enabling database
Time for action – changing the database name
Most Common Data Guard broker issues
Oracle Data Guard fast-start failover
Time for action – configuring fast-start failover
Chapter 5. Data Guard Protection Modes
The Maximum Protection mode
The Maximum Performance mode
The Maximum Availability mode
Choosing the correct mode for your requirements
Changing Data Guard protection mode
Time for action – changing the protection mode with SQL*Plus
Time for action – changing the protection mode with Data Guard broker
Time for action – changing the protection mode with Enterprise Manager Cloud Control
Chapter 6. Data Guard Role Transitions
Role transition considerations
Switchover
Time for action – preliminary tests before performing switchover
Time for action – switchover with a physical standby using SQL*Plus
Time for action – switchover with a physical standby using broker
Time for action – switchover with a physical standby using EM Cloud Control
Time for action – switchover with a logical standby database using SQL*Plus
Time for action – switchover with a logical standby using broker
Failover
Time for action – failover with a physical standby database using SQL*Plus
Time for action – failover with a logical standby using broker
Chapter 7. Active Data Guard Snapshot Standby and Advanced Techniques
Oracle Active Data Guard
Time for action – enabling Active Data Guard if Redo Apply is running using SQL *PLUS
Time for action – enabling Active Data Guard if the standby database is shut down
Time for action – enabling Active Data Guard using broker
Time for action – Active Data Guard with PeopleSoft
Time for action – exporting a database backup from Active Data Guard
Time for action – using the ASH report from the standby database
Using a snapshot standby database
Time for action – converting to a snapshot standby database
Time for action – converting to a physical standby database
Cascade standby databases
Time for action – cascade standby database
Advanced compression in Data Guard
