A container database called CDB1 is OMF-enabled. PDB_FILE_NAME_CONVERT is not configured in CDB1. PDB1 was unplugged from CDB1 earlier in the week. Examine this command, which will be executed in…

Question

Options

• APDB1 data files already exist in the correct location.
• BDBMS_PDB.CHECK_PLUG_COMPATIBILITY must be run in CDB1 before executing the
• CPDB_FILE_NAME_CONVERT must be set before executing the command.
• D/u01/app/oracle/oradata/pdb1.xml does not contain the current locations of data files for PDB1.
• EPDB1 must be dropped from CDB1.

• A
  11% (2)
• B
  5% (1)
• D
  84% (16)

Explanation

The question gives the impression that the source files were held at /u01/app/oracle/oradata, but are now physically located at /u01/app/oracle/oradata. The xml description file is still at /u01/app/oracle/oradata/pdb1.xml A: FALSE - SOURCE_FILE_NAME_CONVERT is only needed if the XML file does not accurately describe the current location of the pdb's files. B: FALSE - If pdb1 ran correctly before, it will run correctly now - assuming that no major upgrade of CDB1 has happened. C: FALSE - PDB_FILE_NAME_CONVERT is needed only when OMF is not used. The question tells us that OMF is enabled. D: TRUE - The use of the SOURCE_FILE_NAME_CONVERT parameter indicates that the DB files have been moved, so the xml file does not hold the correct locations E: TRUE - Unplugging a database will result in the PDB remaining in a MOUNT state. It is still part of the CDB and will still be backed up etc... After unplugging, a PDB needs to be dropped before a new PDB can be created with the same name.

No community discussion yet for this question.