MyNotes

Let us discuss "Rman Parameter  configuration Part -2 in oracle11g" this are basic steps before we take backup for more details click here https://ampersandacademy.com/tutorials/oracle-admin-2/rman-configuration-parameter-part-2

Let us we discuss How to understand AWR reports in oracle 11g? We already Saw how to generate AWR reports here we go to read AWR reports step by step https://ampersandacademy.com/tutorials/oracle-admin-1/how-to-understand-awr-report-in-oracle11g

AWR VS STATSPACK   *When we are facing performance issue in the database our first thought is to take AWR or statspack reports. but we do not know what are the difference between AWR and statspack Here we can discuss them and I will try to mention as much as I can   https://ampersandacademy.com/tutorials/oracle-admin-1/awr-vs-statspack-reports-in-oracle-11g

Let us we discuss Dataguard and Rac Background Process in oracle? Here we can see some important background process in Dataguard and RAC in oracle 11g https://ampersandacademy.com/tutorials/oracle-admin-1/dataguard-and-rac-background-processes-in-oracle-11g

Let us we discuss What are the background process in oracle ?  In architecture we already saw some mandatory (PMON,SMON,DBWR,LGWR,CHPK AND ARCN )background process,but here we are going to see some more background process for more details click here https://ampersandacademy.com/tutorials/oracle-admin-1/background-process-in-oracle

High availability and scalability: * As a dba most scraiest word or scariest area is down time we need to expertise in this particular ares. *in that down time is the test to dba capcity only we can resolve by expertise and practice comes into picture at that time we can't google how do fail over and switch over? reason of downtime:: *as planned down time for os level paramter or the server team doing migaration old into new hardware Planned Down time *Its for doing hardware or software level ex: applying patches ,Server Hardware Upgrade,Server maintenance. Unplanned downtime: * 1)computer failure - our server completely blast,before the computer failure data failures causes the downtime. Types of downtime:: *storage failure- let us take harddisk is data stored its totally gone *site failure - due to some natural disaster our production server is gone *Human error - someone deleting the data from database *corruption - one block or sector are corrupted in h...

overview of Oracle RAC SMP vs cluster single processor machine(symmetric multiprocessing): *It involves a multiprocessor computer hardware architecture where two or more identical processors are connected to a single shared main memory and are controlled by a single OS instance. *SMP is single processing machine / single processor machine basically all of our desktops, laptop because it have dedicated ram, dedicated hard disk, and processor *It acts as one single system Cluster: *it consists of multiple systems which are connected each other to solve the business problem * ex: if we search the query in google it means the single system responds to my query, actually it behind a lot of servers are connected and gives respond for users request outside of the world it seems one big system. Cluster Management software: *If we are going to use word file we need ms office software, at the same, we are going to access pdf files we need the pdf reader like the same we n...