You execute the command to recover your database:

You execute the command to recover your database:

You execute the command to recover your database:

A.
It restores all data files from the specified time, and then applies the redo logs.

B.
It restores all data files, redo log files, and control files, and then applies the redo logs up to the specified
time.

C.
It restores all data files and control files from the most recent backup taken before the “until time”. and then
recovers up to the “until time” using any restored archive logs that are needed to complete the task.

D.
It restores the control file and all data files from the most recent backups, and then applies the redo logs up
to the “until time”.

Explanation:

UNTIL TIME = ‘date_string’ specifies a time as an upper limit. RMAN selects only files that can be used to restore and recover up to but not including the specified time.
RMAN can perform recovery of the whole database to a specified past time, SCN, or log sequence number.
This type of recovery is sometimes called incomplete recovery because it does not completely use all of the available redo. Incomplete recovery of the whole database is also called database point-in-time recovery
(DBPITR).
DBPITR requires restoring your database from an older backup, then performing media recovery until your specified target time, SCN or log sequence number. Note that because you need your archived redo log files to perform this process, you cannot perform database point-in-time recovery if you have been running your database in NOARCHIVELOG mode.
References: https://docs.oracle.com/cd/B13789_01/server.101/b10734/rcmrecov.htm



Leave a Reply 0

Your email address will not be published. Required fields are marked *