Table of Contents
- List of Examples
- List of Figures
- List of Tables
- Title and Copyright Information
- Preface
-
Part I Concepts and Administration
- 1 Introduction to Oracle Data Guard
- 2 Getting Started with Oracle Data Guard
-
3
Creating a Physical Standby Database
- About Creating a Physical Standby in a Multitenant Environment
- Preparing the Primary Database for Standby Database Creation
-
Step-by-Step Instructions for Creating a Physical Standby Database
- Creating a Physical Standby Task 1: Create a Backup Copy of the Primary Database Data Files
- Creating a Physical Standby Task 2: Create a Control File for the Standby Database
- Creating a Physical Standby Task 3: Create a Parameter File for the Standby Database
- Creating a Physical Standby Task 4: Copy Files from the Primary System to the Standby System
- Creating a Physical Standby Task 5: Set Up the Environment to Support the Standby Database
- Creating a Physical Standby Task 6: Start the Physical Standby Database
- Creating a Physical Standby Task 7: Verify the Physical Standby Database Is Performing Properly
- Creating a Physical Standby: Post-Creation Steps
- Using DBCA to Create a Data Guard Standby
- Creating a PDB in a Primary Database
-
4
Creating a Logical Standby Database
- About Creating a Logical Standby in a Multitenant Environment
- Prerequisite Conditions for Creating a Logical Standby Database
-
Step-by-Step Instructions for Creating a Logical Standby Database
- Creating a Logical Standby Task 1: Create a Physical Standby Database
- Creating a Logical Standby Task 2: Stop Redo Apply on the Physical Standby Database
- Creating a Logical Standby Task 3: Prepare the Primary Database to Support a Logical Standby Database
- Creating a Logical Standby Task 4: Transition to a Logical Standby Database
- Creating a Logical Standby Task 5: Open the Logical Standby Database
- Creating a Logical Standby Task 6: Verify the Logical Standby Database Is Performing Properly
- Creating a Logical Standby: Post-Creation Steps
- 5 Using Far Sync Instances
- 6 Oracle Data Guard Protection Modes
-
7
Redo Transport Services
- Introduction to Redo Transport Services
- Configuring Redo Transport Services
- Cascaded Redo Transport Destinations
- Data Protection Considerations for Cascading Standbys
- Validating a Configuration
- Monitoring Redo Transport Services
- Tuning Redo Transport
- 8 Apply Services
- 9 Role Transitions
-
10
Managing Physical and Snapshot Standby Databases
- Starting Up and Shutting Down a Physical Standby Database
-
Opening a Physical Standby Database
-
Real-time Query
- Monitoring Apply Lag in a Real-time Query Environment
- Configuring Apply Lag Tolerance in a Real-time Query Environment
- Forcing Redo Apply Synchronization in a Real-time Query Environment
- Real-time Query Restrictions
- Automatic Block Media Recovery
- Manual Block Media Recovery
- Tuning Queries on a Physical Standby Database
- Adding Temp Files to a Physical Standby
- Using SQL and PL/SQL on Active Data Guard Standbys
- Using Temporary Tables on Active Data Guard Instances
- IM Column Store in an Active Data Guard Environment
- In-Memory External Tables in an Active Data Guard Environment
- Using Sequences in Oracle Active Data Guard
- Using the Result Cache on Physical Standby Databases
-
Real-time Query
-
Primary Database Changes That Require Manual Intervention at a Physical Standby
- Adding a Data File or Creating a Tablespace
- Dropping Tablespaces and Deleting Data Files
- Using Transportable Tablespaces with a Physical Standby Database
- Renaming a Data File in the Primary Database
- Add or Drop a Redo Log File Group
- NOLOGGING or Unrecoverable Operations
- Refresh the Password File
- Reset the TDE Master Encryption Key
- Recovering Through the OPEN RESETLOGS Statement
- Automatic Flashback of a Mounted Standby After a Primary RESETLOGS Operation
- Monitoring Primary, Physical Standby, and Snapshot Standby Databases
- Replicating Restore Points from Primary to Standby
- Tuning Redo Apply
- Tuning Databases in an Active Data Guard Environment with SQL Tuning Advisor
- Using Oracle Diagnostic Pack to Tune Oracle Active Data Guard Standbys
- Managing a Snapshot Standby Database
-
11
Managing a Logical Standby Database
- Overview of the SQL Apply Architecture
- Controlling User Access to Tables in a Logical Standby Database
- Views Related to Managing and Monitoring a Logical Standby Database
- Monitoring a Logical Standby Database
- Customizing a Logical Standby Database
-
Managing Specific Workloads In the Context of a Logical Standby Database
- Importing a Transportable Tablespace to the Primary Database
- Using Materialized Views
- How Triggers and Constraints Are Handled on a Logical Standby Database
- Using Triggers to Replicate Unsupported Tables
- Recovering Through the Point-in-Time Recovery Performed at the Primary
- Running an Oracle Streams Capture Process on a Logical Standby Database
- Tuning a Logical Standby Database
- Backup and Recovery in the Context of a Logical Standby Database
-
12
Using RMAN to Back Up and Restore Files
- About RMAN File Management in an Oracle Data Guard Configuration
- About RMAN Configuration in an Oracle Data Guard Environment
- About RMAN Support for Oracle Data Guard In a Multitenant Environment
- Recommended RMAN and Oracle Database Configurations
- Backup Procedures
- Registering and Unregistering Databases in an Oracle Data Guard Environment
- Reporting in an Oracle Data Guard Environment
- Performing Backup Maintenance in an Oracle Data Guard Environment
- Recovery Scenarios in an Oracle Data Guard Environment
- Additional Backup Situations
- Restoring and Recovering Files Over the Network
- Rolling Forward a Standby With One Command
-
13
Using SQL Apply to Upgrade the Oracle Database
- Benefits of a Rolling Upgrade Using SQL Apply
- Requirements to Perform a Rolling Upgrade Using SQL Apply
- Figures and Conventions Used in the Upgrade Instructions
- Performing a Rolling Upgrade By Creating a New Logical Standby Database
- Performing a Rolling Upgrade With an Existing Logical Standby Database
- Performing a Rolling Upgrade With an Existing Physical Standby Database
- 14 Using DBMS_ROLLING to Perform a Rolling Upgrade
-
15
Oracle Data Guard Scenarios
- Configuring Logical Standby Databases After a Failover
- Converting a Failed Primary Into a Standby Database Using Flashback Database
- Using Flashback Database After Issuing an Open Resetlogs Statement
- Recovering After the NOLOGGING Clause Is Specified
- Creating a Standby Database That Uses OMF or Oracle ASM
- Recovering From Lost-Write Errors on a Primary Database
- Using the DBCOMP Procedure to Detect Lost Writes and Other Inconsistencies
- Converting a Failed Primary into a Standby Database Using RMAN Backups
- Changing the Character Set of a Primary Without Re-Creating Physical Standbys
- Actions Needed On a Standby After a PDB PITR or PDB Flashback On a Primary
- Recovery After PDB PITR or PDB Flashback in an Active Data Guard Environment
- Part II Reference
-
Appendixes
-
A
Troubleshooting Oracle Data Guard
- Common Problems
- Log File Destination Failures
- Handling Logical Standby Database Failures
- Problems Switching Over to a Physical Standby Database
- Problems Switching Over to a Logical Standby Database
- What to Do If SQL Apply Stops
- Network Tuning for Redo Data Transmission
- Slow Disk Performance on Standby Databases
- Log Files Must Match to Avoid Primary Database Shutdown
- Troubleshooting a Logical Standby Database
-
B
Patching, Upgrading, and Downgrading Databases in an Oracle Data Guard Configuration
- Before You Patch or Upgrade the Oracle Database Software
- Patching Oracle Database with Standby First Patching
- Upgrading Oracle Database with a Physical Standby Database in Place
- Upgrading Oracle Database with a Logical Standby Database in Place
- Modifying the COMPATIBLE Initialization Parameter After Upgrading
- Downgrading Oracle Database with No Logical Standby in Place
- Downgrading Oracle Database with a Logical Standby in Place
-
C
Data Type and DDL Support on a Logical Standby Database
- Datatype Considerations
- Support for Data Types That Lack Native Redo-Based Support
- Support for Transparent Data Encryption (TDE)
- Support for Tablespace Encryption
- Support For Row-level Security and Fine-Grained Auditing
- Oracle Label Security
- Oracle Database Vault
- Oracle E-Business Suite
- Supported Table Storage Types
- Unsupported Table Storage Types
- PL/SQL Supplied Packages Considerations
- Unsupported Tables
- Skipped SQL Statements on a Logical Standby Database
- DDL Statements Supported by a Logical Standby Database
- Distributed Transactions and XA Support
- Support for SecureFiles LOBs
- Support for Database File System (DBFS)
- Character Set Considerations
- Additional PL/SQL Package Support Available Only in the Context of DBMS_ROLLING Upgrades
- D Oracle Data Guard and Oracle Real Application Clusters
- E Creating a Standby Database with Recovery Manager
- F Setting Archive Tracing
- G Performing Role Transitions Using Old Syntax
- H Using the ALTERNATE Attribute to Configure Remote Alternate Destinations
-
A
Troubleshooting Oracle Data Guard
- Index