Build and manage Oracle 11g Active Data Guard

Build and manage Oracle 11g Active Data Guard

Note: You can refer to the notes and ideas of many people on the Internet, and sort out notes after your own hands-on experience for your reference only.

Data Guard differs from RAC in that in general, Standby only one node is active and all applications are connected to the master server. Switch to the backup server is considered only when the server fails.

The Data Guard physical standby database in Oracle versions earlier than 11g can open the database in read-only mode. However, MediaRecovery stops synchronizing Data using logs, if the physical standby database is in the recovery process, the database cannot open the query, that is to say, the log application and read-only open are mutually exclusive, and the Oracle 11g Active Data Guard function solves this conflict, when using logs to recover data, you can open the database in read-only mode. You can perform queries, reports, and other operations on the backup database, this is similar to the Logic Data Guard standby database function (query function). However, Data synchronization is more efficient and hardware resources are less required. In this way, the hardware resources of the physical backup database can be used to a greater extent.

Oracle 11g Physical Active Data Guard Real-time query feature. With the support of this feature, Oracle can meet the requirements of the slave database as a report database or query and analysis database to the maximum extent.

Using Oracle 11g Duplicate From Active Database technology, rman is used to connect to the master Database through the network for replication.

Install Oracle 11gR2 (x64) in CentOS 6.4)

Steps for installing Oracle 11gR2 in vmwarevm

Install Oracle 11g XE R2 In Debian

Configure Oracle 11g Data Guard based on the same host

Explore Oracle 11g elastic uard

Oracle Data Guard (RAC + DG) archive deletion policies and scripts

Role conversion for Oracle Data Guard

FAL gap in Oracle Data Guard logs

Oracle 11g Data Guard Error 16143 Heartbeat failed to connect to standby

I. Environment Introduction

1. primary database environment

Operating system version: OEL6.4 x64

Database Version: Oracle 11.2.0.4.0x64

Database sid Name: orcl

Database db_unique_name: orcl_primary

2. Standby database environment

Operating system version: OEL6.4 x64

Database Version: Oracle 11.2.0.4.0x64 (only oracle database software is installed, no netcadbca)

Database sid Name: orcl

Database db_unique_name: orcl_standby

Configure the hosts file

# Cat/etc/hosts

192.168.10.205 oradb205 oradb205.localdomain

192.168.10.206 oradb206 oradb206.localdomain

The archive mode must be enabled for the database (both master and slave databases are modified ):

SQL> shutdown immediate

SQL> startup mount

SQL> alter database archivelog;

SQL> alter database open;

SQL> archive log list;

Three protection modes of DG:

Maximum Protection | MaximumPerformance Maximum performance (default mode) | Maximum Availability

View the protection mode of DG

SQL> selectdb_unique_name, protection_mode, protection_level from v $ database;

Set protection mode (optional)

SQL> alter database set standbydatabase to maximize performance;

SQL> alter database set standbydatabase to maximize availability;

SQL> alter database set standbydatabase to maximize protection;

 

For more details, please continue to read the highlights on the next page:

1 2 3 4 5 6 7 Next Page