ASM Preferred Mirror Read in Oracle 11g R2: Until Oracle 10g, Automatic Storage Management used to read only Primary copy of extents. This isn’t a problem when both nodes and both failure groups are all located…
Category: Database
ASM Optimal Disk Placement (ODP) in Oracle 11g R2-Airy’s Notes
ASM Optimal Disk Placement (ODP) in Oracle 11gR2: As of Oracle 11gR2 it is possible to specify on which disk regions the ASM Disks will be placed. This enables us to make…
Voting Disk in Oracle 11g R2 RAC–Airy’s Notes
Voting Disk in Oracle11g R2 RAC : Now finally to understand the whole concept of voting disk we need to know What Type of Data Voting Disk consists, what is Voting,…
Oracle Cluster Registry (OCR) in Oracle 11gR2-RAC- Airy’s Notes
Oracle Cluster Registry (OCR) in Oracle 11gR2-RAC- Airy’s Notes: What Information Exist in OCR? There are some of the main components, which are included in the OCR : Name of Process and…
Oracle 11g R2-RAC Installation
When I talk to my students or any other Oracle RAC learner, They always say – they are facing lots off difficulties to setup their own Oracle RAC machine. Therefore I have…
Oracle Restart Feature in Oracle 11g
What is Oracle Restart feature in Oracle 11g: With Oracle Real Application Clusters the Oracle database can be configured to restart as each node in the cluster is restarted. For single instance…
Querying Recovery Catalog:
Recovery Catalog Performance Views :– There are many views that provide backup-related information. The most commonly used ones are the following dynamic performance views in the target database to obtain information about…
BASE RECOVERY CATALOG DATABASE CREATION
1: Create new service named “catdb” using netca for “catdb” database. 2: Now Create a new database named “catdb” using dbca , check in /etc/oratab 3: Register “catdb” database with listener. [oracle@airyhost…
Finding Undocumented ( Hidden ) Parameter with their details
Finding Undocumented ( Hidden ) Parameter with their details : Below given script will provide you, the list of all the Undocumented ( Hidden ) initialization parameters present in your database along with…
Finding Undocumented ( Hidden ) Parameter
Finding Undocumented ( Hidden ) Parameter in your database: These parameters can be easily obtained by giving the following command on the sql prompt as shown below: [oracle@airydba ~]$ sqlplus / as…