HP 3PAR Application Software Suite for Oracle - Manual (Page 48)

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=
$ export ORACLE_HOME=
$ sqlplus "/as sysdba"
SQL> create tablespace datafile '' size 10M;
SQL> exit
where:
•
is the Oracle Instance ID of the Recovery Catalog.
•
is the Recovery Catalog tablespace name.
•
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 identified by
temporary tablespace temp
default tablespace
quota unlimited on ;
SQL> grant connect, resource, recovery_catalog_owner to ;
where:
•
is the tablespace name of the Recovery Catalog.
•
is the user name to be granted access permission to the Recovery Catalog.
•
is the password for the .
4. Create the RMAN Recovery Catalog tables as follows:
$ rman catalog /@
RMAN> create catalog tablespace ;
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:
=
(description =
(address = (protocol = TCP) (host = ) (port = 1521))
(connect_data = (server = dedicated) (service_name = ))
)
where is the host name of the host where the catalog is created.
48 Configuring Recovery Manager for Oracle