1Z0-032 · Question #16
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 A. update the control file by using the ALTER DATABASE RENAME FILE command B. restore the data file from the backup to the new location by using an operating system utility. 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' On investigation, you find that the file system, u01, on the operating system is corrupted and you need to recover the data file to a new location. The database is running in ARCHIVELOG mode and the database was backed up on last Friday. You must ensure that the database is not accessible till the data file is recovered. Which two tasks must you have accomplished before applying the archived redo log files? (Choose two.)
Options
- Aupdate the control file by using the ALTER DATABASE RENAME FILE command
- Brestore the data file from the backup to the new location by using an operating system utility
- Crestore a backup control file and then issue the ALTER DATABASE RENAME FILE command
- Ddrop the data file and re-create it by using the ALTER DATABASE CREATE DATAFILE command
- Erecreate the control file by using the ALTER DATABASE BACKUP CONTROLFILE TO TRACE command
How the community answered
(52 responses)- A83% (43)
- C2% (1)
- D6% (3)
- E10% (5)
Community Discussion
No community discussion yet for this question.