Recovery manager for oracle configuration files – HP 3PAR Application Software Suite for Oracle User Manual

Page 56

Advertising
background image

When using RMAN backup with HP Data Protector, if the Oracle release of the recovery catalog
database is 11g R2 or later:

Ensure that the owner of the recovery catalog is granted the CREATE ANY DIRECTORY and
the DROP ANY DIRECTORY system priviledges.

SQL> grant CREATE ANY DIRECTORY to <recovery_catalog_user> ;

SQL> grant DROP ANY DIRECTORY to <recovery_catalog_user>

Ensure that the owner of the recovery catalog has SELECT permissions on v_$instance view.

SQL> grant select on v_$instance to <recovery_catalog_user> ;

Recovery Manager for Oracle Configuration Files

For each database to be managed by Recovery Manager for Oracle, a configuration file must be
created first. There are two types of configuration files for Recovery Manager for Oracle:

Recovery Manager for Oracle without Remote Copy support.

For this type of configuration, Recovery Manager for Oracle provides an integrated Symantec
NetBackup and Oracle RMAN for backups and restorations.

Recovery Manager for Oracle with Remote Copy.

For this type of configuration, Recovery Manager for Oracle does not provide tools for media
backups and restorations.

NOTE:

Before you create a database configuration:

Verify that the required SSH setup was successfully completed.

Ensure the primary database instance is up.

Creating a Recovery Manager for Oracle Configuration File without Remote Copy

You can create the Recovery Manager for Oracle configuration file using:

Command Line Interface (CLI)

Graphical User Interface (GUI)

Creating Configuration Files Using the Command Line Interface on the Backup Server

To create a Recovery Manager for Oracle configuration file without Remote Copy support:
1.

From the backup server, enter /opt/3PAR/RMOra/bin/rmora_config.

2.

When prompted, press ENTER.

ORACLE_SID of the database instance [h=help,q=quit]?

Enter ORACLE_SID of the database instance that you want to configure. If the database is an
RAC database, enter ORACLE_SID of any RAC instance.

Hostname of the database server [h=help,q=quit]?

Enter the host name of the corresponding database server where the specified database
instance is running.

56

Configuring Recovery Manager for Oracle

Advertising
This manual is related to the following products: