Oracle Database Administration II — Question 121

Which three are true about recovery operations done without using Recovery Manager (RMAN)? (Choose three.)

Answer options

• A. A lost SPFILE can be recovered from memory using SQL*PLUS.
• B. A lost password file can be re-created with SQL*PLUS.
• C. A lost TEMPFILE must always be re-created manually.
• D. A lost password file can be manually re-created with the orapwd utility.
• E. A lost PFILE can be re-created alert.log using SQL*PLUS.
• F. A lost index tablespace can be re-created without performing any recovery.

Correct answer: A, D, F

Explanation

Option A is correct because an SPFILE can indeed be reconstructed from the memory of the database. Option D is also correct as the orapwd utility allows for the manual recreation of a lost password file. Option F is valid since a lost index tablespace can be recreated without recovery. The other options are incorrect as they misrepresent the recovery processes for the respective files.