Which two are prerequisites for enabling Automatic Block Media Recovery in a Data Guard environment consisting of a primary database, one physical standby database and one logical standby database?
A.
FLASHBACK DATABASE must be enabled on the physical standby database.
B.
There must be connectivity between the primary and the physical standby database.
C.
FLASHBACK DATABASE must be enabled on the primary database.
D.
The physical standby database must have Real-Time Apply enabled.
E.
The logical standby database must have Real-Time Query enabled.
Flashback Database is not required to automatic recover block.
Connectivity and Real Time Query are mandatory.
Logical standby is not possible to used for this feature
Flashback may not be required: https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/rman-block-media-recovery.html#GUID-C1164158-496C-4D8A-8A06-D343935FC3B9
A. - Flashback database used, but I don't think it is a must have.
B. - TRUE
C. Flashback database used, but I don't think it is a must have.
D. - TRUE - Real time apply and Real Time Query are pre-requisites
E. - Logical standby - cannot be used
Corrupted blocks in the primary database are automatically repaired by using blocks from a physical standby database.
Corrupted blocks in the physical standby database are automatically repaired by using blocks from the primary database
Real-time query and Active Data Guard must be enabled on the physical standby database
Search for usable blocks for the recovery proceeds as follows:
1. Physical standby database
2. Flashback logs
3. Blocks in full or level 0 incremental backup
B and D are correct: https://blog.dbi-services.com/automatic-block-media-recovery-in-a-dataguard/
upvoted 1 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Rockfics
1 year, 3 months agoScottL
1 year, 3 months agoJorgeZG
1 year, 11 months agoJESUSBB
2 years, 5 months agomikom80
3 years, 2 months ago