CREATE CATALOG

Syntax

Text description of the illustration createCatalog.gif

Purpose

To create a schema for the recovery catalog. Typically, you create this schema in a separate recovery catalog database. The catalog is created in the default tablespace of the recovery catalog owner.

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

Syntax Element	Description
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, then RMAN stores the recovery catalog in the default tablespace of the recovery catalog owner.

Example

Creating a Catalog Schema: Example

The following UNIX shell script 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:

#!/usr/bin/tcsh
# create user rman in recovery catalog database as catalog owner
sqlplus 'SYS/change_on_install@rcat AS SYSDBA' <<EOF
CREATE USER rman IDENTIFIED BY rman 
  DEFAULT TABLESPACE cattbs 
  QUOTA UNLIMITED ON cattbs;
GRANT recovery_catalog_owner TO rman;
EXIT
EOF
# connect to database as catalog owner and create catalog
rman CATALOG rman/rman@rcat <<EOF
CREATE CATALOG;
EOF