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…

Question

Options

• ADrop the TEMP tablespace, and then re-create it with new temp files.
• BRestart the database instance to create the temp file automatically.
• CTake the TEMP tablespace offline, drop the missing temp file, and then create a new temp file.
• DAdd a new temp file to the TEMP tablespace with a new name, and then drop the temp file that is

• A
  13% (3)
• B
  78% (18)
• D
  9% (2)

Explanation

Temp files are a special class of data files that are associated only with temporary tablespaces. B: After restore and recovery of a whole database, when the database is open, missing temporary tablespaces that were recorded in the control file are re-created with their previous creation size, AUTOEXTEND, and MAXSIZE attributes. Only temporary tablespaces that are missing are re-created. If a temp file exists at the location recorded in the RMAN repository but has an invalid header, then RMAN does not re-create the temp file. If the temp files were created as Oracle-managed files, then they are re-created in the current DB_CREATE_FILE_DEST location. Otherwise, they are re-created at their previous locations. C: If a data file becomes missing or corrupted. You must take it offline before you can open the https://docs.oracle.com/database/121/ADMIN/dfiles.htm https://docs.oracle.com/database/121/BRADV/rcmcomre.htm

No community discussion yet for this question.