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

10 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

  8. This really answered my downside, thanks! casino online

  9. Really excellent information and thank you for giving your valuable information

    Oracle Fusion SCM Online Training

  10. Thank you for sharing such a nice and interesting blog and really very helpful article

    oracle fusion financials online training

Powered by Blogger.

Page Views

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