Oracle Database 12c: Advanced Administration — Question 48

A user issues a query on the sales table and receives the following error:
ERROR at line 1:
ORA-01565: error in identifying file '/u0l/app/oracle/oradata/ORCL/temp01.dbf'
ORA-27037: unable to obtain file status
Which two actions would you take to recover the temporary tablespace?

Answer options

• A. Drop the tenpOi.dbf file, and then re-create the temp file.
• B. Add a new temp file to the temporary tablespace and drop the tempOi.dbf file.
• C. Shut down the database instance, start up the database instance in mount state, create a new temporary tablespace, and then open the database.
• D. Take the temporary tablespace offline, recover the missing temp file, and then bring the temporary tablespace online.
• E. Create a new temporary tablespace and assign it as the default to the user.

Correct answer: D, E

Explanation

Option D is correct as it involves taking the temporary tablespace offline to fix the issue with the missing file and then bringing it back online after recovery. Option E is also valid as creating a new temporary tablespace and assigning it as the default for the user can help in circumventing the issue. The other options do not effectively address the problem of the missing temp file or involve unnecessary steps.