Oracle Database 12c: RAC and Grid Infrastructure Administration — Question 92

Which three are true about the use of the VALID_FOR clause of the LOG_ARCHIVE_DEST_N parameter, in determining whether archive logs should be written to a particular destination by a database in a Data Guard environment? (Choose three.)

Answer options

• A. whether the database at the destination is reached by using a far sync instance
• B. whether the database at the destination is a primary or a standby
• C. whether online redo logs are to be archived at a specific destination
• D. whether standby redo logs are to be archived at a specific destination
• E. whether the database at the source is a primary or a standby

Correct answer: A, D, E

Explanation

The VALID_FOR clause helps determine the conditions under which archive logs are sent to a destination. Options A, D, and E are correct as they relate to the connectivity of the destination database, the role of standby redo logs, and the status of the source database. Options B and C are incorrect as they do not pertain to the VALID_FOR clause's specific conditions for archiving logs.