oracle technology lovers blog: View Free space from temporary tablespace

oracle technology lovers blog: View Free space from temporary tablespace: select substr(a.tablespace_name,1,20) "TS_name", substr(a.file_name,1,35) "File_Name", round(sum(a.bytes)/1024/1024,2) "Size_MB",sum(NVL(b.b...

oracle technology lovers blog: OS Watcher (OSW

oracle technology lovers blog: OS Watcher (OSW: OS Watcher (OSW) is a collection of UNIX shell scripts intended to collect and archive operating system and network metrics to aid support...

oracle technology lovers blog: Monitor user session.

oracle technology lovers blog: Monitor user session.: set linesize 220 col first_load_time format a20 col client_info format a20 col username format a20 col last_load_time format a20 col sq...

oracle technology lovers blog: How can the ASM instance start when the spfile is ...

oracle technology lovers blog: How can the ASM instance start when the spfile is ...: SQL> show parameter pfile NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ spfile ...

oracle technology lovers blog: Oracle RAC: restoring lost OCR file

oracle technology lovers blog: Oracle RAC: restoring lost OCR file: Shutdown everything oracle instances then run - rootdelete.sh - root.sh this will create OCR Add resource manually.

oracle technology lovers blog: steps to reset original password

oracle technology lovers blog: steps to reset original password: Use below steps to reset original password: Look at the example: schema name is : OASTOLTP SQL> set lines 9999 set pages 9999 set long 90...

oracle technology lovers blog: Extra Redo generation during online backup

oracle technology lovers blog: Extra Redo generation during online backup: There is not excessive redo generated, there is additional information logged into the online redo log during a hot backup the first ti...

oracle technology lovers blog: Oracle RAC Basics

oracle technology lovers blog: Oracle RAC Basics: Oracle RAC is nothing but multiple nodes (each with an Oracle instance) access a same shared database.   ...

oracle technology lovers blog: Difference between Oracle Single instance and Orac...

oracle technology lovers blog: Difference between Oracle Single instance and Orac...: Single  Instance Oracle RAC Single instance accessing database Multiple instances accessing same database Database can be local or shar...

Difference between Oracle Single instance and Oracle RAC

Single  Instance	Oracle RAC
Single instance accessing database	Multiple instances accessing same database
Database can be local or shared	Database must be on shared.
Minimum one node is Required	Minimum two node required
Clusterware software is not required	Clusterware Software is required.
Consists of one SGA and one set of background  processes	Each instance having own  one SGA and one set of background  processes
One set of redo logs	Multiple set redo logs depending on number of instances
No Cache fusion used un Single instance	Cache fusion is used to transfer or access block from remote instance
V$ views to monitor and manage instance	For monitoring at the cluster level Oracle provides GV$ views.
Meeting some of the business requirements (availability, scalability) is limited to a single instance configuration.	Modern business requirements of high availability and linear scalability are provided by multiple instances sharing a common physical database

Oracle RAC Basics

Oracle RAC is nothing but multiple nodes (each with an Oracle instance) access a same shared database.


 

  


Component of Oracle RAC

• Node
• Instance
• Database
• Clusterware software.
• Interconnect
• OCR and Vote disk

Node: Node is individual machine which has operating system install on it.

Instance: Instance is a way to access the database. It is combination of memory and background processes

Database: Database is set of Oracle files such as data file, Control files, Oracle redo log file and Archive log file

Clusterware software: It maintains integrity of Oracle database and manages shared and local resources.

Interconnect: Interconnect is nothing but network link between nodes. It maintains network heartbeat between RAC nodes. It also useful send block to other instance through network in case of cache fusion.

OCR: The OCR maintains cluster configuration information that is used by each node of the cluster to determine the state of the cluster. The OCR also maintains information on application resources that are defined within Clusterware such as databases, instance, services and the like and is therefore constantly changing. Each node in the cluster maintains a copy of the OCR in memory for better performance and each node is responsible for updating the OCR as required.

Vote Disk:The Voting Disk Files are used by Oracle Clusterware to determine which nodes are currently members of the cluster. The voting disk files are also used in concert with other Cluster components such as CRS to maintain the clusters integrity. As with most everything else Clusterware/RAC related, you need to consider redundancy in your architecture. Oracle expects that you will configure at least 3 voting disks for redundancy purposes. You should always configure an odd number of voting disks >= 3. This is because loss of more than half your voting disks will cause the entire cluster to fail.