nerdexam
Oracle

1Z0-063 · Question #203

You execute the command to recover your database: Which statement is true?

The correct answer is C. It restores all data files and control files from the most recent backup taken before the "until time". 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…

Performing Backup and Recovery

Question

You execute the command to recover your database: Which statement is true?

Exhibit

1Z0-063 question #203 exhibit

Options

  • 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
  • CIt restores all data files and control files from the most recent backup taken before the "until time".
  • DIt restores the control file and all data files from the most recent backups, and then applies the redo

How the community answered

(29 responses)
  • A
    3% (1)
  • B
    10% (3)
  • C
    79% (23)
  • D
    7% (2)

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.

Topics

#point-in-time recovery#RECOVER DATABASE#control file restore#until time

Community Discussion

No community discussion yet for this question.

Full 1Z0-063 Practice