Software Suite for Oracle Owner's manual
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