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

You administer a Data Guard environment with a primary and two physical standby databases.
One of the physical standby databases is used for reporting and is on the same host as the primary database.
The other physical standby database is remote, used for disaster recovery and REDO is routed to it via a far sync instance.
Backups are offloaded to the remote physical standby.
Which three are true concerning the management of archive logs in this Data Guard configuration?

Answer options

• A. Archive logs on the primary database may be deleted once they are applied on all standby databases.
• B. Archive logs on the primary database may be deleted once they are shipped on all standby databases.
• C. The deletion policy for archive logs on the remote physical standby should be set so that archived logs are deleted once they backed up at least once on the remote physical standby database.
• D. The deletion policy for archive logs on the remote physical standby should be set so that archived logs are deleted once they are applied on all standby databases.
• E. Archive logs on the primary database may be deleted once they are archived locally to disk.

Correct answer: A, D, E

Explanation

The correct answer A is valid because archive logs can be deleted from the primary database once they've been applied to all standby databases, ensuring they are no longer needed for recovery. Answer D is incorrect because it suggests deleting logs based on application rather than backup, which does not apply to the remote standby. Answer E is also incorrect as it implies logs can be deleted just after being archived locally, without considering their status on the standby databases.