Multiple choice

A primary database named PROD and a standby database named PRODS is maintained using standby log transmission to send the log files to the standby database.

To prevent any propagation of errors, the standby database should wait for 20 minutes before processing any log files shipped from the primary database.

What steps should be taken?

  1. The LOG_ARCHIVE_DEST_n = 'SERVICE=PRODS DELAY 20' parameter should be included in the parameter file on the primary database

  2. The LOG_ARCHIVE_DEST_n = 'SERVICE=PROD DELAY 20' parameter should be included in the parameter file on the standby database

  3. The REOPEN option should be specified on the LOG_ARCHIVE_DEST_n parameter

  4. At least one of the log archive destinations should be set to MANDATORY
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The DELAY attribute in LOG_ARCHIVE_DEST_n parameter on the PRIMARY database causes archived logs to be held for the specified minutes before being applied on the standby. Setting 'SERVICE=PRODS DELAY 20' on PROD ensures PRODS waits 20 minutes before applying shipped logs. This prevents corrupted or erroneous data from being immediately propagated to the standby, providing a recovery window.

Keep practicing — related questions