PDF 1z0-076 Study Guide

C. The LGWR (Log Writer) process is responsible for writing redo entries from the redo log buffer to the online redo log files on the primary database. This is a fundamental process in the Oracle Database architecture, ensuring that all changes made to the database are captured for purposes such as recovery, replication, and high availability.

D. Real-time apply on a logical standby database requires standby redo log files. The standby redo log files are used to store redo data received from the primary database before it is applied to the logical standby database. This enables the logical standby to apply changes as they are received, without waiting for the current redo log file to be archived.

E. Similarly, on a physical standby database, standby redo log files are used for real-time apply. They store redo data from the primary database, allowing the physical standby to apply redo data concurrently as it is received, rather than waiting for redo log files to be archived. This capability is crucial for maintaining a physical standby database that is closely synchronized with the primary database with minimal lag.

These functionalities are integral to Oracle Data Guard configurations and are not dependent on Oracle Streams or Oracle GoldenGate, which are separate technologies for data replication and integration​​​​.

TheDBMS_COMPARISONpackage, used for comparing and converging data objects within a single database or between databases, requires that the databases involved in the block comparison be at least mounted (A). This allows the procedure to access the data blocks for comparison. Additionally, the progress of long-running operations such as block comparison can be monitored using the dynamic performance view V$SESSION_LONGOPS (D), which provides information on the operation's progress and estimated completion time.

Asynchronous redo transport is a method where the primary database does not wait for an acknowledgment from the standby database before committing transactions, which helps in minimizing the impact on the primary database's performance (B). This transport mode is associated with the Maximum Performance data protection mode, which prioritizes performance over synchronicity of data between the primary and standby databases (C). While it provides a level of data protection, there could be some data loss in the event of a primary database failure because redo data may not have been transmitted to the standby database at the time of the failure.