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)- A6% (3)
- B76% (41)
- C4% (2)
- D15% (8)
Community Discussion
No community discussion yet for this question.