Which components are needed for successful and most efficient recovery.

A.
The backup RB3 and the current online redo log files

B.
the backup RB2 and the archived redo log files after the log sequence number 15622

C.
Backup R81 and the archived redo log hies after the log sequence number 12871

D.
The backup RB3 and the archived redo log files after the log sequence number 16721

Show Hint

← Previous question

Next question →

EncinoM

Question is incomplete and answer is wrong.

Full question:

You want the ability to recover to any time within the last seven days and therefore you configured the recovery window retention policy using the command:

RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;

After configuring the recovery window, you performed the database backup as follows:
– Backup RB1 at log sequence number 12871 on 5th Jan
– Backup RB2 at log sequence number 15622 on 12th Jan
– Backup RB3 at log sequence number 16721 on 15th Jan

On 20th Jan when the log sequence number was 18112 you realize that there is a need to recover to a point in time at the beginning of the recovery window. You have all archived redo log files to date.

Which components are needed for successful and most efficient recovery?

Answer: D

Explanation:

20th jan -7days of recovery window give us 13 jan ( RB2 at this time could be deleted ) so we have to use RB3

Got it from another exam with same question and same choice of answers.

Anonim

You’re wrong. RB2 backup will not be obsolete (or deleted).
Recovery window setting of 7 days mean that it’s possible to perform point in time recovery in the timeframe between sysdate-7 and sysdate.

Norberto

I also vote to RB2+archivelogs (answer B), on Jan 13 RB2 wont be deleted because its needed to keep up with the recovery window.

Baris Coskun

Exactly and Clearly B is correct RB2 will not be obsolete.

Because İf you want to backup PITR forexample 20-7=13 13Jan or 14 Jan you can not use backup database of 15 Jan in order to restore database.