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

A Data Guard environment has this configuration and these attributes:
1. The primary database prima is in the local region.
2. A physical standby database physt1 is in the local region.
3. A physical standby database physt2 is in a remote region.
4. The primary ships redo to physt1.
5. physt1 ships redo physt2.
6. physt1 and physt2 have Real-Time Query enabled.
A sequence has been created with this SQL statement in the primary database:
CREATE SEQUENCE a NOCACHE SESSION:
Which two statements are true?

Answer options

• A. The sequence is usable on physt1 and physt2.
• B. The sequence is usable on physt1 but not usable on physt2.
• C. The sequence is usable on physt2 if physt1 becomes unavailable, but only if an alternative redo destination has been configured on the primary database.
• D. physt2 will no longer receive redo if physt1 becomes unavailable, unless LOG_ARCHIVE_DEST_n has the ALTERNATE attribute specified on the primary database.
• E. physt2 will no longer receive redo if physt1 becomes unavailable, unless LOG_ARCHIVE_DEST_n has the ALTERNATE attribute specified on physt1.

Correct answer: A, D

Explanation

The correct answer A states that the sequence is usable on both physt1 and physt2, which is true since both standby databases have Real-Time Query enabled. Option D is also correct because if physt1 fails, physt2 will not receive redo unless an alternate destination is defined on the primary. The other options are incorrect as they misrepresent the usability of the sequence or the behavior of redo shipping in the scenario.