Home / Interview Questions / Real Application Cluster(RAC) Interview Questions Part 5

Real Application Cluster(RAC) Interview Questions Part 5

1.What is a diskgroup in ASM?

  • A disk group consists of multiple disks and is the fundamental object that ASM manages.
  • Each disk group contains the metadata that is required for the management of space in the disk group.
  • The ASM instance manages the metadata about the files in a Disk Group in the same way that a file system manages metadata about its files.
  • However, the vast majority of I/O operations do not pass through the ASM instance.

 

 

2.Can my disks in a diskgroup can be varied size? For example one disk is of 100GB and another disk is of 50GB. If so how does ASM manage the extents?

Yes, disk sizes can be varied, Oracle ASM will manage data efficiently and intelligent by placing the extents proportional to the size of the disk in the disk group, bigger diskgroups have more extents than lesser ones.

 

 

3.What is the major difference between 10g and 11g RAC?

Well, there is not much difference between 10g and 11g (Release-1) RAC.

But there is a significant difference in 11gR2.

Prior to 11gR1(10g) RAC, the following were managed by Oracle CRS

  • Databases
  • Instances
  • Applications
  • Node Monitoring
  • Event Services
  • High Availability

 

From 11gR2 its completed HA stack managing and providing the following resources as like the other cluster software like VCS etc.

  • Databases
  • Instances
  • Applications
  • Cluster Management
  • Node Management
  • Event Services
  • High Availability
  • Network Management (provides DNS/GNS/MDNSD services on behalf of other traditional services) and SCAN – Single Access Client Naming method, HAIP
  • Storage Management (with help of ASM and other new ACFS filesystem)
  • Time synchronization (rather depending upon traditional NTP)
  • Removed OS dependent hang checker etc, manages with own additional monitor process

 

 

4.What is Grid Naming Service(GNS)?

Grid Naming service (GNS) is alternative service to Domain Naming Service (DNS) , which will act as a sub domain in your DNS but managed by Oracle, with GNS the connection is routed to the cluster IP and manages internally.

 

 

5.What are the file types that ASM support and keep in disk groups?

Control files

Flashback logsData Pump dump sets
Data filesDB SPFILEData Guard configuration
Temporary data filesRMAN backup setsChange tracking bitmaps
Online redo logsRMAN data file copiesOCR files
Archive logsTransport data files

ASM SPFILE

 

 

6.List Key benefits of ASM?

  • Stripes files rather than logical volumes
  • Provides redundancy on a file basis
  • Enables online disk reconfiguration and dynamic rebalancing
  • Reduces the time significantly to resynchronize a transient failure by tracking changes while disk is offline
  • Provides adjustable rebalancing speed
  • Is cluster-aware
  • Supports reading from mirrored copy instead of primary copy for extended clusters
  • Is automatically installed as part of the Grid Infrastructure

 

 

7.List some of the background process that used in ASM?

Process

Description

RBALOpens all device files as part of discovery and coordinates the rebalance activity
ARBnOne or more slave processes that do the rebalance activity
GMONResponsible for managing the disk-level activities such as drop or offline and advancing the ASM disk group compatibility
MARKMarks ASM allocation units as stale when needed
OnnnOne or more ASM slave processes forming a pool of connections to the ASM instance for exchanging messages
PZ9nOne or more parallel slave processes used in fetching data on clustered ASM installation from GV$ views

 

 

8.What is node listener?

In 11gr2 the listeners will run from Grid Infrastructure software home

  • The node listener is a process that helps establish network connections from ASM clients to the ASM instance.
  • Runs by default from the Grid $ORACLE_HOME/bin directory
  • Listens on port 1521 by default
  • Is the same as a database instance listener
  • Is capable of listening for all database instances on the same machine in addition to the ASM instance
  • Can run concurrently with separate database listeners or be replaced by a separate database listener
  • Is named tnslsnr on the Linux platform

 

 

9.What is the difference between CRSCTL and SRVCTL?

crsctl manages clusterware-related operations:

  • Starting and stopping Oracle Clusterware
  • Enabling and disabling Oracle Clusterware daemons
  • Registering cluster resources

srvctl manages Oracle resource–related operations:

  • Starting and stopping database instances and services
  • Also from 11gR2 manages the cluster resources like network,vip,disks etc

 

 

10.How to find Voting Disk location?

To determine the location of the voting disk write the following command on Linux terminal as Root User:

# crsctl query css votedisk

 

 

 

11.What are types of ASM Mirroring?

