How to Create a RMAN Catalog and register a database

Target DB Name : ORCL (Server : linux3)

Target DB Version : 11gR2

Catalog DB Name : RCAT (Server : linux4)

Catalog DB Version : 11g2

1.       Create the default tablespace for the recovery catalog owner.

SQL> SET SQLPROMPT '_connect_identifier SQL>'

RCAT SQL>

RCAT SQL>CREATE TABLESPACE RMANTS DATAFILE '/u01/app/oracle/oradata/RCAT/datafile/RMANTS_01.dbf' SIZE 512M AUTOEXTEND ON;

Tablespace created.

RCAT SQL>

2.       Create a recovery catalog owner in the Recovery Catalog Database

RCAT SQL>CREATE USER RMAN IDENTIFIED BY rman

DEFAULT TABLESPACE RMANTS

QUOTA UNLIMITED ON RMANTS;  2    3

User created.

RCAT SQL>

3.       Grant necessary privilege to the recovery catalog owner

RCAT SQL>GRANT RECOVERY_CATALOG_OWNER TO RMAN;

Grant succeeded.

RCAT SQL>

4.       Create the Recovery Catalog

** Make Sure that the catalog db name is added to the tnsnames.ora file.

[oracle@linux4 admin]$ rman catalog rman/rman@rcat

Recovery Manager: Release 11.2.0.1.0 - Production on Sun Jul 12 07:25:59 2015

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

connected to recovery catalog database

RMAN> CREATE CATALOG;

recovery catalog created

RMAN>

5.       Make Sure that the catalog db name is added to the tnsnames.ora file on the target DB Server.

[oracle@linux3 ~]$ echo $ORACLE_SID

ORCL

[oracle@linux3 ~]$ tnsping RCAT

TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 12-JUL-2015 07:31:54

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

Used parameter files:

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=linux4)(PORT=1521)) (CONNECT_DATA=(SERVICE_NAME=RCAT)))

OK (20 msec)

6.       Register the target database

[oracle@linux3 ~]$ rman target / catalog rman/rman@rcat

Recovery Manager: Release 11.2.0.1.0 - Production on Sun Jul 12 07:32:21 2015

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

connected to target database: ORCL (DBID=1407538528)

connected to recovery catalog database

RMAN> register database;

database registered in recovery catalog

starting full resync of recovery catalog

full resync complete

RMAN> report schema;

Report of database schema for database with db_unique_name ORCL

List of Permanent Datafiles

===========================

File Size(MB) Tablespace           RB segs Datafile Name

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

1    680      SYSTEM               YES     /u01/app/oracle/oradata/ORCL/datafile/o1_mf_system_brg81t9h_.dbf

2    480      SYSAUX               NO      /u01/app/oracle/oradata/ORCL/datafile/o1_mf_sysaux_brg81tch_.dbf

3    75       UNDOTBS1             YES     /u01/app/oracle/oradata/ORCL/datafile/o1_mf_undotbs1_brg82r2j_.dbf

4    5        USERS                NO      /home/oracle/users.dbf

5    100      USER1                NO      /u01/app/oracle/oradata/ORCL/datafile/o1_mf_user1_brg81tcv_.dbf

6    100      USER2                NO      /u01/app/oracle/oradata/ORCL/datafile/o1_mf_user2_brg81thh_.dbf

7    100      USER3                NO      /u01/app/oracle/oradata/ORCL/datafile/o1_mf_user3_brg81tj3_.dbf

8    100      USER4                NO      /u01/app/oracle/oradata/ORCL/datafile/o1_mf_user4_brg81tl5_.dbf

9    100      USER5                NO      /u01/app/oracle/oradata/ORCL/datafile/o1_mf_user5_brg81tmy_.dbf

10   100      USER6                NO      /u01/app/oracle/oradata/ORCL/datafile/o1_mf_user6_brg81toq_.dbf

List of Temporary Files

=======================

File Size(MB) Tablespace           Maxsize(MB) Tempfile Name

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

1    29       TEMP                 32767       /u01/app/oracle/oradata/ORCL/datafile/o1_mf_temp_bobtojsg_.tmp

RMAN>