Visit Counter

Friday, January 13, 2017

Oracle11g: create a Recovery Catalog for RMAN




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>









No comments:

Post a Comment