Monday, February 2, 2015

Creating an RMAN Catalog

This is just a note to remind me of the steps involved.

1. You need 2 databases. You've got your main database, and you've got a small database to act as the catalog. Once the catalog database is created, don't forget to run catalog and catproc, then create a user called rman and ....

grant recovery_catalog_owner to rman;

2. Make sure that the catalog DB is available from the main database server where you're going to run ran from.

3. rman
connect catalog rman/rman/rmandb
create catalog;

4. connect target a/b@c
register database;

5. connect target / catalog rman/rman@rmandb
backup database plus archivelog;


To backup the catalog database....

Rman target /
shutdown immediate
startup mount
backup full database;
alter database open;


Happyjohn

No comments:

Post a Comment