Recovery Manager for Oracle User’s Guide

2Create a tablespace for the Recovery Catalog 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

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.

3Create a user for the Recovery Catalog as follows:

$ 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>;

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>.

4Create the RMAN Recovery Catalog tables as follows:

$ rman catalog <rman_user>/<rman_password>@<catdb> RMAN> create catalog tablespace <cat_tbs>;

Setting Up NetBackup Policies for Oracle RMAN Backup

4.25

Page 73
Image 73
HP StoreServ Application Suite for Oracle Media Rmanpassword is the password for the rmanuser, $ export ORACLESID=catdb