CREATE CATALOG

Syntax

createCatalog::=

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.

• If you specify the tablespace name in the CREATE CATALOG command, and if the tablespace name is an RMAN reserved word (as listed in "RMAN Reserved Words"), then it must be uppercase and enclosed in quotes.

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

  See Also:

  • Oracle Database Administrator's Guide for more information about the RECOVERY_CATALOG_OWNER role

  • "cmdLine" for information about RMAN command-line options

Keywords and Parameters

None

Example

Creating a Catalog Schema: Example 

The following 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:

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

# connect to database as catalog owner and create catalog
% rman CATALOG rman/rman@rcat
RMAN> CREATE CATALOG;