- Create a database with DBCA preferably named RMANCAT, CATDB ...;

- Create a user which will be owner of the recovery catalog;

$ sqlplus / as sysdba
SQL> create user rmanuser identified by rmanuser;

- Grant necessary roles, priviledges to user

SQL> grant recovery_catalog_owner to rmanuser;
SQL> grant connect, resource to rmanuser;

- Create Recovery Catalog

$rman catalog rmanuser/rmanuser
RMAN> create catalog;

- Register the databases which will use this database as recovery catalog

$rman target / catalog rmanuser/rmanuser@RMANCAT
RMAN> register database;

- Verify that the registration was successful by running REPORT SCHEMA

RMAN> report schema;

2 Responses so far.

  1. aislinn says:

    i must thank you for the efforts you've put in penning this blog. excellent blog post .

    www.n8fan.net

  2. Anonymous says:

    Thank you for this blog post .Very informative.

DOAG 2016

Powered by Blogger.

Page Views

- Copyright © Emre Baransel - Oracle Blog -Metrominimalist- Powered by Blogger - Designed by Johanes Djogan -