Oracle9i Recovery Manager Reference Release 1 (9.0.1) Part Number A90136-02 |
|
RMAN Commands , 19 of 60
To create a schema for the recovery catalog. Typically, you create this schema in a separate recovery catalog database.
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.
RECOVERY_CATALOG_OWNER
role, and also be granted space privileges in the tablespace where the recovery catalog tables will reside.
SYS
schema.
See Also:
RECOVERY_CATALOG_OWNER
role
This 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
:
% sqlplus sys/change_on_install@rcat; SQL> CREATE USER rman IDENTIFIED BY rman 2> DEFAULT TABLESPACE cattbs QUOTA UNLIMITED ON cattbs; SQL> GRANT recovery_catalog_owner TO rman; SQL> exit % rman CATALOG rman/rman@rcat; RMAN> CREATE CATALOG;
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|