Oracle 9i ADR on HPUX Serviceguard

[Shivkumar]

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

[Victor Fridyev]

Oracle DataGuard

[Chan 007]

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 · Accepted solution]

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]

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]

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

[Shivkumar]

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

Regards,
Shiv

[Arunvijai_4]

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

[Delrish]

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]

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