Creating an rman recovery catalog – HP 3PAR Application Software Suite for Oracle User Manual

Page 54

Advertising
background image

This procedure is to backup archive logs only. For Recovery Manager for Oracle to perform backup
and restoration correctly, you must use the following guidelines in conjunction with Symantec
NetBackup documentation when configuring a NBU policy:

Select the Oracle type for the policy.

Backup Attribute

Backup Selections

1.

Enter the location of RMAN backup script
(/etc/3par/solutions/<db_server>.ora.<oracle_sid>/rmora_nbu_archbackup.sh).

2.

Recovery Manager will generate the RMAN backup script at the specified location when
you create the configuration file (see below for details).

Recovery Manager will generate the RMAN backup script at the specified location when you
create the configuration file (see Recovery Manager for Oracle Configuration Files for details).

Backup Schedule

1.

Create a schedule for full backup.

2.

If you wish to perform client-side archive log backup (initiated from Recovery Manager for
Oracle), set the backup window to 0.

3.

If you also wish to perform automatic archive log backup (initiated from NBU), specify the
backup window to fit your needs.

Set the backup client to the host name of the backup server, as the backup process will actually
take place on the backup server.

Backup Clients

Creating an RMAN Recovery Catalog

This section describes how to create and configure an RMAN Recovery Catalog. Refer to Oracle
documentation for more detailed information.
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>;

54

Configuring Recovery Manager for Oracle

Advertising
This manual is related to the following products: