Oracle 11g Dataguard Configuration Summary

After half a month of Oracle Dataguard physical repository configuration and learning, although the version uses Oracle 11g (11.2.0.3), the configuration process still applies to Oracle 10g. In the process of nearly 10 dataguard configuration, it is found that it is very convenient and fast to create the physical repository using the Rman duplicate method. Gradually will not go to use the cold standby way to create a physical repository, through the Rman duplicate not only can create Dataguard, but also clone database, powerful.

There are several ways to create Dataguard, summarized and understood below.

First, the cold Standby mode configuration Dataguard

Cold standby configuration skipped.

Characteristics:

1 The Pure Manual way configuration Dataguard is suitable for the database to be relatively small situation.

2) Suitable for initial learning Dataguard configuration, test and principle understanding learning.

Second, RMAN duplicate mode configuration Dataguard

The RMAN duplicate can be used not only to create the Dataguard repository, but also to clone the database, simply by modifying the parameters to clone the database directly.

The RMAN duplicate mode is divided into the following several configuration ways:

Method one, through Rman connection target main Library and local auxiliary library, directly through the main library (active library) to crawl data cloning repository.

Sample Configuration Document:

http://koumm.blog.51cto.com/703525/1275237

Advantages:

1 The main library does not need downtime

2 No need for Rman backup in the main library

3 no need to be in the main library of the control file copy of the library

4 There is no need for the main library to prepare a library of parameter files

4 target to the main library can directly apply the main library transfer over the file log and redo log.

Disadvantages:

1 Main Library data files and logs all through the network to copy to the standby, the time will be relatively long, if the main library is particularly large, this method is not appropriate.

More Wonderful content: http://www.bianceng.cn/database/Oracle/

2 When the duplicate affects the performance of the main library and the network pressure, it is necessary to choose the time operation with less pressure than the database.

Mode two, through the Rman connection target master Library and local auxiliary library, through the local backup recovery data to create a repository, successfully reapply this time archive and redo log.

Sample Configuration Document:

http://koumm.blog.51cto.com/703525/1280119

Advantages:

1 The main library does not need downtime

2) compared to active duplicate network pressure and database pressure is much smaller.

3) by duplicate the Rman backup set, the time to create a standby is greatly shortened, especially when the database is particularly large.

4 target to the main library can directly apply the main library transfer over the file log and redo log.

Disadvantages:

1 requires an Rman backup in the main library beforehand.

2) Transfer the backup set to the appropriate location of the repository.

Duplicate another application:

The Rman backup set, which is copied from the target library, is restored (not connected to the target target library) through the attachment of the local auxiliary library.

This method does not apply to the creation of Dataguard, which is suitable for rman backup of the heterogeneous recovery database.

Rman Backup duplicate heterogeneous clone restore database configuration.

http://koumm.blog.51cto.com/703525/1280217