Configuring Recovery Catalog With RMAN

Recovery Manager (RMAN)is one of the Oracle valuable tools to do the backup and recovery activities.

In this document we will explain how to setup the Recovery Manager with the Recovery Catalog.

Steps:

1- Create a repository database/Use any existing database as repository

2- Connect to the repository database as sysdba.
SQL> CONN / AS SYSDBA

3- Create a tablespace for the RMAN user:

SQL> CREATE TABLESPACE RMAN_TBS DATAFILE 'D:\oracle\product\10.2.0\oradata\ORCL\rman01.dbf';

4- Create RMAN user and grant the required privilegs to connect and also the reovery catalog owner privileges to RMAN user.

SQL> CREATE USER RMAN IDENTIFIED BY RMAN DEFAULT TABLESPACE RMAN_TBS;

SQL> GRANT RESOURCE,CONNECT,RECOVERY_CATALOG_OWNER TO RMAN;

5- Start RMAN and connect to the catalog and initialize the create catalog command.

D:\> rman catalog rman/rman@ORCL

RMAN> CREATE CATALOG;

RMAN> EXIT;

6- Register the database you want to backup in the catalog.

D:\> rman target sys@PROD catalog rman/rman@ORCL

RMAN> REGISTER DATABASE;

7- To set the parameters of the RMAN Connect to RMAN

D:\> rman target sys@PROD catalog rman/rman@ORCL

RMAN> CONFIGURE DEFAULT DEVICE TYPE TO DISK;

RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;

RMAN> CONFIGURE DEVICE TYPE DISK PARALLELISM 4;

RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;

RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'D:\DBA_Sources\RMAN_BACKUP\Control_File\ora_cf%F';

RMAN> CONFIGURE BACKUP OPTIMIZATION ON;