Which statement is true regarding a Recovery Manager (RMAN) incomplete database recovery using UNTIL SEQUENCE?

The correct answer is B. RMAN will restore data files from the most appropriate backup, and then recover them up to the. See the full explanation below for the reasoning.

Question

Options

ARMAN will reset the current sequence number to the number specified.
BRMAN will restore data files from the most appropriate backup, and then recover them up to the
CRMAN will ignore the number specified if the THREAD option is not specified and continue the normal
DRMAN will restore the data files up to the sequence number specified, from the most appropriate backup

How the community answered

(36 responses)

A
3% (1)
B
81% (29)
C
11% (4)
D
6% (2)

Community Discussion

Yusuf A.Mar 19, 2026

Answer is B, and this one tripped me up until my senior walked me through it on a test restore last month. RMAN does two separate jobs here: first it picks the most appropriate backup to restore the data files from, then it rolls them forward by applying archived redo logs up to the sequence you specified. D looks tempting but it gets the order backwards, implying the backup itself goes up to that sequence, which is not how point-in-time recovery works at all. And just to head off C, RMAN does not ignore the sequence number if you leave out the THREAD option, it just defaults to thread 1, so the recovery still stops where you told it to.

Ingrid P.Mar 20, 2026

The thread-1 default is worth a card of its own because RAC candidates consistently blank on it under pressure.

Toby R.Feb 16, 2026

Saw this almost word for word, picked B because RMAN does restore then recover, not just one or the other. Almost talked myself into D but D leaves out the recovery piece, which is the whole point of the command.

Yusuf A.Feb 17, 2026

Good catch on D, and that tripped me up too until my senior explained that restore just puts the physical files back while recover is what actually rolls forward through the archived logs to get you to a consistent state, so skipping recover would leave the database unusable.

Prof. SaraMar 2, 2026

Does RMAN restore AND recover separately, or collapse both into one step?

Ingrid P.Mar 21, 2026

Saw this one on my actual exam and almost went with D, but I had a card specifically noting that UNTIL SEQUENCE triggers both a restore from the best available backup and a full recovery up to that log sequence, not just the restore step, so B was the only one that captured the two-phase process. Made a second card after the exam flagging D as the classic distractor because "restore up to" sounds close enough to trip you if your interval on this fact has gone stale.

Lena V.Feb 28, 2026

Option B is the one, but pay attention to how D is written because it trips people up every cycle. D says RMAN restores data files "up to the sequence number specified," which mashes restore and recover into one step and implies the backup itself is bounded by that sequence, neither of which is accurate. What actually happens is RMAN picks the most appropriate backup (the one that gets you closest without going past the target point), restores the data files from it, and then applies archived redo logs during the recover phase until it hits the UNTIL SEQUENCE boundary. On the thread question in option C, THREAD defaults to 1 in a single-instance environment, so skipping it does not cause RMAN to ignore your sequence number, it just assumes thread 1, making C a nonsense distractor. Land on B, understand the two-phase mechanic (restore then recover), and do not let D's surface-level similarity steal your point.

Yusuf A.Mar 2, 2026

The two-phase point is the one I keep having to drill into my head, and what helped me finally get it straight was when my senior told me to think of restore as "putting the files back on disk" and recover as "replaying the logs forward," so D tripping people up makes sense because it collapses that gap into a single action that RMAN never actually does in one shot.

Full 1Z0-032 Practice