Oracle RAC Terminology
---------------------------
Database
Instances
Local Storage (Shared Storage)
Clusterware
Raw Device/ Cluster Filesystem
Single Instance DB/ Multi Instance
Storage Area Network (SAN)
Automatic Storage Management (ASM)
Oracle Services
How RAC evolved
--------------------
Oracle 7 first introduced the Oracle Parallel Server (OPS)
Oracle 8i significantly enhanced the OPS features.
Oracle 9i introduced the RAC with Cache Fusion technology
Oracle 10g enhanced RAC and introduced Oracle Clusterware
Two Node RAC System Architecture
----------------------------------------
---------------------------
Database
Instances
Local Storage (Shared Storage)
Clusterware
Raw Device/ Cluster Filesystem
Single Instance DB/ Multi Instance
Storage Area Network (SAN)
Automatic Storage Management (ASM)
Oracle Services
How RAC evolved
--------------------
Oracle 7 first introduced the Oracle Parallel Server (OPS)
Oracle 8i significantly enhanced the OPS features.
Oracle 9i introduced the RAC with Cache Fusion technology
Oracle 10g enhanced RAC and introduced Oracle Clusterware
Two Node RAC System Architecture
----------------------------------------
Node1 and Node2 are Cluster Nodes as Clusterware software runs on both nodes
Node1 and Node2 share a common storage i.e. Shared Storage
Node1 and Node2 can have their Local Storage too.
Node1 and Node2 are directly connected by Cluster Interconnect.
Shared Storage – control file, spfile, datafile, tempfile
Local Storage – online redo logs, rollback segments, undo segments if AUM not used
Cluster Interconnect performance can be judge by the data rate of interconnect and the latency – the delay. Go for High Data Rate and Low Latency.
Oracle RAC 10g Architecture
-------------------------------
Oracle Clusterware software runs on Operating System.
ASM and Database Instances run over Oracle Clusterware.
Node1 and Node2 are connected with Public Network as well as Private Network.
Clients can connect Nodes through Public Network.
Cluster Interconnect is a Private Network.
Two Nodes use the shared storage.
Datafiles, Control files, spfile, tempfile, archive logs, redo logs can be managed by ASM.
OCR – Oracle Cluster Registry and Voting Disks are files should be mirrored and placed on Raw Devices.
Oracle Licensing
-------------------
With Oracle Database Standard Edition you
-Must use only Oracle Clusterware and no 3rd party clusterware.
-Must use ASM for all database storage
-Maximum 4 CPUs per cluster.
With Oracle Enterprise Edition
-Must use EE-only features with RAC.
-Required for higher CPU counts.
Node1 and Node2 can have their Local Storage too.
Node1 and Node2 are directly connected by Cluster Interconnect.
Shared Storage – control file, spfile, datafile, tempfile
Local Storage – online redo logs, rollback segments, undo segments if AUM not used
Cluster Interconnect performance can be judge by the data rate of interconnect and the latency – the delay. Go for High Data Rate and Low Latency.
Oracle RAC 10g Architecture
-------------------------------
Oracle Clusterware software runs on Operating System.
ASM and Database Instances run over Oracle Clusterware.
Node1 and Node2 are connected with Public Network as well as Private Network.
Clients can connect Nodes through Public Network.
Cluster Interconnect is a Private Network.
Two Nodes use the shared storage.
Datafiles, Control files, spfile, tempfile, archive logs, redo logs can be managed by ASM.
OCR – Oracle Cluster Registry and Voting Disks are files should be mirrored and placed on Raw Devices.
Oracle Licensing
-------------------
With Oracle Database Standard Edition you
-Must use only Oracle Clusterware and no 3rd party clusterware.
-Must use ASM for all database storage
-Maximum 4 CPUs per cluster.
With Oracle Enterprise Edition
-Must use EE-only features with RAC.
-Required for higher CPU counts.
No comments:
Post a Comment