Disk Group TypeSupported MirroringLevelsDefault Mirroring Level
External redundancyUnprotected (None)Unprotected (None)
Normal redundancyTwo-wayThree-way

Unprotected (None)

Two-way
High redundancyThree-wayThree-way

 

 

12.What is ASM Striping?

ASM can use variable size data extents to support larger files, reduce memory requirements, and improve performance.

Each data extent resides on an individual disk.

Data extents consist of one or more allocation units.

The data extent size is:

  • Equal to AU for the first 20,000 extents (0–19999)
  • Equal to 4 × AU for the next 20,000 extents (20000–39999)
  • Equal to 16 × AU for extents above 40,000

ASM stripes files using extents with a coarse method for load balancing or a fine method to reduce latency.

  • Coarse-grained striping is always equal to the effective AU size.
  • Fine-grained striping is always equal to 128 KB.

 

 

13.How many ASM Diskgroups can be created under one ASM Instance?

ASM imposes the following limits:

  • 63 disk groups in a storage system
  • 10,000 ASM disks in a storage system
  • Two-terabyte maximum storage for each ASM disk (non-Exadata)
  • Four-petabyte maximum storage for each ASM disk (Exadata)
  • 40-exabyte maximum storage for each storage system
  • 1 million files for each disk group
  • ASM file size limits (database limit is 128 TB):
  1. External redundancy maximum file size is 140 PB.
  2. Normal redundancy maximum file size is 42 PB.
  3. High redundancy maximum file size is 15 PB.

 

 

14.How to find the cluster network settings?

To determine the list of interfaces available to the cluster:

$ oifcfg iflist –p -n

To determine the public and private interfaces that have been configured:

$ oifcfg getif

 

To determine the Virtual IP (VIP) host name, VIP address, VIP subnet mask, and VIP interface name:

$ srvctl config nodeapps -a

 

 

 

15.Managing or Modifying SCAN in Oracle RAC?

To add a SCAN VIP resource:

$ srvctl add scan -n cluster01-scan

To remove Clusterware resources from SCAN VIPs:

$ srvctl remove scan [-f]

To add a SCAN listener resource:

$ srvctl add scan_listener

$ srvctl add scan_listener -p 1521

To remove Clusterware resources from all SCAN listeners:

$ srvctl remove scan_listener [-f]

 

 

16.I’m going to do add disks to my ASM diskgroup, how long will this rebalance take?

Rebalance time is heavily driven by the three items:

  • Amount of data currently in the diskgroup
  • IO bandwidth available on the server
  • ASM_POWER_LIMIT or Rebalance Power Level

 

 

17.We are migrating to a new storage array. How do I move my ASM database from storage A to storage B?

Given that the new and old storage are both visible to ASM, simply add the new disks to the ASM disk group and drop the old disks. ASM rebalance will migrate data online.

Note 428681.1 covers how to move OCR/Voting disks to the new storage array

 

 

18.Is it possible to unplug an ASM disk group from one platform and plug into a server on another platform (for example, from Solaris to Linux)?

No, Cross-platform disk group migration not supported. To move datafiles between endian-ness platforms, you need to use XTTS, Datapump or Streams.

 

 

19.How does ASM work with multipathing software?

It works great! Multipathing software is at a layer lower than ASM, and thus is transparent.
You may need to adjust ASM_DISKSTRING to specify only the path to the multipathing pseudo devices.

 

 

Real Application Cluster(RAC) Interview Questions Part 4

 

Real Application Cluster(RAC) Interview Questions Part 3

Real Application Cluster(RAC) Interview Questions Part 2

Real Application Cluster(RAC) Interview Questions Part 2

Real Application Cluster(RAC) Interview Questions Part 1

 

 

 

 

About Syed Saad Ali

As a certified and experienced Oracle Database Administrator with Almost 10 Years of Experience I am able to perform all levels of database maintenance and am fully qualified to do Oracle updates as well. Capitalizing on my interest in Business & IT both, I chose to navigate my career towards Enterprise Solutions, which has enabled me to excel in the combination of both. I have developed exceptional analytical skills that allow me to diagnose and take care of issues immediately. Extremely skilled in planning and execution of special projects in time- critical environments. Extensive knowledge in directing, coordinating and exercising concern authority for planning, organization, control and successful completions. Very skilled at solving customer relations issues by seeking first to understand and then to be understood. Effectively able to communicate with customers, vendors and management.

Check Also

Apps Technical Interview Questions Part 5

Leave a Reply