oracle data guard protection modes

[Oracle] Data Guard series (4)-creating a physical standby database without stopping the master database needs to create a physical standby database of DG for a 24x7 production database, the master database must not be shut down. At first, it was impossible. Later, I checked the document and used the rman duplicate command to create a physical standby database on

[Oracle] role switching between Data Guard-Switchover and Failover Data Guard master/Slave databases can be divided into the following two types: 1) SwitchoverSwithchover is generally artificially scheduled for role switching, such as upgrading. It is usually lossless, that

Oracle Data Guard synchronizes Data through archive files. The archive files of the master database can be deleted during RMAN backup, but the archive files of the slave database cannot be deleted automatically. You need to write scripts to delete them regularly. If you delete an archive file directly, you may find tha

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 redo log is transferred using ARCN, but o

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

The first time Oracle 11g R2 Active Data guard is configured today, after physical standby database is created with rman,The following error occurs when you try to open standby in read only mode: SQL> alter database open read only;Alter database open read only*Error at line 1:ORA-10458: standby database requires recoveryORA-01152: File 1 was not restored from a s

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

In the previous section, "Data Guard series (2)-Log Transfer", we introduced the DG Log Transport service, the log Application service is introduced in this section after the log is transferred from the main library to the standby repository, and the repository needs to apply logs to maintain synchronization with the main library. Redo application or SQL application? We know that there are two types of re

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

[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

The following is a detailed analysis of the use of Switchover and Failover in Oracle. For more information, see Role Switching between Data Guard master and slave databases is divided into the following two types:1) SwitchoverSwithchover is generally designed to switch roles, such as upgrading. It is usually lossless, that is, there will be no

[Oracle] Data Guard-Redo applications physical Standby and logical Standby Log application services are divided into two types, one is physical Standby Redo applications, similar to media recovery, its advantage is that the speed is fast, but in 10g cases, Standby must be in the mount State and cannot share part of the read load for Primary (physical Standby can

Oracle Data Guard (iv) Failover 1. check for missing logs in the Standby database. Run the following command to check for missing logs: SQL> select thread #, log_sequence #, high_sequence # from v $ archive_gap; copy the missing log file from the primary database to the log directory specified by the standby database, and run the following command to register it

After the DG is set up, it is found that the repository does not accept logs from the main library.Executing in the main librarySelect dest_id,status,error from V$archive_dest where dest_id=3;Report: Ora-16057:dgid from server not in Data Guard configurationThe meaning of the error is obvious, Log_archive_config is not configuredBut I've configured it in the main library.alter system set Log_archive_config