Exam 1z0-066 All QuestionsBrowse all questions from this exam
Go to Exam
Question 15

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?

    Correct Answer: B

    To ensure that archived logs generated on the primary database are not deleted until they are safely applied to the mandatory standby database, the correct configuration is 'CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY'. This policy means that the logs can be deleted from the primary database once they have been applied to any mandatory standby database, ensuring data integrity and consistency. The other options either do not apply to the given scenario or are not valid commands.

Discussion
kemsalimOption: A

A is correct, https://support.oracle.com/knowledge/Oracle%20Database%20Products/1324759_1.html

hilaireOption: A

A is correct http://blog.data-alchemy.org/tips/oracle-rman-deletion/

ucdongmoOption: C

I think C is correct. We do not need to apply archived logs. Redo apply read directly from standby redo and apply. In this case archived logs are not applied by standby are in sync. I think if archived logs are shipped to all standby, they can be deleted from Primary.

JESUSBBOption: A

Answer: A

SugarOption: A

i agree A is correct

Sugar

regardless of whether only one standby is mandatory or not, it should still be APPLIED to all standby databases

SaguSe7en

Correct. Agreed with Kamaelk

Kamaelk

I was wrong, key word is "mandatory destination". If make standby db mandatory destination, set deletion policy work well: RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY; old RMAN configuration parameters: CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY; new RMAN configuration parameters: CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY; new RMAN configuration parameters are successfully stored RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY; old RMAN configuration parameters: CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY; new RMAN configuration parameters: CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY; new RMAN configuration parameters are successfully stored

ra2020

I'm agree, the keyword is "mandatory"

KamaelkOption: A

B is wrong. Right answer is A. RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY; new RMAN configuration parameters: CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY; new RMAN configuration parameters are successfully stored RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY; old RMAN configuration parameters: CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY; new RMAN configuration parameters: CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY; new RMAN configuration parameters are successfully stored RMAN-08591: warning: invalid archived log deletion policy