Skip Headers
Oracle® Database Backup and Recovery Reference
10g Release 2 (10.2)

Part Number B14194-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

CREATE CATALOG

Syntax

createCatalog::=

Description of createcatalog.gif follows
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.

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:

Oracle Database Backup and Recovery Advanced User's Guide to learn how to create the recovery catalog

Restrictions and Usage Notes

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;