Oracle Exam 1Z0-066 Topic 10 Question 28 Discussion

Actual exam question for Oracle's 1Z0-066 exam

Question #: 28
Topic #: 10

Which three are true concerning Automatic Block Media Recovery in a Data Guard environment when running an application as an ordinary Oracle user? (Choose three.)

AReal Time Query must be enabled on the primary database.

BReal Time Query must be enabled on the physical standby database.

CIf a physically corrupt block is discovered on a physical standby database, then a valid block image from the primary database is retrieved.

DIf a physically corrupt block is discovered on the primary database, then a valid block image from a physical standby database is retrieved.

EIf a physically corrupt block is discovered on a logical standby database, then a valid block image from the primary database is retrieved.

FIf a physically corrupt block is discovered on a primary database, then a valid block image from the logically standby database is retrieved.

Show Suggested Answer

Suggested Answer: B, C, D

B: For automatic block media recovery to work, a physical standby database must be in real-time query mode, which requires an Oracle Active Data Guard license.

D: A physical standby database operating in real-time query mode can be used to repair corrupt data blocks in a primary database.

C: If corruption occurs on the primary database, blockmedia recovery is performed automatically using a good copy of the block from the standby database and vice versa.

References:

https://ora600tom.wordpress.com/2013/09/07/abmr-automatic-block-media-recovery/

by Emerson at May 07, 2022, 07:00 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-066 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!