Setup Recovery catalog

Setup Recovery catalog
1. Create recovery catalog database
2. Create RMAN tablespace
3. Create RMAN user
4. Grant privilidges to RMAN user
5. Connect to RMAN and create recovery catalog


1. Create recovery catalog database

I suppose you know how to create the database

2. Create RMAN tablespace

SQL> create tablespace RMAN;

Tablespace created.

SQL>


3. Create RMAN user

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

User created.

SQL>

4. Grant privilidges to RMAN user

SQL> grant connect, resource, recovery_catalog_owner to rman;

Grant succeeded.

SQL>

5. Connect to RMAN and create recovery catalog

[oracle@rcat1 ~]$ rman catalog rman/rman@rcat

Recovery Manager: Release 11.2 - Production on 

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to recovery catalog database

RMAN> create catalog;

recovery catalog created

RMAN>