Recovery Manager Command Syntax, 15 of 50

createCatalog

Syntax

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:
"Creating the Recovery Catalog" to learn how to create the recovery catalog.

Requirements

Execute this command only at the RMAN prompt.
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.
RMAN must be connected to the recovery catalog database either through the catalog command-line option (see "cmdLine") or the connect catalog command.
Do not create the recovery catalog in the SYS schema.

See Also:
Oracle8i Administrator's Guide for more information about the RECOVERY_CATALOG_OWNER role.

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

Examples

Creating a Catalog Schema

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

% connect catalog rman/rman@rcat;
RMAN> create catalog tablespace cattbs;