RMAN Catalog Configuration

From Ittichai Chammavanijakul's Wiki
Revision as of 10:58, 9 June 2012 by Ittichai (talk | contribs) (Created page with "== RMAN Catalog Configuration == 1) Create tablespace for RMAN repository <pre> create tablespace rman_tbs datafile '+DG1' size 100M autoextend on; </pre> 2) Create RMAN owner ...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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.