A, C, F
By default , RMAN searches the flashback logs for good copies of the blocks, and then searches for the blocks in full or level 0 incremental backups. You could use the EXCLUDE FLASHBACK LOG option to restrict RMAN from searching the flashback logs. (Not B).
A, C main features
You can perform block recovery only on blocks that are marked corrupt or fail a corruption check (Not D)
The target database must run in ARCHIVELOG mode and be open or mounted with a current control file (Not E).
F is false: Block media recovery may not be able to repair all logical block corruptions.
https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/rman-block-media-recovery.html#GUID-BBD0093C-AC8D-490C-868C-FB5F83CB0870
A: TRUE
B: Can be executed even without flashback (altough it is faster with it)
C: TRUE
D: It can but will do nothing!
E: Can run on all states
F: It can but not all
I think ABC
B - Flashback Database must be enabled on the target database for RMAN to search the flashback logs for good copies of corrupt blocks.
https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/rman-block-media-recovery.html#GUID-21EFB177-2AC7-457C-80A0-63B11A80CD0B:~:text=Flashback%20Database%20must%20be%20enabled%20on%20the%20target%20database%20for%20RMAN%20to%20search%20the%20flashback%20logs%20for%20good%20copies%20of%20corrupt%20blocks.
F is not correct - it can but not 100% - Block media recovery may not be able to repair all logical block corruptions. In these cases, alternate recovery methods, such as tablespace point-in-time recovery, or dropping and re-creating the affected objects, may repair the corruption.
This is why I think C is correct - With block media recovery, only the blocks actually being recovered are unavailable during the recovery. https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/rman-block-media-recovery.html#GUID-83CB3821-DCA8-459E-8038-CBD4D581A225:~:text=With%20block%20media%20recovery%2C%20only%20the%20blocks%20actually%20being%20recovered%20are%20unavailable%20during%20the%20recovery.
A, B, C (C is correct not F)
after documentation:
https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/rman-block-media-recovery.html
...Block media recovery MAY NOT BE ABLE TO REPAIR ALL ...BUT SOME CAN , IT'S NOT EQUAL TO "It cannot repair ... (F)" logical block corruptions... so definetlly F=WRONG ANSWER.
A. and C. - Without block media recovery, if even a single block is corrupt, then you must take the data file offline and restore a backup of the data file. You must apply all redo generated for the data file after the backup was created. The entire file is unavailable until media recovery completes. With block media recovery, only the blocks actually being recovered are unavailable during the recovery.
https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/rman-block-media-recovery.html#GUID-83CB3821-DCA8-459E-8038-CBD4D581A225
B. Flashback Database must be enabled on the target database for RMAN to search the flashback logs for good copies of corrupt blocks.
https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/rman-block-media-recovery.html#GUID-C1164158-496C-4D8A-8A06-D343935FC3B9
A. TRUE Block media recovery "Enables affected data files to remain online during recovery"
https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/rman-block-media-recovery.html#GUID-83CB3821-DCA8-459E-8038-CBD4D581A225
B. TRUE, Prerequisites for Block Media Recovery: "Flashback Database must be enabled on the target database for RMAN to search the flashback logs for good copies of corrupt blocks."
https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/rman-block-media-recovery.html#GUID-C1164158-496C-4D8A-8A06-D343935FC3B9
C. TRUE, Prerequisites for Block Media Recovery: "With block media recovery, only the blocks actually being recovered are unavailable during the recovery."
D E F are wrong.
F, "Block media recovery may not be able to repair all logical block corruptions."
E, OPEN or MOUNTED "The target database for which one or more blocks are to be recovered must be in the OPEN state."
ABC
Flashback Database must be enabled on the target database for RMAN to search the flashback logs for good copies of corrupt blocks.
https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/rman-block-media-recovery.html#GUID-C1164158-496C-4D8A-8A06-D343935FC3B9
ACD
https://docs.oracle.com/database/121/BRADV/rcmblock.htm#BRADV118
Logical corruption
The block has a valid checksum, the header and footer match, and so on, but the contents are logically inconsistent. Block media recovery may not be able to repair all logical block corruptions. In these cases, alternate recovery methods, such as tablespace point-in-time recovery, or dropping and re-creating the affected objects, may repair the corruption.
I think answer D is wrong. https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/rman-block-media-recovery.html#GUID-69B1C218-A199-4993-AC71-C87FE0376E32
paragraph 19.1.2: Basic concepts of Block Media Recovery
... hen writes it to disk when the corruption is first encountered. No subsequent read of the block is successful until the block is recovered. You can perform block recovery only on blocks that are marked corrupt or that fail a corruption check....
ABC
B is true because, on the prerequisites, oracle told us that we need have flashback database enabled : https://docs.oracle.com/database/121/BRADV/rcmblock.htm#BRADV89785
And in this note say:
"Block media recovery may not be able to repair all logical block corruptions"
So F is false, because LBC can repair logical corruption, but not always.
Not B
Flashback Database must be enabled on the target database for RMAN to search the flashback logs for good copies of corrupt blocks.
If flashback logging is enabled and contains older, uncorrupted versions of the corrupt blocks, then RMAN can use these blocks, possibly speeding up the recovery.
flashback is NOT mandatory
only >> possibly speeding up the recovery
Agree with you.
Flashback Database must be enabled on the target database for RMAN to search the flashback logs for good copies of corrupt blocks.
https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/rman-block-media-recovery.html#GUID-21EFB177-2AC7-457C-80A0-63B11A80CD0B
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.
mporislav
Highly Voted 3 years, 8 months agomd1994
2 years, 4 months agoRinD
Highly Voted 3 years, 8 months agoSoiram
Most Recent 4 months, 3 weeks agoantonica
10 months, 1 week agodancymonkey
1 year agodancymonkey
1 year agozimwish
1 year agoflaviogcmelo
1 year, 3 months agomusafir
1 year, 4 months ago_gio_
1 year, 6 months agovkra
1 year, 11 months agojackymak
2 years agojackymak
1 year, 9 months agoManojx
2 years, 4 months agoErikJanssen
1 year, 11 months agoTrololoshko
2 years, 6 months agofreemun05
2 years, 10 months agoLlamonica
3 years, 2 months agoLlamonica
3 years, 2 months agoegore0496
3 years agovnhoang76
3 years, 2 months agosmartvan
3 years, 3 months agoNeil107
3 years, 5 months ago