Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle 9i ADR on HPUX Serviceguard

SOLVED
Go to solution
Shivkumar
Super Advisor

Oracle 9i ADR on HPUX Serviceguard

Dear Sirs/Madam,

We are running oracle 9i RAC with ADR in 2 different Geography.
This is running on HPUX Serviceguard.

The data between 2 Geo gets replicated after certain interval;i believe via some temporary buffer table.

My question is: Whether oracle has the capability/technology which can replicate data to other Geo as soon as a single record gets posted in one Geo ?

Thanks,
Shiv
23 REPLIES
Victor Fridyev
Honored Contributor

Re: Oracle 9i ADR on HPUX Serviceguard

Oracle DataGuard
Entities are not to be multiplied beyond necessity - RTFM
Chan 007
Honored Contributor

Re: Oracle 9i ADR on HPUX Serviceguard

Shiv,

Best is use Oracle Data Gaurd. This does this functionality.

If you have budget problem, then follow this in a script.

1. Use switchlogs to clear your database buffer.

2. Create a redo log

3. rcp or ftp to your next site.

4. Apply the redo logs on the standby DB.

This is what the DG is doing internally...

007

Sanjay_6
Honored Contributor
Solution

Re: Oracle 9i ADR on HPUX Serviceguard

Hi,

you can also look into Real Application Cluster Guard Architecture for Oracle RAC.

http://www.lc.leidenuniv.nl/awcourse/oracle/rac.920/a96601/opfsarch.htm

Hope this helps.

regds
Delrish
Trusted Contributor

Re: Oracle 9i ADR on HPUX Serviceguard

You should use oracle data guard.You can use its Maximum protection mode or Maximum performance mode or Maximum availability. Depend on the distance between two site and amount of bandwidth, ....,you should choose one of the modes.for further information take a look at following Link.

http://www.oracle.com/technology/deploy/availability/htdocs/DataGuardOverview.html

Also Oracle has another solution called, Maximum Availability Architecture. MAA is combination of RAC and dataguard. Take a look at following link for this issue:
http://www.oracle.com/technology/deploy/availability/htdocs/maa.htm

Alireza
Arunvijai_4
Honored Contributor

Re: Oracle 9i ADR on HPUX Serviceguard

Hi Shiv, Oracle data guard is the one what you are looking for..

Oracle Data Guard is one of the most effective and comprehensive data protection and disaster recovery solutions available today for enterprise data. Oracle Data Guard is the management, monitoring, and automation software infrastructure that creates, maintains, and monitors one or more standby databases to protect enterprise data from failures, disasters, errors, and corruptions.

If you are looking for 9i, http://www.oracle.com/pls/db92/db92.docindex
http://www.oracle.com/technology/deploy/availability/htdocs/ha9i_listing.html#DR

-Arun
"A ship in the harbor is safe, but that is not what ships are built for"
Shivkumar
Super Advisor

Re: Oracle 9i ADR on HPUX Serviceguard

I need to know whether Oracle has the technologies which updates the database instances in 2 or more Geography instantaneously ?

Regards,
Shiv
Arunvijai_4
Honored Contributor

Re: Oracle 9i ADR on HPUX Serviceguard

Hi Shiv, If you are looking for implememting High Availability, here is a very good white paper, http://dmreview.com/article_sub.cfm?articleId=1001155

-Arun
"A ship in the harbor is safe, but that is not what ships are built for"
Delrish
Trusted Contributor

Re: Oracle 9i ADR on HPUX Serviceguard

You should use Oracle dataguard for this purpose too. You can have as many as remote standby databases and use oracle dataguard for sending updates from primary database to all of them.
Shivkumar
Super Advisor

Re: Oracle 9i ADR on HPUX Serviceguard

Indira, I know your are the expert in this area. I would like to request your expert opinion on this subject.
Delrish
Trusted Contributor

Re: Oracle 9i ADR on HPUX Serviceguard

I think , you should use oracle dataguard in Maximum Protection mode.This mode offers the highest level of data protection. Data is synchronously transmitted to the standby database from the primary database and transactions are not committed on the primary database unless the redo data is available on at least one standby database configured in this mode. If the last standby database configured in this mode becomes unavailable, processing stops on the primary database. This mode ensures no-data-loss.
Delrish
Trusted Contributor

Re: Oracle 9i ADR on HPUX Serviceguard

HP has solutions for Disaster recovery too. However HPâ s solution is more expensive than Oracle DataGuard and required special hardware and software. For data protection you can use HP StorageWorks Continuous Access. Take a look at following link:
http://h18006.www1.hp.com/products/storage/software/conaccesseva/index.html

And for datacenter protection you can use HP Metrocluster support for HP StorageWorks Continuous Access EVA or HP Continental clusters.These solutions have some limitations.Take a look at following links for this issue:
http://h71028.www7.hp.com/enterprise/cache/108988-0-0-0-121.html
http://h71028.www7.hp.com/enterprise/cache/4182-0-0-0-121.html

Also you can use HP Serviceguard Extension for RAC for this purpose too.
http://h71028.www7.hp.com/enterprise/cache/257273-0-0-0-121.aspx
I believe the Oracle Data Guard is a better and cheaper solution for data protection and disaster recovery.

Alireza
Yogeeraj_1
Honored Contributor

