oracle data guard synchronous replication

Data Guard provides two services:1) Redo transmission service: Transfers Redo logs of Primay to one or more Standby destinations.2) Redo Application Service: The Redo log transmitted from Primay on the Standby side.This article describes the Redo transmission service. 1. Use ARCn to transmit Redo logsBy default, ARCn is used to transmit redo logs. However, ARCn can be used only in the highest-performance mo

The data guard provides the following three kinds of protection modes: 1 Maximum protection mode (Maximum Protection) "Maximum protection" here refers to the maximum protection of the data is not lost, that is, at least one standby and primary maintain real-time synchronization, but this is costly, that is, when a transaction is committed, not only to write to

The FAL gap problem of Oracle Data Guard logs is found in the OracleData Guard environment. A standby database has a problem and needs to be redone. Because the previously configured environment is good, you only need to back up the full database of the master database to the slave database. However, after the

Data Guard offers two main services:1 Redo Transport Service: The Primay end of the redo log transmission to one or more standby destinations.2 Redo Application Service: The redo log which is transmitted from the Primay end is applied to the standby end.This article first discusses the redo transport services. 1, the use of ARCN transmission redo logBy default, the ARCN transport redo log, but only in the

Oracle Data Guard (iii) Switchover 1. check the status of the Primary database SQL> select switchover_status from v $ database; Role Switching can be performed only when the status is "TO STANDBY" or "SESSIONS ACTIVE. 2. switch the role SQL of the Primary database> alter database commit to switchover to physical standby with session shutdown; SQL> shutdown immedi

The following is a detailed analysis of the use of Oracle switchover and failover, the need for friends under the reference The role switching between Data guard master and subordinate libraries is divided into the following two kinds:1) SwitchoverSwithchover are usually artificial and planned for role swaps, such as upgrades. It is usually lossless, that is, th

Environment: OS: Red Hat Linux As 5DB: 11.2.0.1 11G has greatly improved the volume uard, the slave database can still apply the archive logs uploaded from the master database. Remember to open the slave database to check whether the data has been transmitted at 10 Gb, you must stop the log application first. the following describes how to create a physical standby database. The database adopts the common file management method (the

[Oracle] Data Guard series (6)-role conversionThe core function of DG is to provide high-availability Disaster Tolerance. Therefore, the role conversion content described in this section is the most important part of DG. Role Switching between master and slave databases of DG is divided into the following two types: 1) SwitchoverSwithchover refers to role switchi

Oracle 11g Data Guard Broker operation notes I. Settings 1. Set broker 2. operate on the master database DGMGRL> help DGMGRL> help create DGMGRL> create configuration c1 as primary database is PROD1 connect identifier is PROD1; DGMGRL> help add DGMGRL> add database dg as connect identifier is dg; DGMGRL> help enable DGMGRL> enable configuration; DGMGRL> help show

[Oracle] Data Guard series (3)-log application Redo application or SQL application? We know that there are two types of standby databases: Physical standby database and logical standby database. The log application of the physical standby database is called the Redo application, the log application of the logical standby database is called the SQL application. Th

Oracle replication table structure and data, oracle replication Structure 1. Copy the table structure and data: Create table table_name_new as select * from table_name_old 2. copy only the table structure: Create table table_n