Skip Headers

Oracle® Database Recovery Manager Reference
10g Release 1 (10.1)

Part Number B10770-02
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
Feedback

Go to previous page
Previous
Go to current chapter
Up
Go to next page
Next
View PDF

CREATE CATALOG

Syntax

createCatalog::=

Text description of createCatalog.gif follows


Text description of 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.


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;