Friday, May 8, 2020

How to Create RMAN Catalogue

In this short post. I will show you how to create an RMAN catalog


There are 2 main parts.


  1. Create the user.
  2. Create the catalog.
In this example I have an Oracle Database called 'EPCHRS' residing and in a linux server called 'SERPENTCUSTOM'. I will create an RMAN catalog using a user called 'EPCHRS' and I will create it on a database called 'RMANP' residing on a server called 'DBPROD1AEP'



Login to the database that you want to be a repository. It can be any Oracle Enterprise Edition Database and it can also be at a separate server.

1. Create user on RMANP


  dbprod1aep|RMANP:/dbapps/oracle>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Fri May 8 02:25:29 2020

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> CREATE USER EPCHRS IDENTIFIED BY A$hl3y
  TEMPORARY TABLESPACE temp
  DEFAULT TABLESPACE users
  QUOTA UNLIMITED ON users;  2    3    4

User created.

SQL>  GRANT RECOVERY_CATALOG_OWNER TO EPCHRS;

Grant succeeded.

SQL>


2. Create catalog

Go to SERPENTCUSTOM

No comments:

Post a Comment