Guidelines for Oracle variables

To run offloaded backups of Oracle databases, a recovery catalog database is needed. The database must be accessible by RMAN from the production host and the backup host. On the production host, use the following command to verify if the connection can be established. Before entering the command, log on as the database instance owner.

rman target / catalog catalog_db_user/catalog_user_password@catalog_db_connect_string

On the backup host, log on as the root user and enter the following command:

su - oracle_instance_owner -c rman target / catalog catalog_db_user/
catalog_user_password@catalog_db_connect_string

If you receive errors that say RMAN is unable to connect to the catalog database, verify the configuration of the tsnames.ora on the host where the command was run. In addition, verify the listener configuration on the host where the catalog database runs. For details about the setup of the catalog database and the listener configuration, see documentation provided by Oracle.