Database must be archivelog
to perform backup through rman the database must be in archivelog mode
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /export/home/oracle/app/oracle/oradata/archive1
Oldest online log sequence 241
Next log sequence to archive 243
Current log sequence 243
SQL>
Create the tablespace used by the catalog
SQL> create tablespace oracat
2 datafile '/export/home/oracle/app/oracle/oradata/catsserp/catalogdb.dbf' size 5G;
Tablespace created.
Create the database owner of the RMAN catalog
SQL> create user catman identified by catman
2 TEMPORARY TABLESPACE TEMP
3 DEFAULT TABLESPACE oracat
4 quota unlimited on oracat;
User created.
Grant the RECOVERY_CATALOG_OWNER role to to catman user
SQL> grant RECOVERY_CATALOG_OWNER to catman;
Grant succeeded.
The RECOVER_CATALOG_OWNER grants the following system privileged
SQL> select * from dba_sys_privs where grantee='RECOVERY_CATALOG_OWNER';
GRANTEE PRIVILEGE ADM
------------------------------ ---------------------------------------- ---
RECOVERY_CATALOG_OWNER CREATE TABLE NO
RECOVERY_CATALOG_OWNER CREATE SYNONYM NO
RECOVERY_CATALOG_OWNER CREATE TRIGGER NO
RECOVERY_CATALOG_OWNER CREATE DATABASE LINK NO
RECOVERY_CATALOG_OWNER CREATE SEQUENCE NO
RECOVERY_CATALOG_OWNER CREATE PROCEDURE NO
RECOVERY_CATALOG_OWNER ALTER SESSION NO
RECOVERY_CATALOG_OWNER CREATE SESSION NO
RECOVERY_CATALOG_OWNER CREATE TYPE NO
RECOVERY_CATALOG_OWNER CREATE VIEW NO
RECOVERY_CATALOG_OWNER CREATE CLUSTER NO
11 rows selected.
SQL>
connect to the instance and create the RMAN catalog
oracle@aficatsvr:/ora/oracle/app/oracle/product/11.2.0/dbhome_1/bin$ ./rman
Recovery Manager: Release 11.2.0.4.0 - Production on Fri Jan 13 13:37:58 2017
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
RMAN> connect catalog catman/catman
connected to recovery catalog database
RMAN> create catalog;
recovery catalog created
RMAN>
