HP 3PAR Recovery Manager 4.5.0 for Oracle on Solaris, Red Hat Linux, and Oracle Enterprise Linux User's Guide (QL226-97705, May 2014)

1. Create a database for housing the Recovery Catalog. Oracle suggests the following disk
space requirements:
• System tablespace: 100 MB
• Temp tablespace: 5 MB
• Rollback segment: 5 MB
• Online redo log: 1 MB (each)
• Recovery Catalog: 10 MB
2. Create 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.
3. Create 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>.
4. Create the RMAN Recovery Catalog tables as follows:
$ rman catalog <rman_user>/<rman_password>@<catdb>
RMAN> create catalog tablespace <cat_tbs>;
5. Configure TNS services for the Recovery Catalog database by adding an entry in the
$ORACLE_HOME/network/admin/tnsnames.ora file on the database server and backup
server as follows:
<catdb> =
(description =
(address = (protocol = TCP) (host = <cat_host>) (port = 1521))
(connect_data = (server = dedicated) (service_name = <catdb>))
)
where <cat_host> is the host name of the host where the catalog is created.
48 Configuring Recovery Manager for Oracle