oracle data guard apply lag

[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

Data Guard provides the following three kinds of protection mode, the following is a detailed analysis of the three protection modes, the need for friends can refer to the next The data guard provides the following three kinds of protection modes: 1 Maximum protection mode (Maximum Protection)"Maximum protection" her

Non-Data guard patch installation tutorials refer to the [Oracle] CPU/PSU patch installation detailed tutorial, where Data Guard requires primary and standby to be patched at the same time, so the steps are more complex and the main steps are as follows: 1. Stop log transfer

a dictionary in the redo dataTo build dictionary in the redo data, you must enable the logminer at first.Issuing the following statement when the primary database is in the open state:04:59:50 SQL> alter database add Supplemental log data;If you do not run the command above to enable the logminer, the alter database recover to logical standby cuuo will never end up even if you run;Execute dbms_logstdby.bui

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 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 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

Lab environment: OEL + Oracle11.2.0.3 + physical standby As we all know, Data Guard is already the mainstream disaster tolerance solution of today's standards. Due to its strong adaptability to the network, it can adopt synchronous real-time transmission methods and asynchronous delay transmission methods, it can even become a remote disaster recovery solution. Regardless of the purpose, the DG will inevita

Lab environment: OEL + Oracle11.2.0.3 + physical standby As we all know, Data Guard is already the mainstream disaster tolerance solution of today's standards. Due to its strong adaptability to the network, it can adopt synchronous real-time transmission methods and asynchronous delay transmission methods, it can even become a remote disaster recovery solution. Regardless of the purpose, the DG will inevita

Data Guard provides the following three Data protection modes: 1) Maximum Protection)The "maximum protection" here refers to protecting data from loss to the maximum extent, that is, at least one standby and primary are synchronized in real time, but this is costly, that is, when a transaction is committed, it should n

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 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

set to MANUAL or AUTO: Drop the tablespace from the primary database:1. delete a tablespace from the master databaseSQL> drop tablespace tbs_4; SQL> ALTER SYSTEM SWITCH LOGFILE; Make sure that Redo Apply is running (so that the change is applied to the standby database). If the following query returns the MRP or MRP0 process, Redo Apply is running.Make sure that the redo application is running, so that

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 (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

　　To delete an archive file of the master database in the Maximum Availability and Maximum Performance modes of Oracle Data Guard, the archive file must be deleted after the backup database is applied. 　　For Maximum Protection mode, logs in this mode are written to the master database and the slave database at the same time. Therefore, in this mode, there is no l

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

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