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
See Also:Oracle Database Backup and Recovery Advanced User's Guide to learn how to create the recovery catalog
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
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
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;