Integrating Oracle and Data Protector

Troubleshooting

Restore Problems

At this stage, you should have performed all the verification steps described in the previous sections. After this, proceed as follows:

1.Verify that an object exists on the backup media

This can be done by running the following command on the Oracle server system:

On HP-UX and Solaris: /opt/omni/bin/omnidb -oracle8 "<object_name>" -session "<Session_ID>" -media

On other UNIX: /usr/omni/bin/omnidb -oracle8

"<object_name>" -session "<Session_ID>" -media (other UNIX systems)

On Windows: <Data_Protector_home>\bin\omnidb -oracle8 "<object_name>" -session "<Session_ID>" -media

The output of the command lists detailed information about the specified Oracle object, as well as the session IDs of the backup sessions containing this object and a list of the media used. For detailed syntax of the omnidb command, see its man page.

2.Simulate a restore session

Once you know the information about the object to be restored, you can simulate a restore using the Data Protector testbar2 utility.

Before you run testbar2, verify that the Cell Manager name is correctly defined on the Oracle Server system. Check the

/etc/opt/omni/client/cell_server (HP-UX and Solaris systems), /usr/omni/config/cell/cell_server (other UNIX systems), or <Data_Protector_home>\Config\client\cell_server (Windows systems) file, which contains the name of the Cell Manager system.

Test Data Protector internal data transfer using the testbar2 utility:

HP-UX and Solaris /opt/omni/bin/testbar2 -type:Oracle8 -appname:<DB_NAME>-perform:restore

-object:<object_name>

-version:<object_version>

-bar:<backup_specification_name>

Chapter 1

135

Page 157
Image 157
HP OpenView Storage B6960-96008 manual Restore Problems, Verify that an object exists on the backup media