Oracle - Creating the Recovery Catalog

Creating the Recovery Catalog

Connect to Catalog database.

[oracle@localhost dbs]$ export ORACLE_SID=CATDB

[oracle@localhost dbs]$ sqlplus / as sysdba

Create Catalog tablespace in catalog database

SQL> create tablespace tbs_catalog  datafile '/u01/app/oracle/oradata/DUPDB1/catalog.dbf'

     size 10M autoextend on extent management local uniform size 1M;

Create Recovery Catalog owner

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

Grant recovery catalog owner role which contains list of all privileges required.

SQL> grant recovery_catalog_owner to rman;

SQL> exit

Connect to target database and catalog database through RMAN

[oracle@localhost dbs]$ export ORACLE_SID=ORADB1

[oracle@localhost dbs]$ rman target / catalog rman/oracle@CATDB

Recovery Manager: Release 11.2.0.4.0 - Production on Thu Sep 28 11:39:44 2017

connected to target database: ORADB1 (DBID=2294695355)

connected to recovery catalog database

Create Recovery Catalog.

RMAN> create catalog ;

recovery catalog created

Register target database to recovery catalog.

RMAN> register database;

database registered in recovery catalog

starting full resync of recovery catalog

full resync complete

Configure rman parameters

RMAN> configure default device type to disk;

RMAN> configure retention policy to recovery window of 2 days;

RMAN> configure controlfile autobackup on;

RMAN> configure controlfile autobackup format for device type disk to '/u01/backup/rman/ctl_%F';

RMAN> configure channel device type disk format '/u01/backup/rman/Full%d_DB_%U_%S_%P';

RMAN> configure device type disk backup type to compressed backupset parallelism 2;'