Oracle Database 12c: Installation and Administration — Question 55

Your multitenant container database, CDB1, is running in ARCHIVELOG mode and has two pluggable databases, HR_PDB and ACCOUNTS_PDB. An RMAN backup exists for the database.
You issue the command to open ACCOUNTS_PDB and find that the USERDATA.DBF data file for the default permanent tablespace USERDATA belonging to
ACCOUNTS_PDB is corrupted.
What should you do before executing the commands to restore and recover the data file in ACCOUNTS_PDB?

Answer options

• A. Place CDB1 in the mount stage and then the USERDATA tablespace offline in ACCOUNTS_PDB.
• B. Place CDB1 in the mount stage and issue the ALTER PLUGGABLE DATABASE accounts_pdb CLOSE IMMEDIATE command.
• C. Issue the ALTER PLUGGABLE DATABASE accounts_pdb RESTRICTED command.
• D. Take the USERDATA tablespace offline in ACCOUNTS_PDB.

Correct answer: D

Explanation

Taking the USERDATA tablespace offline in ACCOUNTS_PDB is necessary to ensure that no transactions or operations are being performed on the corrupted data file, which allows for a safe restoration and recovery process. The other options either do not address the need to take the tablespace offline directly or involve operations that are not essential for preparing to restore the corrupted data file.