Question 3
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?
CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY;
CONFIGURE ACHIVELOG DELETION POLICY TO APPLIED ON STANDBY;
CONFIGURE ACHIVELOG DELETION POLICY TO SHIPPED TO ALL STANDBY;
CONFIGURE ACHIVELOG DELETION POLICY TO SHIPPED TO STANDBY;
CONFIGURE ACHIVELOG DELETION POLICY TO NONE;
Correct answer: B
Explanation:
You can change this default deletion policy using the following RMAN command:CONFIGURE ARCHIVELOG DELETION POLICY TO [CLEAR | NONE | APPLIED ON STANDBY]; Use the APPLIED ON STANDBY clause so that archived redo log files that have been applied on all mandatory standby destinations will be deleted. Incorrect Answers:A: APPLIED ON ALL STANDBY is not valid.C, D: SHIPPED TO is not valid.E: Use the NONE clause so that archived redo logs in flash recovery area that were backed up or obsolete as per the RMAN retention policy are eligible for deletion. This is the default configuration. Archived redo log files that are backed up or obsolete are deleted to make space if the disk space in the flash recovery area becomes full.References: https://docs.oracle.com/cd/B19306_01/server.102/b14239/rman.htm#i1031870
You can change this default deletion policy using the following RMAN command:
CONFIGURE ARCHIVELOG DELETION POLICY TO [CLEAR | NONE | APPLIED ON STANDBY];
Use the APPLIED ON STANDBY clause so that archived redo log files that have been applied on all mandatory standby destinations will be deleted.
Incorrect Answers:
A: APPLIED ON ALL STANDBY is not valid.
C, D: SHIPPED TO is not valid.
E: Use the NONE clause so that archived redo logs in flash recovery area that were backed up or obsolete as per the RMAN retention policy are eligible for deletion. This is the default configuration. Archived redo log files that are backed up or obsolete are deleted to make space if the disk space in the flash recovery area becomes full.
References: https://docs.oracle.com/cd/B19306_01/server.102/b14239/rman.htm#i1031870