|René Nyffenegger's collection of things on the web|
René Nyffenegger on Oracle - Most wanted - Feedback
- Follow @renenyffenegger
ARCH vs LGWR log transmission in data guard
Redo log information can be transmitted in one of two ways from the primary database to the standby database: either by ARCH or LGWR.
All writings into the online redo log are synchronously or asynchronously transmitted to the standby database. If there is a standby redo log on the standby site, it is used. If there is no standby redo log on the standby site, an archive log will be gradually filled. However, the uncompletely filled archive log cannot be used in case of a disaster. Therefor, it is recommended to use standby redo logs.
LGWR transmission is specified through the log_archive_dest_n option LGWR:
If LGWR transmission is used, there should be a row having client_process=LGWR in v$managed_standby.
Data is transmitted as an archived redo logs.
ARCH transmission is specified through the log_archive_dest_n option ARCH:
If ARCH transmission is used, there should be a row having client_process=ARCH in v$managed_standby.