Re: Oracle 9i ADR on HPUX Serviceguard

hi,

Oracle Replication would be the solution.

With Oracle 10g, you have STREAMS coming in with powerful routines for replication.

please read about them


kind regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Yogeeraj_1
Honored Contributor

Re: Oracle 9i ADR on HPUX Serviceguard

hi,

I think this will be possible with Oracle's Advanced Replication Option that gives you the ability to automatically propagate data to any Oracle database and most other databases via Oracle Gateways.

Data is guaranteed to be consistent because of two phase commit. Data can move in either or both directions thanks to a wide variety of conflict resolution schemes.


Disconnected machines like laptops as well as network, hardware, or software outages do not affect Oracle Replication. As soon as the affected link is restored, Oracle Replication automatically continues.

USES: --Off loading data to a data warehouse
--Backup database for disasters
--Dissemination of data to remote databases
--Collection of data from remote databases


also read the metalink paper:
Migrating Advanced Replication Environment to Streams Replication Environment

hope this helps too!

kind regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Shivkumar
Super Advisor

Re: Oracle 9i ADR on HPUX Serviceguard

Sirs,
We already have RAC and ADR implemented on HPUX MC/Serviceguard. My concern was that replication doesn't happen intantaneously, it takes 1 or more minutes, i guess.
Steven E. Protter
Exalted Contributor

Re: Oracle 9i ADR on HPUX Serviceguard

Shalom Shiv,

How fast the data replication occurs depends on the bandwith, the power of the computers involved and some factors merely beyond your control like distance and weather.

There is no fool proof solution, nothing that does it instantaneously.

Oracle dataguard is in essense log replicaiton, followed by applying of those logs.

If the transaction volume is not to heavy and the connection not disrupted, you can be assured that replication will occur fairly quickly, measured in seconds or even fractions of a second.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Shivkumar
Super Advisor

Re: Oracle 9i ADR on HPUX Serviceguard

Hi Indira, What is your take on this ?

Regards,
Shiv
Indira Aramandla
Honored Contributor

Re: Oracle 9i ADR on HPUX Serviceguard

Hi Shivkumar,

I am sorry for the delayed reply. I did not get to see your post during the Christmas break. Today I saw your update.

I do not have much experience with this. In my openion (similar to others) would be
one of the configuration that Oracle provides Advanced replication environments that support an update-anywhere data model. To help administer advanced replication environments, Oracle provides the Replication Management section in Enterprise Manager.

As Yogeeraj mentioned, Oracle Streams introduced since Oracle 9.2 is the other option. This enables the sharing of data and events in a data stream, either within a database or from one database to another.
Oracle 9.2 has introduced a more flexible and efficient way of implementing replication using Streams. In the contrary to what it happens on Advanced Replication, there is no a Master Definition Site and all the sites plays the same role.
Every database involved in the Streams replication is in charge of capturing those changes involved in the replication and propagating them to the other sites. Also every database is in charge of applying those entries coming from other sites.

Then in a bidireccional database we will have 2 Streams, one from site A to site B and the other from Site B to Site A.

I am not sure if this answers your query about the update of one database be propogated to the other instantly. there might be a time gap.
or may be I was thinking on the lines of writing table triggers, as soon as the tbale data is update then the trigger starts the update to the table on the other database thought the database link........some think on those line.


Indira A
Never give up, Keep Trying
Shivkumar
Super Advisor

Re: Oracle 9i ADR on HPUX Serviceguard

Oracle 9.2 has resolved some of our application issues.

I am suspecting the streaming technology might have helped in this.

Was streaming technology not available in earlier version of Oracle 9.2 ?
Indira Aramandla
Honored Contributor

Re: Oracle 9i ADR on HPUX Serviceguard

Hi Shivkumar,


Oracle Streams was introduced since Oracle 9.2. So Oracle 9.2.x or higher releases will have this functionality.



Indira A
Never give up, Keep Trying
Arunvijai_4
Honored Contributor

Re: Oracle 9i ADR on HPUX Serviceguard

Hi Shiv,

As you can see in the release notes about Streams, (Oracle 9.2 or higher)

http://www.oracle.com/broadband/showiseminar.html?1486892

-Arun
"A ship in the harbor is safe, but that is not what ships are built for"
Arunvijai_4
Honored Contributor

Re: Oracle 9i ADR on HPUX Serviceguard

http://www.oracle.com/technology/products/dataint/htdocs/streams_fo.html

Feature overview Oracle® Streams

-Arun
"A ship in the harbor is safe, but that is not what ships are built for"
Arunvijai_4
Honored Contributor

Re: Oracle 9i ADR on HPUX Serviceguard

http://www.oracle.com/technology/oramag/oracle/04-nov/o64streams.html
http://www.oracle.com/technology/sample_code/tech/streams/index.html

Some links of basics and examples of streams.,

-Arun
"A ship in the harbor is safe, but that is not what ships are built for"
Yogeeraj_1
Honored Contributor

Re: Oracle 9i ADR on HPUX Serviceguard

hi shiv,

STREAMS is new name used in Oracle 10g. It existed as message queues in previous versions.

However, with oracle 10g you have much more functionalities inbuilt.

read more at the links provided above


if you need more clarifications, please do let us know.

kind regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)