1Z0-063 · Question #204
You need to perform a block media recovery on the tools01.dbf data file in your database by using Recovery Manager (RMAN). Which two are prerequisites for performing this operation?
The correct answer is C. You must ensure that the database is mounted or open. D. You must have full or level-0 backups to restore blocks. The target database must run in ARCHIVELOG mode and be open or mounted with a current The backups of the data files containing the corrupt blocks must be full or level 0 backups. They cannot be proxy copies or incremental backups. 2017), page 19-4
Question
Options
- AYou must configure a block change tracking file.
- BYou must use an incremental level-1 backup to restore blocks.
- CYou must ensure that the database is mounted or open.
- DYou must have full or level-0 backups to restore blocks.
- EYou must take the tools01.dbf data file offline.
How the community answered
(21 responses)- A14% (3)
- B5% (1)
- C71% (15)
- E10% (2)
Explanation
The target database must run in ARCHIVELOG mode and be open or mounted with a current The backups of the data files containing the corrupt blocks must be full or level 0 backups. They cannot be proxy copies or incremental backups. 2017), page 19-4
Topics
Community Discussion
7
Luis F.Nov 14, 2025The correct answers are C and D, and here is why they both make sense together. Block media recovery is one of the cooler RMAN features because it lets you fix only the corrupted blocks instead of restoring a whole datafile, but it does require the database to be mounted or open (C) because RMAN needs to apply redo logs to bring those blocks forward after restoring them, and that process needs the database up. You also need a full backup or level-0 incremental backup available (D) because that is what RMAN pulls the clean copy of the corrupted blocks from, there is no way around that base backup requirement. A is wrong because block change tracking just helps incremental backups run faster, it has nothing to do with recovery prerequisites. B flips the logic around, you do not have to use a level-1 backup, the level-0 or full backup is what is required. And E is the trap answer because one of the whole points of block media recovery is that you do NOT have to take the file offline, the datafile stays online the entire time which is a big win over traditional recovery. Good luck on the exam, this one tripped me up the first time I read it too.
Toby R.Oct 16, 2025C and D are correct. The database has to be mounted or open for block media recovery, you cannot do it in nomount, and RMAN needs a full or level-0 backup as the base to restore the corrupted blocks from, incremental level-1 alone is not enough to start from.
Carlos M.Nov 2, 2025Thought C was obvious but almost picked B over D, then remembered block media recovery needs a base backup, not just incremental.
Samuel O.Nov 5, 2025Good catch on the base backup requirement, though worth noting that for block media recovery specifically, the base backup has to be a consistent image taken while the database was either shut down cleanly or via RMAN, not just any filesystem snapshot you pulled while the instance was up.
Samuel O.Oct 25, 2025C and D are right, the file stays online and you need that base backup.
Ola B.Nov 18, 2025Taking the datafile offline is non-negotiable before block media recovery, same as any media recovery scenario, and I have always had to do that in my lab before RMAN would even let me proceed. I am also going with D because you need that full or level-0 baseline for RMAN to have something to restore the corrupted blocks from.
Samuel O.Nov 21, 2025Ola, block media recovery is actually one of the cases where the datafile stays online and the database keeps running, which is the whole point of that feature. And you do need the level-0 or full backup as your base, so D is correct, but the datafile does not come offline, making C the right pick alongside D.