Exam 1z0-066 All QuestionsBrowse all questions from this exam
Question 4

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?

    Correct Answer: A, B, C

    In this Data Guard configuration, archive logs on the primary database may be deleted once they are applied on all standby databases to ensure that all standby databases have the necessary logs for synchronization and recovery. This ensures data consistency across the environment (A). Similarly, primary database archive logs may be deleted once they are shipped to all standby databases, as this indicates successful transmission (B). Lastly, the deletion policy for archive logs on the remote physical standby should be set so that archived logs are deleted once they are backed up at least once on the remote physical standby database to ensure that all critical data is securely stored before deletion (C).

Discussion
JESUSBBOptions: ADE

Answer: A, D y E

RockficsOptions: ABC

A, B, C A and B . In the primary is not problem to delete if they are applied o send to standby. C. Archived in remote standby is not possible to delete without backup

mikom80Options: ACE

D (WRONG). 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. Logs could be appileb, but not backed up from standby - so in this scenario is not good.

RogazanOptions: ACE

I think ACE