Oracle Database 12c: Advanced Administration — Question 5

You regularly take backups of your database using RMAN with a recovery catalog. Your database is currently open and the temp01.dbf temp file belonging to the TEMP tablespace is corrupted.
Identify two methods to recover the temp file with the least disruption to database availability.

Answer options

• A. Drop the TEMP tablespace, and then re-create it with new temp files.
• B. Restart the database instance to create the temp file automatically.
• C. Take the TEMP tablespace offline, drop the missing temp file, and then create a new temp file.
• D. Add a new temp file to the TEMP tablespace with a new name, and then drop the temp file that is corrupted.

Correct answer: B, C

Explanation

Option B is correct because restarting the database instance will automatically recreate the temp file without affecting availability significantly. Option C is also correct as taking the TEMP tablespace offline allows for the removal of the corrupted temp file and the creation of a new one with minimal disruption. Options A and D are incorrect because dropping and recreating the TEMP tablespace or adding a new file and dropping the corrupted one could lead to more complex issues and longer downtime.