You administer a Data Guard environment consisting of a primary and three physical standby databases. One physical standby database is used for disaster recovery, one is used for reporting, and one is used as a replica for testing.
The standby database used for testing is occasionally converted into a snapshot standby database and then converted back to a physical standby.
The physical standby database is the only standby that is a mandatory destination The broker configuration operates in MAXIMUM PERFORMANCE mode.
Which ARCHIVELOG DELETION POLICY should be set. so that archive logs generated on the primary database are not deleted before they are consumed appropriately on each of the standby databases, but which allows them to be deleted form the primary as soon as it is safe to do so?
A.
CONFIGURE ARCHIVE LOG DELETION POLICY TO APPLIED ON ALL STANDBY
B.
CONFIGURE ACHIVELOG DELETION POLICY TO APPLIED ON STANDBY;
C.
CONFIGURE ACHIVELOG DELETION POLICY TO SHIPPED TO ALL STANDBY;
D.
CONFIGURE ACHIVELOG DELETION POUCY TO SHIPPED TO STANDBY,
E.
CONFIGURE ACHIVELOG DELETION POLICY TO NONE;
Correct:
CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON *ALL* STANDBY;
C – The Snapshot Standby will not apply archive logs, but they are safe to delete as they have been shipped and saved locally.
(…) if you want to delete logs after ensuring that they shipped to all destinations, use the following configuration:
CONFIGURE ARCHIVELOG DELETION POLICY TO SHIPPED TO ALL STANDBY;
Reference:
https://docs.oracle.com/database/121/SBYDB/rman.htm#SBYDB04700
Correct Ans: A
https://docs.oracle.com/database/121/SBYDB/rman.htm#GUID-38EB0163-6F07-4F89-9A17-FC21FD779785
If you want archive logs to be deleted only after applied on mandatory standby then APPLIED ON STANDBY is correct. Here it needs to be deleted on PRIMARY after consumed appropriately on each of the standby databases so APPLIED ON ALL STANDBY.
Recommended RMAN settings for 12c:
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;
A is correct!