oracle_guard_installation

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
oracle_guard_installation [2020/10/25 12:17] andonovjoracle_guard_installation [2020/10/25 15:17] (current) – [Verify Replication] andonovj
Line 624: Line 624:
   * Logical Guard (up to Read Write)   * Logical Guard (up to Read Write)
  
-{{:oracle-data-guard-13-728.jpg?600|}}+{{:oracledataguard.jpg?600|}}
  
  
 ---- ----
-The Physical Guard is using the MRP process to apply the logs, where the Logical Guard is using the LSP. The difference is pretty simple:+Archiver Process –  The archiver process (ARCn or ARCH) is responsible for archiving online redo logs. The archival destination could be a local destination or a remote standby database site. In the case of a Data Guard configuration, one of the archival destinations must be a standby database The archiver process of the primary database writes the redo log file.
  
-  * MRP - Keeping the Database in constant state of Recovery +Log Writer (LGWR) – The log writer process on the primary database writes entries from the redo log buffer to the online redo log file. When the current online redo log file is full, it triggers the archiver process to start the archiving activity. 
-  LSP - Generate SQL from the archivelog fileswhich then, it applies to the database.+ 
 +Remote File Server (RFS) Process – The RFS process runs on the standby database and is responsible for communication between the primary and the standby database. For the log transport service, the RFS on the standby database receives the redo records from the archiver or the log writer process of the primary database over Oracle Net and writes to filesystem on the standby site. 
 + 
 +Fetch Archive Log (FAL) – The FAL process has two components: FAL Client and FAL Server. Both processes are used for archive gap resolution. If the Managed Recovery Process (MRP) on the standby database site detects an archive gap sequence, it initiates a fetch request to the FAL client on the standby site. This action, in turn, requests the FAL server process on the primary database to re-transmit the archived log files to resolve the gap sequence. Archive gap sequences will be discussed later in this chapter. 
 + 
 +Once the log transport service completes the transmission of redo records to the standby site, the log apply service starts applying the changes to the standby database. The log apply service operates solely on the standby database. The following processes on the standby site facilitate the log apply operations: 
 + 
 +Managed Recovery Process (MRP) – The MRP  applies the redo entries from the archived redo logs onto the physical standby database. 
 + 
 +Logical Standby Process (LSP) – The LSP applies the redo records from archived redo logs to the logical standby database. The Oracle database log miner engine is used by the logical standby process for the SQL apply operations. Using the log miner enginethe LSP process recreates the SQL statements from redo logs that have been executed on the primary database. These statements are then applied to the standby database to keep it current with the primary database.
  
 Because of that there are limitation of the Logical Guard. But we will address that in the Logical Guard section, enough side ways :) Because of that there are limitation of the Logical Guard. But we will address that in the Logical Guard section, enough side ways :)
  • oracle_guard_installation.1603628253.txt.gz
  • Last modified: 2020/10/25 12:17
  • by andonovj