• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
Techgoeasy

Techgoeasy

Learn Oracle, PHP, HTML,CSS,Perl,UNIX shell scripts

  • Home
  • Oracle
    • Oracle database
    • Oracle Ebusiness Suite
    • Oracle weblogic
    • Oracle Performance Tuning
    • Oracle Hyperion
    • Oracle Cloud Tutorials
  • SQL
  • interview questions
  • Linux
  • PHP and HTML
  • Downloads
  • General
Home » Oracle » Oracle Database » How to create RMAN recovery catalog and register database in catalog

How to create RMAN recovery catalog and register database in catalog

October 28, 2020 by techgoeasy 3 Comments

RMAN Recovery catalog is a very important registry. Control file registry get rotated after some time so you lost many backup information. By storing backup information in recovery catalog ,you get rid of this problem

Also it provides a central repository where you can find all the backup information.

Here are the steps on How to create it  and register database in catalog

Table of Contents

  • Creating catalog
  • Registering a Target Database in the Recovery Catalog
  • How to take store backup information in the catalog
  • How to catalog files on  the filesystem
  • How to Create the RMAN Recovery Catalog in a Pluggable Database

Creating catalog

(1) Create a Recovery Catalog Tablespace

CREATE TABLESPACE R_CATALOG
LOGGING
DATAFILE '/u00/R_CATALOG.dbf' SIZE 200M;

(2) Create the rman schema

CREATE USER rman IDENTIFIED BY cat TEMPORARY TABLESPACE temp DEFAULT TABLESPACE R_CATALOG QUOTA UNLIMITED ON R_CATALOG;

(3) Grant required roles to the User

Grant RECOVERY_CATALOG to the schema rman
GRANT RECOVERY_CATALOG_OWNER TO rman;

(4)Connect to User as RMAN

RMAN rman/[email protected]

(5) Run the CREATE CATALOG script to create the recovery catalog

RMAN> CREATE CATALOG

(6) Connect into the Oracle database as rman and verify the tables

sqlplus rman/[email protected]
SELECT table_name from user_tables;

Registering a Target Database in the Recovery Catalog

(1) Connect into RMAN

$ORACLE_HOME/bin/rman TARGET / CATALOG
rman/[email protected]

(2) register database using the command

RMAN > register database;

(3) Verify that the registration was successful by running REPORT SCHEMA

RMAN > REPORT SCHEMA;

How to take store backup information in the catalog

There are two ways.

(1) when you take backup , connect to catalog also

$ORACLE_HOME/bin/rman TARGET / CATALOG  rman/[email protected]
RMAN> backup database;

(2) You can take backup using control file, then run rsync  catalog to sync the control file to catalog repository

Connect into RMAN
$ORACLE_HOME/bin/rman TARGET / CATALOG rman/[email protected]
RMAN>rsync database;

How to catalog files on  the filesystem

If you have datafile copies, backup pieces, or archived logs on disk, then you can catalog them in the recovery catalog with the CATALOG command.

CATALOG DATAFILECOPY '/xyz/old_datafiles/01_01_2003/users01.dbf';
CATALOG ARCHIVELOG '/xyz/arch_logs/archive1_731.dbf',
'/xyz/arch_logs/archive1_732.dbf';
CATALOG BACKUPPIECE '/xyz/backups/backup_820.bkp';

You can also catalog multiple backup files in a directory at once by using the CATALOG START WITH command, as shown in the following example:

CATALOG START WITH '/xyz/backups/';

I hope you like post . This will be really helpful for any body using recovery manager in there in Job role . Please do provide feedback

How to Create the RMAN Recovery Catalog in a Pluggable Database

  • You need to connect to PDB (pluggable database) using connect string and execute create catalog command.
  • The steps are the same as for a non-container database recovery catalog.
  • In a CDB environment, the only option is to place the rman catalog schema in a PDB and not in ROOT.

Also reads

  • Oracle RMAN cheatsheet :Useful and Helpful Downloadable Oracle RMAN cheat sheet
  • RMAN connection : Find out what all connection are established when RMAN command are run
  • RMAN DUPLICATE DATABASE CLONING WITH ACTIVE DATABASE :Cloning is major part of DBA role.Check this post for RMAN DUPLICATE DATABASE CLONING WITH ACTIVE DATABASE i.e without taking source database backup
  • Snapshot controlfile feature with RMAN :Snapshot controlfile is a new feature in RMAN for resynchronizing. Important changes with it from 11gR2 and how to resolve the error ORA-00245
  • recover database using RMAN : How to restore and recover database using RMAN with parallelism to speed up the recovery process
  • Recovery Manager : Recovery Manager(RMAN) is a backup and recovery utility provided by Oracle. it comes with database installation and make the jobs easy for DBA’s
  • debug Oracle RMAN session
  • https://en.wikipedia.org/wiki/RMAN

Filed Under: Oracle, Oracle Database Tagged With: catalog, recovery catalog

Reader Interactions

Comments

  1. Syeda uzma says

    September 8, 2020 at 12:20 pm

    it was really helpful

    Reply
  2. Arun says

    July 11, 2021 at 2:41 pm

    Amazing.. So simple sentences are used thank u easy to understand for beginners

    Reply
    • techgoeasy says

      July 24, 2021 at 9:04 am

      Thanks Arun

      Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar



Subscribe to our mailing list

Enter your email address to subscribe to this blog and receive notifications of new posts by email

Recent Posts

  • Password Version in oracle
  • How to login as user without changing the password in Oracle database(alter user identified by values)
  • How to check encrypted tablespace in the Database
  • How To Export -Import TDE Master Encryption Key
  • How to Configure Auto Login TDE Wallet

Copyright © 2023 : TechGoEasy

  • Hire me
  • Privacy Policy
  • Contact Us
  • New? Start Here
  • About Us