Starting in Oracle 12c database, you can change this and enable the new Multithreaded configuration! And that too by merely setting one parameter. You can change the architecture by making Oracle database use thread based architecture instead of process based. Once changed, all Oracle processes will be threads within a few Oracle processes. Thus if CPU moves from one Oracle process to the other, the time between the context switch will be reduced significantly as the switching from one thread to the other is within the same process.
In 11gr2 Oracle Grid Infrastructure, Oracle has introduced a new mechanism to remove an unresponsive node from the RAC cluster. This mechanism is a Failure isolation process whereby the unresponsive node is sent instructions via an external mechanism, Intelligent Management Platform Interface device (IPMI), by the CRS daemon to reboot the problematic node. This method […]
With the OCR and Voting disks being placed in ASM, these files are accessible only when the cluster processes have started up and ASM instance is up and running. However without the OCR file the clusterware processes cannot start up.
Apart from the physical backup methods, like the use of rman, oracle also provides a way of logically backing up your data. By logical it means backing up the actual logical structures of database like the database itself, the schema or any individual table. Oracle has had the exp and imp utilities since its version […]
The Oracle Grid Cluster Health Monitor (CHM) stores operating system metrics in the CHM repository for all nodes in a RAC cluster. It stores information on CPU, memory, process, network and other OS data.
What are the steps required to upgrade GoldenGate? Read about a real life upgrade and the steps required.
Prior to 11g R2, when the voting disk became unresponsive or inaccessible, to avoid split brain, the host was rebooted without waiting for the IO processes to complete. This reboot was usually initiated when there was either a communication (network related) failure with the other nodes in the cluster or the overloaded IO on the […]
Restore OCR disk In case of the loss of the ASM diskgroups storing the OCR and Voting disks, restoration will have to be done using the following steps. With the loss of these file the cluster will not start. The OCR backups are normally stored in the $GRID_HOME/cdata directory. Using these backups we should be […]
On a node which is part of the cluster after setting up the environment variables like the Oracle Base, Grid home, Path and ASM SID, run the addnode.sh script on the host. The script will first run a cluster verification pre-check to ensure that the storage, network , ssh, node readability, rpm check, etc.. prerequisites […]
Rolling Foward Standby database, here is step by step guide with a couple of real scenarios. This is the second time that I have come across having to sync up the standby database with the primary, without having all the archive logs available. The first time I came across this issue was when we were […]