RMAN Catalog Configuration

From Ittichai Chammavanijakul's Wiki
Revision as of 10:58, 9 June 2012 by Ittichai (talk | contribs)
Jump to navigation Jump to search

RMAN Catalog Configuration

1) Create tablespace for RMAN repository

create tablespace rman_tbs
datafile '+DG1' size 100M autoextend on;

2) Create RMAN owner user.

create user rman_user 
identified by rman_user
default tablespace rman_tbs
temporary tablespace temp;

3) Grant privileges to the RMAN Repository owner.

grant connect, resource, recovery_catalog_owner to rman_user;

4) Create catalog.

rman catalog rman_user/rman_user
create catalog;

5) Now you Register the database with RMAN catalog.