Fwd: Interview questions for RAC... its useful !!!

[Nagarajan B]

 Hi 

 
I have around 30+ interview questions just on Oracle RAC side.  Could everyone take an effort to answer one question will help in make ourselves groom on Oracle RAC from interview point of view.  Please find the questions below.
 
1) How to put the RAC db in archivelog mode ?
2) How to alter the init parameter specific to one instance alone
3) What is the startup sequence of the RAC db with ASM
4) How to check the status of the RAC database and nodes
5) How to backup/restore the voting disk and Oracle cluster registry (ocr )
6) What is the utility used to check the pre-requisites of a RAC before starting the installation ?
7) How is RMAN backup configured for a RAC database
8) What is th status of the thread when you remove a node pertainin to that thread
9) How to check the statistics of all the instance from one single node
10) what are the init parameters that should stay common between all the instances
11) what are the init parameter that have to differ across all instances
12) How will you shutdown all the instances from one single node
13) what is the difference between database and instance in a RAC setup?
14) Can I have multiple ASM instance on one single node
15) How do you attach a ASM instance to an Oracle database
16) How do you differentiate an ASM instance and what parameter makes an instance as ASM ?
17) What happens when an ASM instance is terminated abnormally?
18) How will you do a database recovery in a RAC environment
19) What are the files that cannot be / can be stored on a ASM disk?
20) How is the locks handled in a RAC instance
21) What are the processes that need to run for cluster ?
22) How will you check whether the cluster SW is running or not 
23) What is the additional background process that will be seen in RAC instance
24) What is the post-tasks that needs to be done after adding or removing a node on the cluster
25) What is the type of the filesystem that voting disk / ocr needs to be placed ?
26) What is how will you manage the VIP ?
27) How will you resolve the lock issues in a RAC instances
28) How will you analyze AWR for a RAC setup
29) What are the additional wait events in the RAC setup
30) What are the additional statistics in the RAC setup
31) What is the utility used to add/remove nodes ?
32) How will you apply patches in RAC setup to minimize down time
33) What are the requirements for doing a rolling patch?


Regards

Raj Tilak. K
+91-9600006747