B,E....
Not D: Block media recovery is a technique for restoring and recovering corrupt data blocks while data files are online. If only a few blocks are corrupt, then block media recovery may be preferable to data file media recovery. 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
You can use an Oracle Active Data Guard standby database for automatic repair of data corruptions detected by the primary database. Additionally if the corruption is discovered on an Active Data Guard physical standby database the corruption will be automatically repaired with a good block from the Primary.
RTQ is a feature from the Standby DB:
https://docs.oracle.com/en/database/oracle/oracle-database/19/sbydb/managing-oracle-data-guard-physical-standby-databases.html#GUID-07CB190C-C248-4FF5-AB64-EAA9C6D42677
so it cannot be C and must be B+E
I think CE
Automatic block media recovery works in two directions depending on whether the corrupted blocks are encountered on the primary or on the standby.
If corrupt data blocks are on the primary database, then the primary automatically searches for good copies of those blocks on a standby.
If corrupted block is located on the standby, the standby will automatically request uncorrupted copies of those blocks to the primary.
BE -->
https://docs.oracle.com/en/database/oracle/oracle-database/19/sbydb/managing-oracle-data-guard-physical-standby-databases.html#GUID-67B644A3-161B-4A83-A0B2-923BF51AD932
You are, absolutely, incorrect:
Block media recovery is a technique for restoring and recovering corrupt data blocks while data files are online. If only a few blocks are corrupt, then block media recovery may be preferable to data file media recovery. 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.
https://www.oracle.com/technetwork/database/availability/maa-datacorruption-bestpractices-396464.pdf
I think is DE
D for this: Automatic block repair is applicable only for physical block corruption (when the checksum is invalid, the block contains all zeros or the block header is fractured).
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.
ald85
Highly Voted 3 years, 7 months agovixt0rino
2 years, 6 months agojulica
Highly Voted 3 years, 7 months agojulica
3 years, 6 months ago_gio_
Most Recent 7 months, 3 weeks agovkra
11 months, 2 weeks agovkra
11 months, 2 weeks agohilaire
1 year agoNeil107
2 years, 6 months agoKishor123
2 years, 6 months agoMarco_M
2 years, 8 months agoRinD
2 years, 10 months agoproact
3 years, 3 months agoxRodge
2 years, 6 months agoerial
3 years, 4 months agoklever35
3 years, 7 months ago