nerdexam
Oracle

1Z0-083 · Question #2

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…

The correct answer is D. 2, 4, 5. https://docs.oracle.com/en/database/oracle/oracle-database/19/rcmrf/CREATE- CATALOG.html#GUID-9CFE47C7-2273-48C4-8056-6A4042AF3CDC 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…

Configure for Recoverability

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?

Options

  • A2, 4, 5, 6
  • B1, 2, 3, 4, 5, 6
  • C1, 2, 4, 5
  • D2, 4, 5
  • E1, 3, 4, 5

How the community answered

(28 responses)
  • A
    11% (3)
  • B
    4% (1)
  • D
    82% (23)
  • E
    4% (1)

Explanation

https://docs.oracle.com/en/database/oracle/oracle-database/19/rcmrf/CREATE- CATALOG.html#GUID-9CFE47C7-2273-48C4-8056-6A4042AF3CDC 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;

Topics

#recovery catalog#CREATE CATALOG#RECOVERY_CATALOG_OWNER#RMAN setup

Community Discussion

No community discussion yet for this question.

Full 1Z0-083 Practice