Oracle Database 12c Advance Adminstration1z0-063 Test 3

Question : 27 of 40

Marks: +1, -0

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. (Choose two.)

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

Validate

Go to Question:

Prev Question

Next Question