nerdexam
Oracle

1Z0-032 · Question #48

While starting up the database on a Monday morning, you get the following error after the database is mounted: ORA-01157: cannot identify/lock data file 9-see DBWR trace file ORA-01110: data file…

The correct answer is B. V$RECOVERY_LOG. See the full explanation below for the reasoning.

Question

While starting up the database on a Monday morning, you get the following error after the database is mounted:

ORA-01157: cannot identify/lock data file 9-see DBWR trace file ORA-01110: data file 9:'/u01/oracle/app/oradata/orcl/users01.dbf' Oracle 1Z0-032 Exam While investigating, you realize that a backup of the data file (users01.dbf) exists. Which data dictionary view would you use to locate the archived redo log files that are required for recovery?

Options

  • AV$ARCHIVED_LOG
  • BV$RECOVERY_LOG
  • CV$RECOVER_FILE
  • DV$RECOVERY_STATUS

How the community answered

(54 responses)
  • A
    6% (3)
  • B
    76% (41)
  • C
    4% (2)
  • D
    15% (8)

Community Discussion

No community discussion yet for this question.

Full 1Z0-032 Practice