How to create a recovery catalog in Oracle

 How to create a recovery catalog in Oracle

SQL> select name from v$datafile;

NAME

--------------------------------------------------------------------------------

/u01/app/oracle/oradata/DELHI/datafile/o1_mf_system_mqz6odrj_.dbf

/u01/app/oracle/oradata/DELHI/datafile/o1_mf_sysaux_mqz6p5vm_.dbf

/u01/app/oracle/oradata/DELHI/datafile/o1_mf_undotbs1_mqz6pny7_.dbf

/u01/app/oracle/oradata/DELHI/datafile/o1_mf_users_mqz6pp19_.dbf

Create Tablespace

SQL> create tablespace rec_catalog datafile '/u01/app/oracle/oradata/DELHI/datafile/rec_cat                                                                                                                                                                              alog01.dbf' size 5G;

Create user 

SQL> SQL> SQL> create user catowner identified by oracle default tablespace rec_catalog quo                                                                                                                                                                              ta 100M on rec_catalog;

User created.

Provide Grant

SQL> grant recovery_catalog_owner to catowner;

Grant succeeded.

Create Catalog and Register Database

Version 19.3.0.0.0

[oracle@dg1 backup_script]$ rman target /

Recovery Manager: Release 19.0.0.0.0 - Production on Sun Jun 1 13:09:49 2025

Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

connected to target database: DELHI (DBID=3274584472)

RMAN> connect catalog catowner/oracle@delhi

connected to recovery catalog database

RMAN>

RMAN>

RMAN> create catalog;

recovery catalog created

RMAN> register database;

database registered in recovery catalog

starting full resync of recovery catalog

full resync complete

RMAN>