- 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;

7 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.

  3. sushma says:

    Hey Really Thanks for sharing the best information regarding category,hope you will write more great blogs.
    Oracle Fusion Financials Online Training

  4. Sravani says:

    Thank you for sharing such a nice and interesting blog with us. I have seen that all will say the same thing repeatedly. But in your blog, I had a chance to get some useful and unique information.

    Oracle Fusion HCM Online Training

  5. Santhosh says:

    I would like to thank you for the efforts you have made in writing this article. I am hoping the same best work from you in the future as well.

    Oracle Fusion SCM Online Training

  6. harsha says:

    Really thanks for sharing such a wonderful blog.
    Oracle Fusion Financials Online Training

  7. Naga says:

    Very interesting blog, keep posting such an informative post.

    Oracle Fusion Financials Online Training

Powered by Blogger.

Page Views

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