RMAN Catalog creation

RMAN Catalog creation

Basic Concepts for the Recovery Catalog:-The recovery catalog contains metadata about RMAN operations for each registered target database. When RMAN is connected to a recovery catalog, RMAN obtains its metadata exclusively from the catalog. 

The catalog includes the following types of metadata
1) Information about datafiles and archived redo log backup sets and backup pieces
2) Information about datafiles copies
3) Information about archived redo logs and their copies
4) Information about tablespaces and datafiles
5) Information about Stored scripts, which are named user-created
6) Information about RMAN configuration settings

Creating Catalog for RMAN :-
1) Connect to database :-
sqlplus sys/system as sysdba

2) Create tablespace for RMAN catalog :-
CREATE TABLESPACE RMAN
DATAFILE 'C:\oracle_db\oradata\RMAN01.DBF' SIZE 100M REUSE;

3) Create user for RMAN Schema (Catalog) :-
CREATE USER rman IDENTIFIED BY rman
TEMPORARY TABLESPACE temp
DEFAULT TABLESPACE rman
QUOTA UNLIMITED ON rman;

4) Grant Privs to RMAN catalog user:-
GRANT connect, resource, recovery_catalog_owner TO rman;

5) Connect RMAN from Command prompt :-
rman catalog=rman/rman

6) Create catalog:-
create catalog;

7) Exit from RMAN prompt
exit;

Registering a Database:-The first step in using a recovery catalog for a target database is registering the target database in the recovery catalog. 

1. Start RMAN and connect to a target database and recovery catalog. The recovery catalog database must be open.

• rman catalog=rman/rman target /

1. Register the target database in the connected recovery catalog. RMAN creates rows in the catalog tables to contain information about the target database.

• RMAN>register database;

1. Verify that the registration was successful by running REPORT SCHEMA

• RMAN>report schema;      

---Need to connect more db---
1) rman catalog=rman/rman target sys/sys as sysdba@ab1

register database;

exit;
2) rman catalog=rman/rman target sys/sys as sysdba@ab2

register database;