CREATE CATALOG

Syntax

Text description of the illustration createca.gif

Purpose

To create a schema for the recovery catalog. Typically, you create this schema in a separate recovery catalog database.

Note: In releases prior to 8.1.5, you created the recovery catalog schema by connecting to the recovery catalog database and executing the catrman.sql script.

See Also: Oracle9i Recovery Manager User's Guide to learn how to create the recovery catalog

Restrictions and Usage Notes

• Execute this command only at the RMAN prompt.

• RMAN must be connected to the recovery catalog either through the CATALOG command-line option or the CONNECT CATALOG command, and the catalog database must be open. A connection to the target database is not required.

• The recovery catalog owner must be granted the RECOVERY_CATALOG_OWNER role, and also be granted space privileges in the tablespace where the recovery catalog tables will reside.

• Do not create the recovery catalog in the SYS schema.

  See Also: Oracle9i Database Administrator's Guide for more information about the RECOVERY_CATALOG_OWNER role "cmdLine" for information about RMAN command-line options

Keywords and Parameters

TABLESPACE 'tablespace_name'

Specifies the tablespace in which to store the recovery catalog schema. The catalog owner must be granted quota privileges. If you do not specify a tablespace, RMAN stores the recovery catalog in the default tablespace of the catalog owner.

Example

Creating a Catalog Schema: Example

This example creates a user rman, grants rman the RECOVERY_CATALOG_OWNER role, then creates the recovery catalog in the schema rman.cattbs of the database rcat:

% sqlplus sys/change_on_install@rcat;

SQL> CREATE USER rman IDENTIFIED BY rman 
  2> DEFAULT TABLESPACE cattbs QUOTA UNLIMITED ON cattbs;
SQL> GRANT recovery_catalog_owner TO rman;
SQL> exit

% rman CATALOG rman/rman@rcat;
RMAN> CREATE CATALOG;