RECOVERY CATALOG DATABASE IN RMAN

Restore / Recovery. Recovery Manager (RMAN) Enterprise Manager. Backup. Control file. Reporting REPORT. LIST. Target database. Stored scripts. Catalog Maintenance. Register. Resynchronize. Reset. Change/Delete/Catalog. Backup /Restore/Recover. 

RECOVERY CATALOG DATABASE:

A Recovery catalog creates redundancy for the RMAN repository stored in the control file of each target database.

A recovery catalog centralizes metadata for all your target databases. Storing the metadata in a single place makes reporting and administration tasks easier to perform.

A recovery catalog can store metadata history much longer than the control file. This capability is useful if you must do a recovery that goes further back in time than the history in the control file.

A recovery catalog is required when you use RMAN in a Data Guard environment. By storing backup metadata for all primary and standby databases, the catalog enables you to offload backup tasks to one standby database while enabling you to restore backups on other databases in the environment.

Catalog Database - APPS
Target Database - TEST

Catalog Database Server (192.168.1.101)

[oratest@oracle ~]$ export ORACLE_SID=APPS

[oratest@oracle ~]$ sqlplus / as sysdba

create one New Tablespace and New user in Catalog Database

SQL > create tablespace rmantbs datafile ‘/u01/app/oracle/oradata/rman01.dbf’
size 100m;

Tablespace created.

SQL > create user rman identified by rman123
Default tablespace rmantbs
Temporary tablespace temp
Quota unlimited on rmantbs;

User created.
SQL > grant connect,resource to rman;

Grant succeeded.
SQL > grant recovery_catalog_owner to rman;

Grant succeeded.

SQL > exit

Target database server ( 192.168.1.110 )

[oratest@oracle ~] $ cat >> $ORACLE_HOME/network/admin/tnsnames.ora

Apps123 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.101 )(PORT
= 1521))
(CONNECT_DATA =
 (SERVER = DEDICATED)
(SERVICE_NAME = apps)
    )
  )

[oratest@oracle ~]$ export ORACLE_SID=test

[oratest@oracle ~]$ rman target /

Recovery Manager: Release 19.0.0.0.0 - Production on Wed Aug 18 21:21:57 2021
Version 19.3.0.0.0

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

connected to target database: TEST (DBID=2378581000)
RMAN > connect catalog rman/rman123@apps123

RMAN > create catalog;

RMAN > register database;

RMAN > resync catalog;

 

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Ramkumar’s LinkedIn: https://www.linkedin.com/in/ramkumardba/
LinkedIn Group: https://www.linkedin.com/in/ramkumar-m-0061a0204/
Facebook Page: https://www.facebook.com/Oracleagent-344577549964301
Ramkumar’s Twitter: https://twitter.com/ramkuma02877110
Ramkumar’s Telegram: https://t.me/oracleageant
Ramkumar’s Facebook: https://www.facebook.com/ramkumarram8