Which three are true about using an RMAN Recovery Catalog with a pluggable database (PDB) target connection in Oracle Database 19c and later releases?
(Choose three.)
Which three are true about using an RMAN Recovery Catalog with a pluggable database (PDB) target connection in Oracle Database 19c and later releases?
(Choose three.)
In Oracle Database 19c and later releases, using an RMAN Recovery Catalog with a pluggable database (PDB) target connection has specific requirements. The base catalog owner must give the Virtual Private Catalog access to metadata for one or more PDBs, which ensures that the correct access is granted for RMAN operations. Additionally, the base catalog must be enabled for Virtual Private Catalog use, which involves setting up and configuring the Virtual Private Database (VPD) functionality. Finally, the target PDB must be registered in a base catalog to allow RMAN to store and manage its metadata properly. The use of Virtual Private Catalog provides restricted access to the base recovery catalog, ensuring security and proper management of RMAN metadata.
A, B, C Tested in Lab A - True B - True C - True D - False. Not MUST. this can be done from the VPC to. E - False. Not MUST. F - False. shouldn't be in both. only in base
I think the answer should be B, C, D since "A virtual private catalog is a set of security policies that restrict user access to a subset of a base recovery catalog." therefore a target PDB "MUST BE" registered in the base catalog, but it's optional to register a target PDB in Virtual private catalog to achieve separation of duties among dbas. https://docs.oracle.com/en/database/oracle/oracle-database/19/rcmrf/CREATE-CATALOG.html#GUID-9CFE47C7-2273-48C4-8056-6A4042AF3CDC
ADE correct https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/managing-recovery-catalog.html#GUID-A7502D0D-5840-4B13-869D-7259F2D73119 A base recovery catalog is a database schema that contains RMAN metadata for a set of target databases. A virtual private catalog is a set of security policies that restrict user access to a subset of a base recovery catalog.
You have to register the PDB in a Virtual Private Catalog if you are going to use it. It uses is not mandatory. I think B C D
A. TRUE - Base catalog Owner must give access to metadata through "GRANT CATALOG FOR DATABASE" command to the VPC owner. "After you set up a virtual private catalog user, the administrator for the recovery catalog grants each virtual private catalog the privilege to use that catalog for one or more databases that are currently registered in the recovery catalog." The catalog owner receive access to the metadata for the PDBs which they manage. B. TRUE - By definition of a Virtual Private Catalog "A subset of the metadata in a base recovery catalog to which a database user is granted access. The owner of a base recovery catalog can grant or revoke restricted access to the recovery catalog to other database users. Each restricted user has full read/write access to his own virtual private catalog." C. TRUE - If a target database is not registered in the recovery catalog, then RMAN cannot use the catalog to store metadata for operations on this database. You can still perform RMAN operations on an unregistered database: RMAN always stores its metadata in the control file of the target database.
A is true: "You can also use a DBID rather than a database name. The virtual private catalog user does not have access to the metadata for any other databases registered in the recovery catalog." B is false: "Enable the VPD model for the recovery catalog by running" C is true: "Assume that the following databases are registered in the base recovery catalog: prod1, prod2, and prod3." D is false: RMAN uses control file. E is true: "To store backup metadata for a target database in a virtual private catalog, you must register the database with the virtual private catalog." F is false: Must be registered in both, I think it can be registered just in base catalog too.
I'm not sure.. I read again and I think ABF can be the right answer. https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/managing-recovery-catalog.html#GUID-02705BC0-92FA-4616-B6B0-1E71E86010E4
C is right E is wrong After you set up a virtual private catalog user, the administrator for the recovery catalog grants each virtual private catalog the privilege to use that catalog for one or more databases that are currently registered in the recovery catalog. The administrator of the recovery catalog can also grant the privilege to register new databases while using a virtual private catalog.
I think it's ADE.
Looks like its A D E
ACE Not B (enable base catalog) RMAN uses the Virtual Private Database (VPD) functionality to implement virtual private catalogs. The VPD functionality is not enabled by default when the RMAN base recovery catalog is created. You need to explicitly enable the VPD model for a base recovery catalog by running the $ORACLE_HOME/rdbms/admin/dbmsrmanvpc.sql script after upgrading the base catalog schema. E is okay - 13.5.4 Registering a Database with a Virtual Private Catalog To store backup metadata for a target database in a virtual private catalog, you must register the database with the virtual private catalog. https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/managing-recovery-catalog.html#GUID-DA362C55-5B94-4AB8-A8A1-163BF08FE594
Change to ABC is correct
A, C and E https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/managing-recovery-catalog.html#GUID-B3238BE0-F52D-4773-A277-D3627AE28D57 NOT B: The Virtual Private Database must be enabled to use VPC. The base catalog is created with the RMAN CREATE CATALOG command. NOT D: Is a "can" not "must" NOT F: The VPC owner connects to the base catalog and the target database and issue the command REGISTER DATABASE