|Oracle® Database Recovery Manager Reference
10g Release 1 (10.1)
Part Number B10770-02
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.
In releases prior to 8.1.5, you created the recovery catalog schema by connecting to the recovery catalog database and executing the
Oracle Database Backup and Recovery Advanced User's Guide to learn how to create the recovery catalog
CATALOGcommand-line option or the
CATALOGcommand, and the catalog database must be open. A connection to the target database is not required.
RECOVERY_CATALOG_OWNERrole, and also be granted space privileges in the tablespace where the recovery catalog tables will reside.
CATALOGcommand, 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.
The following example creates a user
RECOVERY_CATALOG_OWNER role, then creates the recovery catalog in the schema
rman.cattbs of the database
#!/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;