oracle and hp data protector Options

[pasin]

Hello everyone!
I would like to know if it is possible to create an automated standby database disaster recovery and high-availability solution (like dataguard) using hp data protector on oracle?
Thanks in advance!

[burleson]

Hi Pasin,

>> I would like to know if it is possible to create an automated standby database disaster recovery and high-availability solution (like dataguard) using hp data protector on oracle?

Good question! The answer is "maybe"

The HP Data protector (formerly Omniback) is a hardware-based recovery solution by HP, and the HP data protector can be tightly coupled and fully integrated into Oracle's RMAN backup utility.



Oracle communicates to the HP data protector via the Data Protector Oracle integration Media Management Library (MML).

The MML is a set of routines that allows the reading and writing of Oracle file data to the HP General Media Agents, a part of HP fdata protector.

Besides handling direct interaction with the media devices, Data Protector provides scheduling, media management, network backups,monitoring, and interactive backup.

Using MML you can perform all RMAN full and incremental backups. To test MML, youn use the sbtest utility. The sbtest utility does not perform an actual backup but tries to communicate with the media management software to see if it is working properly or not.:

http://www.praetoriate.com/t_rman_backup_recovery_111.htm

Installing HP data protector and intergrationg with MML is done as the "root" user, and you link-in the executables into these locations:

The 32-bit executable the name is /opt/omni/lib/libob2oraclexx.sl.

The 64-bit executables the name is /opt/omni/lib/libob2oraclexx_64bit.sl

See the "Enterprise Backup Solution with HP Data Protector implementation" manual for details and see this HP manual for HP data protector install and configurartion details:

http://h20000.www2.hp.com/bc/docs/support/...2/c00751982.pdf

However, I don't see anything toat indicates that HP Data Protector can be used to use HO Data Protector files instead of the online redo logs.

I would examine the MML commands and see if this option is avialable:

I found this:

http://bizsupport1.austin.hp.com/bizsuppor...p;printver=true

Change Request: QCCR2A17308 QXCR1000879515
The Data Protector requirement for unique Oracle
database identifiers (DBIDs) within a cell is a
general requirement and not applicable only to
Oracle Data Guard. The respective limitation is
documented among Oracle Data Guard-specific
limitations and may be misinterpreted.

This indicates that HP Data Protector cannot be used with Data Guard. . . .

I would open an SR on MOSC:

http://support.oracle.com

Let us know what you find!

[pasin]

Well I am a newbie in data protector and I want to be sure for the answers.
Now, what I want t o achieve(using hp data protector) is an environment with one primary database and 2 standby and the 2 standby must have almost the same data as the primary during its work.
So you're saying that this is not possible?

[burleson]

Hi Pasin,

>> I want to be sure for the answers.

Then go to Oracle and/or HP! Only the vendor knows for sure!

Again, I got this from the docs, and it indicates "no":

The Data Protector requirement for unique Oracle database identifiers (DBIDs) within a cell is a
general requirement and not applicable only to Oracle Data Guard.

As I said:

1 - Read your RJMAN and HP Data Protector documentation
2 - Call Oracle technical support at 800-223-1711 and ask them!
3 - Contect your HP representative, they will know!

Let us know what they tell you!

[pasin]

Hi Pasin,

>> I want to be sure for the answers.

Then go to Oracle and/or HP! Only the vendor knows for sure!

Again, I got this from the docs, and it indicates "no":



As I said:

1 - Read your RJMAN and HP Data Protector documentation
2 - Call Oracle technical support at 800-223-1711 and ask them!
3 - Contect your HP representative, they will know!

Let us know what they tell you!

Thanks!

[RHR]

For quick reference, information on integrating HP Data Protector with Oracle is here:

http://dba-oracle.com/t_integrating_hp_dat...with_oracle.htm

RHR