11G OCM Base Recovery Catalogue


I have skipped to step #6 of the plan in OCM 11G Planning (1):

Create a RMAN base recovery catalog in the REPOS database.

The procedure is in Creating a Recovery Catalog.

Create a Tablespace for the Recovery Catalog

create tablespace rman_catalog
    datafile '/opt/oracle/app/oradata/repos/rman_catalog01.dbf'
    size 100m autoextend on next 100m maxsize unlimited;

Create the Recovery Manager User

The password is suppressed for the RMAN user:

CREATE USER rman IDENTIFIED BY ********
  TEMPORARY TABLESPACE temp 
  DEFAULT TABLESPACE rman_catalog 
  QUOTA UNLIMITED ON rman_catalog;

And RMAN owns the recovery catalogue:

GRANT RECOVERY_CATALOG_OWNER TO rman;

Create the Base Recovery Catalog

This is the old-fashioned recovery catalog that is rebadged as a Base Recovery Catalog.

$ rman catalog rman@rman

Recovery Manager: Release 11.1.0.7.0 - Production on Sat Nov 28 20:14:29 2009

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

recovery catalog database Password: 
connected to recovery catalog database

RMAN> create catalog;

recovery catalog created
Advertisements

One thought on “11G OCM Base Recovery Catalogue

  1. 11G OCM Upgrade OMR to 11.1.0.7 « Yet Another OCM

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s