Q105. Examine these actions:
1. Create a new database for a recovery catalog.
2. Create a tablespace with sufficient space in the catalog database for the recovery catalog.
3. Configure ARCHIVELOG mode for the catalog database.
4. Create a user to own the recovery catalog schema with quota on the tablespace that will containthe catalog.
5. Grant the RECOVERY_CATALOG_OWNER role to the recovery catalog schema owner.
6. Grant the SYSBACKUP privilege to the recovery catalog schema owner.
Which are the minimum actions that must be performed before executing the CREATE CATALOG command?
- A. 2, 4, 5, 6
- B. 1, 2, 3, 4, 5, 6
- C. 1, 2, 4, 5
- D. 2, 4, 5
- E. 1, 3, 4, 5
Answer: D
The correct answer is D. 2, 4, 5.
These are the minimum actions required to create a recovery catalog:
Create a tablespace with sufficient space in the catalog database for the recovery catalog. This is essential to store the catalog’s metadata.
Create a user to own the recovery catalog schema with quota on the tablespace that will contain the catalog. This user will manage the catalog data and permissions.
Grant the RECOVERY_CATALOG_OWNER role to the recovery catalog schema owner. This role grants the necessary privileges to create and manage the catalog.