Oracle RAC active-passive mode
ACTIVE_INSTANCE_COUNT enables you to designate one instance in a two-instance cluster as the primary instance and the other instance as the secondary instance. This parameter has no functionality in a cluster with more than two instances. When you set this parameter to 1, the first instance you start up becomes the primary instance and accepts client connections. The second instance starts up as a secondary instance and can accept client connections only if the first instance fails. In such an
event, the secondary instance becomes the primary instance.
When the failed instance can once again be started up, it starts up as the secondary instance, and will not accept client connections unless the current primary instance fails.
In my experiences, the terms "active-active" and "active-passive" mean different things to different people. So, let's not bother labeling the two main configurations (at least that's what I think you're talking about) and just explain them.
With multi-instance databases in Oracle, you can optionally set the active_instance_count parameter. If set to 1, then one instance will assume the "primary" role and it will allow sessions to connect directly to it. All other instances will have the "secondary" role until the primary instance fails. When the primary instance fails, one of the secondary instances will assume the primary role and begin accepting connections.
There are a number of reasons that this configuration is useful, and it is typically used to provide very fast failover. This is useful for applications that require faster failover than a traditional failover cluster but that cannot run in a parallel configuration due to an application design problem (all users update one row in one table or any number of other related issues).
When the active_instance_count is set to a value other than 1 (or it is not set at all), then users may connect to any instance. This is what most people think of as a "true" parallel database since processing is taking place on multiple nodes at the same time. In versions prior to 9i, this was the configuration that required very careful planning and design to avoid pings created when application users touch the same data from multiple instances.
In general, most people refer to an "active-passive" configuration as the first one I've described (when active_instance_count is set to 1) and "active-active" is commonly associated with the second case where users are active on more than one node simultaneously.
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/12361284/viewspace-616553/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle 12c Rac Set Archive ModeOracleHive
- Change the Archiving Mode in a RAC Environment
- oracle time modeOracle
- ORACLE LOCK MODE 1.2.3.4.5.6Oracle
- oracle 11.2.0.1 rac 修改asm磁碟組的冗餘模式(redundancy mode)為normalOracleASM模式ORM
- Oracle 11g RAC ORA-01102: cannot mount database in EXCLUSIVE modeOracleDatabase
- ORACLE基礎之oracle鎖(oracle lock mode)詳解Oracle
- oracle ITL TX MODE 4問題Oracle
- oracle RACOracle
- Oracle blocking issue with lock table in exclusive modeOracleBloC
- Enabling Archive Log mode in OracleHiveOracle
- 淺談Oracle的受限模式(Restricted Mode)Oracle模式REST
- oracle deadlock with TM lock in SX/SSX modeOracle
- Oracle RAC Cache Fusion 系列十七:Oracle RAC DRMOracle
- Oracle RAC CacheFusion 系列十五:Oracle RAC CRServer Part TwoOracleServer
- ORACLE RAC clusterwareOracle
- oracle rac oemOracle
- oracle rac + dataguardOracle
- oracle實驗記錄 (SHARED server MODE)OracleServer
- Oracle 11.2 DataGuard RAC To RAC搭建Oracle
- RAC 11.2.0.3 ORA-01102: cannot mount database in EXCLUSIVE mode”Database
- Oracle RAC Cache Fusion系列十八:Oracle RAC Statisticsand Wait EventsOracleAI
- Oracle RAC Cache Fusion 系列十四:Oracle RAC CR Server Part OneOracleServer
- Oracle RAC Cache Fusion 系列十:Oracle RAC Enqueues And Lock Part 1OracleENQ
- 【RAC】Oracle RAC如何修改心跳網路Oracle
- Oracle 優化引數 optimizer_mode 介紹Oracle優化
- oracle rac 增加磁碟Oracle
- oracle RAC RDS on AIXOracleAI
- Oracle RAC LoadBalanceOracle
- oracle rac的特徵Oracle特徵
- Oracle RAC搭建(三)Oracle
- Oracle RAC搭建(二)Oracle
- Oracle RAC搭建(一)Oracle
- ORACLE RAC重建OCROracle
- Oracle RAC基本管理Oracle
- Oracle RAC Background processesOracle
- ORACLE RAC工作原理Oracle
- Oracle RAC TAF [zt]Oracle