In a previous article we saw how to patch an Oracle database. In this article we will see the same process in an Oracle Data Guard environment on a UNIX operating system. The steps we will follow allow us to… read more
How we set an Azure Storage Account as a Cloud Witness in Windows Failover Cluster Quorum
When we install a Windows Failover Cluster on Windows Server and we want to have automatic failover, we need to define a Witness. Witness's job is to communicate with both sites and in case any… read more
How do we add a database that has TDE Encryption enabled to a SQL Server Always On Availability Group?
In a previous article we have seen that TDE (Transparent Data Encryption) is the encryption of a database at a physical level. That is, it encrypts data files, log files and backups. When a database in SQL Server has enabled… read more
How can we get email whenever synchronization between databases is lost in Oracle Data Guard
In this article we will see how we make a mechanism that will inform us by email when some of the standby databases that synchronize with the primary have fallen behind in the sequence number of the logs or because... read more
What do I do when Oracle Grid Cluster Services (CRS) won't start as system file permissions have been lost
In this article we will see what to do when one of the Oracle Cluster servers/nodes shows an error and the Cluster Services (CRS) do not start. The symptom When we go to start Cluster Services (CRS): It shows us the… read more
Useful commands to manage Oracle Grid Infrastructure / RAC (crsctl / srvctl)
In this article we will see some useful commands to manage databases installed on Oracle Grid Infrastructure. We manage Oracle Cluster Resources (CRS) through the CRSCTL tool and Oracle Database , Listener and… read more
How to install an Oracle Real Application Cluster (RAC) on Linux using Direct NFS
In this article we will see step by step how to install an Oracle Database belonging to a Real Application Cluster (RAC) on a Linux operating system (Oracle Linux 7.7) with shared NFS disks without using Oracle ASM (Automatic Storage... read more
What is Oracle Real Application Cluster (RAC)
In this article we will see a detailed description of what Oracle RAC (Real Application Cluster) is, what features it provides and how it works. Oracle RAC is a software that allows us to connect multiple servers (up to… read more
How can we perform backups and other Agent jobs in an Always On Availability Group of SQL Server
In this article we will see how to take backups and run jobs on any server that has the Primary role or is a Preferred Backup Replica in an Always On Availability Group of SQL Server. While installing… read more