Create Oracle Catalog DB

 

 

Create Oracle Catalog DB

PURPOSE: All documents are provided on this Blog just for educational purposes only.  Please make sure that you run it in your test environment before to move on to production environment. 

Creating tablespace

CREATE TABLESPACE CAT_DB BLOCKSIZE 16384 DATAFILE  '/data/KARDBPRD1/01/cat_db.dbf' SIZE 200M REUSE EXTENT MANAGEMENT LOCAL  AUTOALLOCATE  ONLINE PERMANENT  SEGMENT SPACE MANAGEMENT AUTO;

 

Creating User and grant them required grants.

 

CREATE USER RMAN_CAT IDENTIFIED BY passwd DEFAULT TABLESPACE CAT_DB TEMPORARY TABLESPACE TEMP;

GRANT UNLIMITED TABLESPACE TO RMAN_CAT;

GRANT CONNECT TO RMAN_CAT;

GRANT RESOURCE TO RMAN_CAT;

GRANT RECOVERY_CATALOG_OWNER TO RMAN_CAT;

GRANT DBA TO RMAN_CAT;

ALTER USER RMAN DEFAULT ROLE ALL;

 

Login into the RMAN as follow, create catalog, and register database.

 

rman target /

 

RMAN> connect catalog rman_cat/passwd@kardbprd01

 

connected to recovery catalog database

 

RMAN> create catalog;

 

recovery catalog created

 

RMAN> register database;

 

database registered in recovery catalog

starting full resync of recovery catalog

full resync complete