In your database you discovered that a tempfile in locally managed temporary tablespace has been deleted at the operating system level. How would you recover the tablespace?

technology databases

  1. Flash back the database

  2. Perform a point-in-time recovery.

  3. Perform a full database recovery.

  4. Drop and re-create the tablespace.

  5. Use recovery manager (RMAN) to recover the database.

Show answer
Correct Option: D

AI Explanation

To recover the locally managed temporary tablespace after a tempfile has been deleted at the operating system level, the correct option is:

D. Drop and re-create the tablespace.

Explanation: When a tempfile is deleted at the operating system level, the associated locally managed temporary tablespace becomes unusable. To recover the tablespace, you need to drop and re-create it. This process involves dropping the existing tablespace and then creating a new tablespace with the same name.

Flashback the database (Option A) is not applicable in this scenario, as it is used to restore the database to a previous point in time.

Performing a point-in-time recovery (Option B) is not necessary in this case, as it is used to recover the database to a specific point in time.

Performing a full database recovery (Option C) is not required for a locally managed temporary tablespace recovery.

Using recovery manager (RMAN) to recover the database (Option E) is not applicable in this situation, as the issue is specific to the temporary tablespace.

Therefore, the correct answer is D. Drop and re-create the tablespace.

Find more quizzes: