Create a catalog Database

Welcome to the Oracle community forum, and interact with 2 million technical staff to create catalog Step 1: Create a recovery directory user Step 1: create a separate tablespace catalog_tbs for the recovery directory, create a recovery directory user createuserrcat_useridentifiedbyrcat_passworddefaulttablespacecatalo

Welcome to the Oracle community forum and interact with 2 million technical staff> go to step 1 of creating catalog: Create a recovery directory user Step 1: Create a tablespace catalog_tbs separately for the recovery directory, create user rcat_user identified by rcat_password default tablespace catalog_tbs; ste

Welcome to the Oracle community forum and interact with 2 million technical staff> enter

Create catalog

Step 1: Create a recovery directory user

Step 1: Create a tablespace catalog_tbs separately for the recovery directory,

Create user rcat_user identified by rcat_password default tablespace catalog_tbs;

Step 2: Assign the following roles to the recovery directory

Connect

Resource

Recovery_catalog_owner

GRANT connect, resource, recovery_catalog_owner TO rcat_user;

Step 2: create a directory recovery object

Step 1: Restore the directory using RMAN connection

RMAN

Catalog = rcat_user/rcat_password

Step 2: Execute the create catalog command at the RMAN prompt

Create catalog tablespace catalog_tbs;

Step 3: register the database in the recovery directory

Step 1: Use RMAN to connect to the database at the same time and restore the Directory

Set ORACLE_SID = main_db

RMAN target = backup_admin/backupuserpassword

Catalog = rcat_user/rcat_password @ recover

Step 2: Use the recovery directory to register a database

RMAN> Register database;

Rman catalog, unregister the target database

Step 1: Go to the database to unregister and obtain the DBID of the database

SQL> select dbid from v $ database;

DBID

2539725638

Step 2: connect to the mode with the recovery directory, and determine the DB_KEY of the database in the recovery directory.

SQL> select db_key from db where db_id = 2539725638

DB_KEY

1

Step 3: Use dbms_rcvcat.unregisterdatabase to cancel database registration from the recovery directory

Exec dbms_rcvcat.unregisterdatabase (1, 2521325638)