HP 3PAR Application Software Suite for Oracle User Manual
Page 73
4.25
Setting Up NetBackup Policies for Oracle RMAN Backup
Recovery Manager for Oracle User’s Guide
2
Create a tablespace for the Recovery Catalog as follows:
where:
◆
<catdb>
is the Oracle Instance ID of the Recovery Catalog.
◆
<cat_tbs>
is the Recovery Catalog tablespace name.
◆
<path/filename>
is the file path where the datafile is created.
3
Create a user for the Recovery Catalog as follows:
where:
◆
<tbs_name>
is the tablespace name of the Recovery Catalog.
◆
<rman_user>
is the user name to be granted access permission to the Recovery
Catalog.
◆
<rman_password>
is the password for the
<rman_user>
.
4
Create the RMAN Recovery Catalog tables as follows:
$ export ORACLE_SID=<catdb>
$ export ORACLE_HOME=<oracle_home>
$ sqlplus "/as sysdba"
SQL> create tablespace <cat_tbs> datafile '<path/filename>' size 10M;
SQL> exit
$ sqlplus "/as sysdba"
SQL> create user <rman_user> identified by <rman_password>
temporary tablespace temp
default tablespace <cat_tbs>
quota unlimited on <cat_tbs>;
SQL> grant connect, resource, recovery_catalog_owner to <rman_user>;
$ rman catalog <rman_user>/<rman_password>@<catdb>
RMAN> create catalog tablespace <cat_tbs>;