Examine this command:
SQL> CREATE PLUGGABLE DATABASE pdb3 FROM pdb1;
Which three conditions must be true for successful execution of this command on a RAC database? (Choose three.)
Examine this command:
SQL> CREATE PLUGGABLE DATABASE pdb3 FROM pdb1;
Which three conditions must be true for successful execution of this command on a RAC database? (Choose three.)
For the successful execution of the command to create a pluggable database from another on a RAC database, several conditions must be met: The source PDB must be in READ ONLY mode on all CDB instances if the CDB is in No Archive mode to ensure data consistency. The command can be executed only by a common user with the CREATE PLUGGABLE DATABASE system privilege connected to the root container, as this user has the necessary permissions to perform the operation. Lastly, Oracle Managed Files must be enabled or PDB_FILE_NAME_CONVERT must be set to handle file location configurations for the new PDB. The other options are either incorrect or not necessary for this specific operation.
Sure of BDE
BDE is correct
The given answer is incorrect. BDE is correct. A is incorrect, documentation states: "The source PDB cannot be closed." C is incorrect, as the TEMP tablespace does not matter to this operation F is incorrect, as it would be insane to require a production DB to be in restricted mode in order to clone it. From documentation: B: "If the CDB is not in ARCHIVELOG mode, then the source PDB must be in open read-only mode. This requirement does not apply if the CDB is in ARCHIVELOG mode." D: "The current user must have the CREATE PLUGGABLE DATABASE system privilege in both the root and the source PDB." E: "Either Oracle Managed Files is enabled, or the PDB_FILE_NAME_CONVERT initialization parameter is set." Reference: https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/cloning-a-pdb.html