In your database, you discovered that a tempfile in a locally managed temporary tablespace has
been deleted at the operating system level. How would you recover the tablespace?
A.
flash back the database
B.
perform point-in-time recovery
C.
perform a full database recovery
D.
drop and re-create the tablespace
E.
use Recovery Manager (RMAN) to recover the database
Answer B
this is the best answer available here, however it is not the best solution to this problem.
When an instance is started and a temp file is missing, it is created automatically and a message placed in the alert file.
If a tempfile is damaged while the database is open, the database will also remain OPEN.
It only becomes apparent that a file is missing when somebody attempts to use it, because of insufficient space in the session’s PGA. it will be reported in the alert log. To fix it add another tempfile to the temporary tablespace and drop the original:
ALTER TABLESPACE TEMP ADD TEMPFILE ‘/u01/app/oracle/oradata/orcl/temp02.dbf’ size 500m;
ALTER TABLESPACE TEMP DROP TEMPFILE ‘/u01/app/oracle/oradata/orcl/temp01.dbf’;
Peace to all
pardon me, the correct answer here is D
tempfile on temp TB was gone => recreate the temp TB