Help - Search - Members - Calendar
Full Version: oracle and hp data protector
Oracle DBA Forums > Oracle > Oracle Forum
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

QUOTE
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":

QUOTE
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
QUOTE (burleson @ Sep 19 2011, 07:43 AM) *
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
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.