createCatalog::=
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 thecatrman.sql
script.See Also:
Oracle Database Backup and Recovery Advanced User's Guide to learn how to create the recovery catalogExecute 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
None
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;