1z0-083 Exam - Question 54

Question

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 contain the 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?

Examice · Accepted Answer

To execute the CREATE CATALOG command, you must first create a database to store the recovery catalog (step 1). Then, you create a tablespace with sufficient space for the catalog (step 2). You also need to create a user who will own the recovery catalog schema and assign quota on the created tablespace (step 4). Finally, you must grant the RECOVERY_CATALOG_OWNER role to this user (step 5). Configuring ARCHIVELOG mode and granting the SYSBACKUP privilege are not necessary steps for creating the catalog. Therefore, the minimum actions required are steps 1, 2, 4, and 5.

Apollo5 · Answer

D is the right answer. 
Step No 2 is required, so it must be contained in the choise
Step 1 is optional
Step 3 is not necessary
Steps 4 & 5 are required
Step 6 is not necessary

asefa · Answer

D is the minimum actions that must be performed before executing create catalog command

Rogazan · Answer

I agree with option D (minimum of actions), but if Oracle asks me in the exam, I will answer that the correct option is C. This confirms that we know that the Catalog Database must be a different one which we want to protect!

janw · Answer

agree with d, only 4&5 really required.

julica · Answer

Oly D is correct am minimal steps.

pgtips · Answer

I believe, E,  as the Option 1:  Create a new Database is one of the Choice I go for E.  If it was not there then probably D makes more sense.

Jatindra · Answer

Correct Ans: D

niabs · Answer

I will choose C
Because likely you will create a dedicated database for the catalog unless you already have a separated one, which is not mentioned here

smartvan · Answer

This is all you need to create the catalog. tested SQL> CREATE USER restoretests IDENTIFIED BY oracle >>>>>> create user(4) DEFAULT TABLESPACE tools >>>>>>>>>> create tablespace (2) TEMPORARY TABLESPACE temp QUOTA UNLIMITED ON tools; SQL> GRANT CONNECT, RECOVERY_CATALOG_OWNER TO ; >>> grant privilege (5) $ rman target / catalog /@ (instance name) select instance_name from v$instance; RMAN> create catalog; correct answer is D

senator · Answer

D is the correct answer when reading both 12c and 19c oracle docs.
https://docs.oracle.com/en/database/oracle/oracle-database/19/rcmrf/CREATE-CATALOG.html#GUID-9CFE47C7-2273-48C4-8056-6A4042AF3CDC
Examples

Example 2-70 Creating a Recovery Catalog and Registering a Database

Assume that you start SQL*Plus and connect to the recovery catalog catdb with administrator privileges. You execute the CREATE USER statement as follows, replacing password with a user-specified password (see Oracle Database Security Guide for information on creating secure passwords). The SQL statement creates a user rco in database catdb and grant the rco user the RECOVERY_CATALOG_OWNER role.

SQL> CREATE USER rco IDENTIFIED BY password
  2  DEFAULT TABLESPACE cattbs
  3  QUOTA UNLIMITED ON cattbs;
SQL> GRANT recovery_catalog_owner TO rco;
SQL> EXIT

Nonicknameavailable · Answer

Correct answer is C. 
The question gives a sequence of steps and asks you to examine the minimum options in that sequence. It does not tell you a database already exists.

klever35 · Answer

Correct Answer  E

vkra · Answer

I would say C too

ScottL · Answer

D - see Apollo5

_gio_ · Answer

I agree with Apollo5. Recovery catalog is a schema that can be contained in any existing DB

Guhborges · Answer

2-4-5 letter D is Right.

1 is wrong, cause you don't necessary need a new database to be the catalog. :)

1z0-083 Exam - Question 54

Discussion