Difference between revisions of "RMAN Catalog Configuration"

From Ittichai Chammavanijakul's Wiki
Jump to navigation Jump to search
(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 ...")
 
Line 28: Line 28:
 
5) Now you Register the database with RMAN catalog.
 
5) Now you Register the database with RMAN catalog.
  
[[Category: Oracle_database]]
+
[[Category: Oracle]]

Revision as of 10:58, 9 June 2012

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.