1) DMLs running on TWO node RAC . One node went down, whether DMLs run continuously or not ?
2) Global Cache Fusion ?
3) Split Brain Syndrome and how to solve it when it occurs ?
4) GPNP ? Grid Plug and Play
5) GNS
6) What is node eviction and how it occurs and when it occurs? How to solve it and what will be the problem when it occurs? and how does the node come back into cluster ?
7) Why use VIP when we have SCAN ip ?
8) why 3 SCAN ips ?
9) I do not want dbs to be up automatically after cluster restart or a node restart /reboot ?
--> There are 2 sections that you have to configure automatic start of RAC database
A) RAC level
B) Grid level
srvctl config database -d orcl
Management Policy : AUTOMATIC MANUAL
If its not automatic --> srvctl modify database -d orcl -y automatic
At Grid level
crsctl status recource ora.orcl.db -p grep AUTO_START
AUTO_START restore
crsctl modify resource ora.orcl.db -attr AUTO_START always (always/restore/never)
10) I want to start/stop a particular node while restarting cluster , and I do not want to that service to come up automatically while cluster reboot ?
11) How to check master node in a 3 node RAC and 8 node cluster ?
12) what is the difference between OCR and OLR ?
13) how to take backup of OCR and how to restore it when it is corrupted ?
14) What is votedisk and what is the use and how to restore/repair it when curropted and how to check when its back and weather its getting backed up or not ?
15) what is the automatic backup policy for OCR voting disk ?
16) If I have node RAC and if I setup services on all the 3 Nodes and scan listener will send users to DB -->
on 3 conditions ROUND ROBIN , least visited and HASH
sadfhskd
No comments:
Post a Comment