---

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.

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 either via the catalog command-line option (see "cmdLine") or the connect catalog command.

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

See Also: For more information about the RECOVERY_CATALOG_OWNER role, see the Oracle8i Administrator's Guide.

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.RCVCAT of the database RCAT:

% sqlplus sys/change_on_install@rcat;

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

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

Related Topics

"connect"

"dropCatalog"

"upgradeCatalog"

---