HP Data Protector A.06.11, Integration Manual

Page: 55 / 500

3. Connect to the Oracle target database locally using the Oracle Net software
as the Oracle database administrator with the
SYSDBA
role.
Example
If the
DB_NAME
of the target database is
PROD
, the
DB_NAME
of the Oracle
recovery catalog database is
RMANCAT
, and
ORACLE_HOME
is
/oracle/PROD
, then the commands will look like:
su - ora
id
uid=101(ora) gid=101(dba)
export DB_NAME=PROD
oracle/PROD/bin/sqlplus
SQL> connect rman/rman@RMANCAT
Connected.
SQL> connect system/manager as sysdba
SQL> connect system/manager@PROD as sysdba;
Connected.
• Test whether the user
root
and the Oracle administrator (for example, the user
oracle
) can connect to the target database and the recovery catalog database
using the RMAN command on the backup system:
1. Log in as the Oracle database administrator to the backup system (for
example, the user
oracle
).
2. Execute the RMAN command and connect to the target database and the
recovery catalog database.
Example
If the
DB_NAME
of the target database is
PROD
, the
DB_NAME
of the Oracle
recovery catalog database is
RMANCAT
, and
ORACLE_HOME
is
/oracle/PROD
,
then the commands will look like:
su - ora
id
uid=101(ora) gid=101(dba)
export DB_NAME=PROD
rman target system/manager catalog rman/rman
Recovery Manager: Release 10.1.0.2.0 - Production
RMAN-06005: connected to target database: PROD
RMAN-06008: connected to recovery catalog database
Zero downtime backup integration guide 55