Multiple choice

An RMAN recover catalog is to be created which stores information about the STUD database. The database should be named RCSTUD for the storage of the recovery catalog. The steps that should be followed to create a recover catalog are not displayed in the correct order. What is the correct order?

  1. Grant the appropriate privileges (CONNECT and RESOURCE) and roles (RECOVERY CATALOG OWNER) to the user responsible for performing backup and recover operations.

    2. Register the target database in the catalog.

    3. Create the catalog using the RMAN command line interpreter.

    4. Create a user and schema which will own the recovery catalog.

    5. Create tablespace to hold the catalog in the database that has been dedicated for the RMAN recovery catalog.

    6. Connect to the target database using SYSDBA privileges.

  1. 5, 4, 1, 3, 6, 2

  2. 4, 1, 5, 6, 3, 2

  3. 4, 3, 1, 5, 6, 2

  4. 4, 5, 1, 3, 2, 6

  5. 5, 4, 1, 3, 2, 6
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The correct order for creating an RMAN recovery catalog is: 5) Create tablespace first, 4) Create user/schema owner, 1) Grant necessary privileges (CONNECT, RESOURCE, RECOVERY_CATALOG_OWNER), 3) Create the catalog using RMAN, 6) Connect to target database with SYSDBA, 2) Register target database in catalog. This sequence ensures prerequisites are met before dependent steps - the tablespace must exist before creating the user, the user must exist before granting privileges, and privileges must be granted before creating the catalog.

Keep practicing — related questions