Master Note for Data Guard

Master Note for Data Guard [ID 1101938.1]
Modified 12-AUG-2010 Type BULLETIN Status PUBLISHED

In this Document
Purpose
Scope and Application
Master Note for Data Guard
Setup and Configuration of Data Guard

Patching, Upgrade and Migration
Managing Data Guard - Physical Standby
Managing Data Guard - Logical Standby
Switchover and Failover
Performance
Troubleshooting
Dataguard and RAC
Miscellaneous

Applies to:
Oracle Database Products > Oracle Database > High Availability
Information in this document applies to any platform.
Purpose
This Master Note is intended to provide an index and references to the most frequently used My Oracle Support Notes with respect to Data Guard implementations. This Master Note is subdivided into categories to allow for easy access and reference to notes that are applicable to your area of interest, within the Data Guard.
Scope and Application

This is a master note for the data guard content that can be accessed from one page
Master Note for Data Guard

This note applies to the following versions of these products:

Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.x

Oracle Server - Enterprise Edition - Version: 11.1.0.6 to 11.1.0.x

Oracle Server - Enterprise Edition - Version: 11.2.0.1 to 11.2.0.x
Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.x

Setup and Configuration of Data Guard

Note.343424.1 Creating a 10gr2 Data Guard Physical Standby database with Real-Time apply

Note.380449.1 Creating a RAC Physical Standby for a RAC Primary

Note.387339.1 Creating a Single Instance Physical Standby for a RAC Primary

Creating a RAC Logical Standby Database for a RAC Primary Database

Client Failover setup in Data Guard Configurations

Data Guard Fast-Start Failover - Best Practices

Setup Multiple Standby Databases - Best Practices



Patching, Upgrade and Migration

Note.278641.1 Applying Patchset with a 10g Physical Standby in Place

Note.278521.1 Upgrading to 10g with a Physical Standby in Place

Note 437276.1 Upgrading Oracle Database with a Logical Standby Database In Place

Note 756671.1 Oracle Recommended Patches -- Oracle Database

Rolling Database Upgrades Using Data Guard SQL Apply

Minimal Downtime Migration to ASM

Oracle 10g Upgrade Companion - for upgrading from Oracle9i to Oracle10g

Managing Data Guard - Physical Standby


Adding a Datafile or Creating a Tablespace

Dropping Tablespaces and Deleting Datafiles

Renaming a Datafile in the Primary Database

Recovering Through the OPEN RESETLOGS Statement

Opening a Physical Standby Database for Read-Only Access

Note.382686.1 CAN DATAGUARD HAVE DIFFERENT SCHEMA ACCOUNT STATUS FOR PRIMARY AND STANDBY DB ?

Note. 394815.1 How to Rename the Datafiles When using OMF in Standby



Managing Data Guard - Logical

Using DBMS_LOGSTDBY.SKIP to Prevent Changes to Specific Schema Objects

Modifying a Logical Standby Database



Switchover and Failover

Note.414043.1 Transitions for Data Guard Configurations Using Mixed Oracle Binaries

Note.738642.1 Step by Step Guide on How To Reinstate Failed Primary Database into Physical Standby

Data Guard Switchover and Failover - Best Practice



Performance

Tuning a Logical Standby Database

Troubleshooting

Note 814417.1 Information to gather and upload for Dataguard related problems

Note.241374.1 Script to Collect Data Guard Primary Site Diagnostic Information

Note.241438.1 Script to Collect Data Guard Physical Standby Diagnostic Information

Note.241512.1 Script to Collect Data Guard Logical Standby Diagnostic Information



Dataguard and RAC

Note.370434.1 How to make CRS aware of the role change in Data Guard environment?



Miscelleanous

Note 386830.1 ALERT: Bug 5380055 Corrupts Index Blocks Especially in Data Guard Configurations




Common Dataguard errors

ORA-16057 DGID from server not in Data Guard configuration

ORA-12154 TNS No Listener





Oracle Server - Enterprise Edition - Version: 11.1.0.6 to 11.1.0.x


Setup and Configuration of Data Guard



Creating a Physical Standby Database

Creating a Logical Standby Database

Patching, Upgrade and Migration



Rolling Database Upgrades using Data Guard SQL Apply

Rolling Database Upgrades for Physical Standby Databases using Transient Logical Standby 11g

Oracle 11g Upgrade Companion - for upgrading from Oracle9i to Oracle11g


Managing Data Guard - Physical Standby


Redo Apply Best Practices


Managing Data Guard - Logical Standby


SQL Apply Best Practices

Monitoring a Logical Standby Database


Switchover and Failover



Role Transitions Involving Physical Standby Databases

Role Transitions Involving Logical Standby Databases

Using Flashback Database After a Role Transition
Performance



Tuning a Logical Standby Database


Troubleshooting



Note 814417.1 Information to gather and upload for Dataguard related problems

Note.241374.1 Script to Collect Data Guard Primary Site Diagnostic Information

Note.241438.1 Script to Collect Data Guard Physical Standby Diagnostic Information

Note.241512.1 Script to Collect Data Guard Logical Standby Diagnostic Information

Setting Archive Tracing
Dataguard and RAC


Data Guard 11g Installation and Configuration Best Practices on Oracle RAC


Miscellaneous


Active Data Guard 11g Best Practices

Configuring Oracle Business Intelligence Enterprise Edition Server with Active Data Guard



Common Data Guard errors
Using My Oracle Support Effectively

* Note 374370.1 New Customers Start Here
* Note 736737.1 My Oracle Support - The Next Generation Support Platform
* Note 730283.1 Get the most out of My Oracle Support
* Note 747242.5 My Oracle Support Configuration Management FAQ
* Note 868955.1 My Oracle Support Health Checks Catalog
* Note 166650.1 Working Effectively With Global Customer Support
* Note 199389.1 Escalating Service Requests with Oracle Support Services