Creating a recovery catalog

Hello folks,

Today I will show you how to create a recovery catalog. If you have more than one databases to manage, you want to keep the backup information of your databases for a long time the recovery catalog might be justified. You can register an unlimited numbers of databases into the recovery catalog.

Connect to SQLPLUS with SYSDBA:

[felipe@db1 ~]$ sqlplus / as sysdba SQL> create tablespace rman datafile ‘+data’ 2 size 150m autoextend on;

Tablespace created.

Now we are creating the owner of the recovery catalog.

SQL> create user rman identified by rman default tablespace rman quota unlimited on rman;

User altered.

SQL> grant recovery_catalog_owner to rman; Grant succeeded.

The role recovery_catalog_owner includes the systems priveliges below:

  • ALTER SESSION
  • CREATE CLUSTER
  • CREATE DATABASE LINK
  • CREATE PROCEDURE
  • CREATE SEQUENCE
  • CREATE SESSION
  • CREATE SYNONYM
  • CREATE TABLE
  • CREATE TRIGGER
  • CREATE TYPE
  • CREATE VIEW

Now that the RMAN account exist, log into the catalog and initialize the repository with the CREATE CATALOG command:

[felipe@srv1 ~]$ rman catalog rman/rman@rcat

RMAN> create catalog; recovery

catalog created

RMAN>

The command below will register the database into the recovery catalog.

For each database that you have, you can register into the RMAN repository

[felipe@srv1 ~]$ rman target / catalog rman@rcat

connected to target database: PROD11G (DBID=9043318517) recovery catalog database Password: ********** connected to recovery catalog database

RMAN> register database;

database registered in recovery catalog starting full resync of recovery catalog full resync complete RMAN>

All metadata from your backups will be stored into the RMAN repository. In case that perform backups without connect with recovery catalog, you can do a resync with command below:

[felipe@srv1 ~]$ rman target / catalog rman@rcat

connected to target database: PROD11G (DBID=9043318517) recovery catalog database Password: ********** connected to recovery catalog database

RMAN>resync catalog;

starting full resync of recovery catalog full resync complete

RMAN>

Cheers

Felipe

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s