- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Oracle 9iRAC and standby servers
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-31-2005 10:27 PM
тАО10-31-2005 10:27 PM
I installed Oracle 9iR2 RAC on two HP-UX boxes (Integrity Servers). I used an EVA as shared Storage for RAC. I plan to setup two backup servers for this database. One of the backup should be on local site and another will be on remote site.
About Local Backup server, I am interested to have this backup server updated online so that in case of RAC technology failover or for any other reasons, we can switch to this backup server without much down time or automatically.
About Remote Backup Server, I want to switch to this server whenever both Database and its local Backup Server will be failed (Whenever first site fails), so I should synchronize my Oracle data to this server too. What is your Solution for this case? Please advice
Hasan
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-31-2005 10:56 PM
тАО10-31-2005 10:56 PM
Re: Oracle 9iRAC and standby servers
Serviceguard has a continental cluster product that can be used to fail services such as oracle RAC or oracle server from one site to another.
A careful implementation will lead to a situation called High Availability.
There will be a noticeable delay when the main site goes down and users will notice a pause in processing their requests. When it works right though their connection to the databae is not broken, merely re-routed to the alternate location.
RAC itself has certain clustering capabilities which I'm not as familiar with as what I mentioned above.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-01-2005 12:58 AM
тАО11-01-2005 12:58 AM
Re: Oracle 9iRAC and standby servers
Please check:
http://www.oracle.com/technology/deploy/availability/htdocs/DataGuardOverview.html
http://www.oracle-base.com/articles/9i/DataGuard.php
hth.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-01-2005 01:02 AM
тАО11-01-2005 01:02 AM
Re: Oracle 9iRAC and standby servers
If I understand your question correctly, you have two servers running Oracle 9i RAC. You would like to setup two additional servers, one as a local failover, and the other as a remote failover.
Take a look at Oracles Data Guard product. This is an improvement on the old standby database technology.
Your RAC cluster is two servers sharing the same disks ( this was Oracle Parallel Server in versions 6,7,8). The Data Guard product allows you to create a copy of your database on another server and keep it up to date to be used if the primary server fails.
Metalink Note 285358.1 explains how to create a Standby server from a RAC Cluster. There are serveral other whitepapers available from Metalink the detail the steps and options for fault tolerant database configurations.
Patti
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-01-2005 03:56 AM
тАО11-01-2005 03:56 AM
Re: Oracle 9iRAC and standby servers
I am looking for HP's solution for this issue.
Hasan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-01-2005 10:31 PM
тАО11-01-2005 10:31 PM
Re: Oracle 9iRAC and standby servers
Hasan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-01-2005 11:37 PM
тАО11-01-2005 11:37 PM
Solutionyou should also understand the ramifications and the rules that you must follow (a good reading is:
http://download-east.oracle.com/docs/cd/A81042_01/DOC/server.816/a76995/toc.htm )
You do not want the standby to automatically take over - you could really mess things up if the primary is actually OK and still processing work but new connections are "failed" over the standby. You may endup with 2 databases!!!
Ideally, you can have a script that a human, once the determination to fail over is made, runs to automate the failover because having the standby make the decision on its own would not be a good idea.
Why? because there are conditions that are easily corrected on the primary that should be corrected on the primary rather then failing over (eg: failed to connect due to "too many processes" error whereby you only have to increase processes and restart. No need to failover). A human may need to be involved in this process.
I would prefer to handle that manually!
hope this helps!
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-02-2005 02:25 AM
тАО11-02-2005 02:25 AM
Re: Oracle 9iRAC and standby servers
I'd like to understand why you want a local failover server. For this server you would need ideally as much resources (CPU, RAM, HDD) as you have in your primary database to undertake the load of the primary server, and keep the data up to date in case of failover; or at least certain percent, say 70%, of the computing power of the main server. Probably it would be a waste of good resources. Oracle RAC by itself is already a high available solution from Oracle and it is pretty sound. But since it follows the share everything cluster model, the only one point of failure is the storage system. You can have as many nodes as the clusterware you're using let you, say you have an 8-node cluster, and if any one of them fails, your database will still be up, also connections on the failed node would migrate to an available node. However, if your storage fails and goes down for any reason, then your whole database is no longer accessible no matter if all nodes are up; all instance would crash indeed. So, I would concentrate more on assuring that the storage sub-system is also highly available. Then, you're more on the safe side and diminish the chances your system goes down. At the HW level you have RAID technology (maybe and EVA expert would suggest a more specific high available solution for this particular storage), and on top of that Oracle let you multiplex important database files, such as the redo log files, control files, offline log files, on separate physical disks so that the database can be up in case of a disk failure. And obviously, maitaining a good backup policy to meet the levels of availability you need (here EVA may help you with snapshot technology).
As for the remote backup server, I do agree with Yogeeraj's arguments as for the manual failover. That's a very tough business decision and should be based on human criteria, not on a script evalution.
Regards,
Ariel
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-04-2005 09:12 AM
тАО11-04-2005 09:12 AM