Oracle 19c | RMAN Recovery Catalog Database Creation Step by Step | Registering Database to Catalog!

December 26, 2020  

 

Dear DBA Connections,

In this video demonstrated how to create RMAN Recovery Catalog Database Creation in Step by Step. Creating RMAN Catalog database and after registering Oracle 19c Database in to RMAN Catalog database.

Steps to create rman catalog and register database in Oracle 19c Database

SQL> alter session set "_ORACLE_SCRIPT"=true;

SQL> alter system set sec_case_sensitive_logon=FALSE;

SQL> ALTER SYSTEM SET SEC_CASE_SENSITIVE_LOGON = TRUE;

1) Create tablespace for example name cattbs

SQL> create tablespace CATTBS datafile '/oradata/RCATDB/cat_tbs01.dbf' size 100M autoextend on;

2) Create user for example user rcat and assign cattbs as default tablespace

SQL> create user rcat identified by rcat123 default tablespace CATTBS temporary tablespace TEMP;

 

3) Grant user rcat the following roles: connect, resource, recovery_catalog_owner

SQL> GRANT CONNECT,RESOURCE,RECOVERY_CATALOG_OWNER TO RCAT;

SQL> alter user rcat DEFAULT TABLESPACE cattbs quota unlimited on cattbs;

4) Connect to catalog through RMAN

$ rman 

RMAN> connect catalog rcat/rcat123;

5) Create recovery catalog

RMAN> create catalog tablespace cattbs;

6) Next register database with the catalog

$ rman target /

RMAN> connect catalog rcat/rcat123;

RMAN> register database;

Note: One can register multiple databases with different versions in the same catalog but the catalog version is the highest version of the databases registered so if you upgrade a database the catalog will need to be upgraded.

To upgrade the catalog, it is included in the steps of upgrade how to upgrade the catalog, below shows how to upgrade the catalog.

RMAN> upgrade catalog;

RMAN> upgrade catalog;