Interview Questions - Oracle Data Guard - 2
1) What is a Redo Transport Service in Oracle Data Guard? The Redo Transport Service is responsible for transmitting redo data from the primary database to the standby database. It ensures that changes made to the primary database are replicated to the standby database, keeping them synchronized. The two modes of redo transport are synchronous and asynchronous. 2) How is log transport initiated from the Primary to Standby database? Log transport from the Primary to Standby database in Oracle Data Guard is initiated through a series of steps and mechanisms that ensure the redo data (changes made to the database) is reliably transmitted and applied to the standby database. Here’s how the process works: A) Redo Generation: As transactions are committed on the primary database, redo entries are generated and written to the online redo log files. B) Log Writer Process (LGWR): The Log Writer process is responsible for writing redo entries from the redo log buffer in memory to the o