Upgrade Oracle DBA 11g to Oracle Database 12c — Question 42

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 because taking the temporary tablespace offline allows for recovery of the missing temp file, followed by bringing it back online. Option E is also valid as creating a new temporary tablespace and assigning it as the default ensures continued functionality. The other options may not recover the existing issues effectively or could lead to further complications.