Create RMAN recovery catalog

Create catalog user in the RMAN catalog

[oracle@collabn1 config]$ sqlplus sys@prod1 as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Tue Aug 4 14:17:46 2015

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Enter password:

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testing options

SQL> select name,open_mode from v$database;

NAME      OPEN_MODE

--------- --------------------

PROD1      READ WRITE

SQL> create user rcuser identified by rcuser;

User created.

SQL> create tablespace rcts datafile '+DATA2' size 100m autoextend on next 1m maxsize 1g;

Tablespace created.

SQL> grant recovery_catalog_owner to rcuser;

Grant succeeded.

SQL> alter user rcuser default tablespace rcts;

User altered.

SQL> alter user rcuser quota unlimited on rcts;

User altered.

SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testing options

Connect to catalog & Target database:

[oracle@collabn1 config]$ rman

Recovery Manager: Release 11.2.0.1.0 - Production on Tue Aug 4 14:22:45 2015

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

RMAN> connect catalog rcuser/rcuser@prod1

connected to recovery catalog database

Create catalog:

RMAN> create catalog;

recovery catalog created

RMAN> connect target system/XXXXXX@orcl

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

ORA-01031: insufficient privileges

RMAN> connect target /

connected to target database: ORCL (DBID=1414564590)

RMAN> register database;

database registered in recovery catalog

starting full resync of recovery catalog

full resync complete