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.
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.
BC
a TEMP tablespace cannot be OFFLINE
D its the correct.
> BD
You can’t drop a tempfile if exist only one.
You first need add a new tempfile so then drop another.
If you try to drop a unique tempfile that exist this error will to happens
“ORA-03261: the tablespace TEMP has only one file”
if TEMP is a bigfile tablespace we cannot add datafiles
Excuse me!I meant BD.
In fact C is wrong because a TEMP tablespace cannot be OFFLINE
if TEMP is a bigfile tablespace we cannot add datafiles but it is not specified
My Answer B,D
https://docs.oracle.com/cd/B28359_01/server.111/b28310/tspaces007.htm#ADMIN11369
Note:
To use this form of the ALTER DATABASE statement, the database must be in ARCHIVELOG mode. This requirement prevents you from accidentally losing the data file, since taking the data file offline while in NOARCHIVELOG mode is likely to result in losing the file.
BD