|Oracle9i Recovery Manager Reference
Release 2 (9.2)
Part Number A96565-01
RMAN Commands , 19 of 59
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
Oracle9i Recovery Manager 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.
Specifies the tablespace in which to store the recovery catalog schema. The catalog owner must be granted quota privileges. If you do not specify a tablespace, then RMAN stores the recovery catalog in the default tablespace of the recovery catalog owner.
The following UNIX shell script 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' <<EOF CREATE USER rman IDENTIFIED BY rman DEFAULT TABLESPACE cattbs QUOTA UNLIMITED ON cattbs; GRANT recovery_catalog_owner TO rman; EXIT EOF # connect to database as catalog owner and create catalog rman CATALOG rman/rman@rcat <<EOF CREATE CATALOG; EOF