Oracle Exam 1Z0-063 Topic 5 Question 22 Discussion

Actual exam question for Oracle's 1Z0-063 exam

Question #: 22
Topic #: 5

You execute the command to recover your database:

Which statement is true?

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

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

CIt 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.

DIt restores the control file and all data files from the most recent backups, and then applies the redo logs up to the ''until time''.

Show Suggested Answer

Suggested Answer: C

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

by Lynelle at May 06, 2022, 09:50 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-063 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!