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?
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.
A,B,C
agree with ABC
A,B,C
Primary:
CONFIGURE ARCHIVELOG DELETION POLICY TO SHIPPED TO ALL STANDBY;
CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY;
Standby (where backups are happening):
CONFIGURE ARCHIVELOG DELETION POLICY BACKED UP n TIMES TO DEVICE TYPE |;
Standby (not part of RMAN backup):
CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY;