I will write, what we should do when a log interval “GAP” occurs between Primary / Standby and we accidentally delete some of the archive log files on the Primary database. Suppose we do not have a backup of the deleted archive files. Normally we dba should not allow such a situation, but such a […]

What Is Big Data? It is the concept of making large amounts of data collected over time in an economic and scalable manner and where the relational database techniques are not sufficient. The importance and value of the data is increasing day by day. The reason for the increase in the importance and value of […]

SCAN is a name that gives clients access to the cluster service. You can use cluvfy comp scan (found Grid_home \ bin) to verify that DNS correctly associates the SCAN with the addresses. Because SCAN is associated with the cluster as a whole instead of a specific node, SCAN makes it possible to add or […]

This post describes how to repair multiple or single-block corruption of data files, including system data files, in the Oracle database. Block corruption is a common source of database outages. Database block becomes corrupted when its content is different from what the Oracle database expects to find. If block corruption is not prevented or repaired, […]

PostgreSQL 12 An open-source object is a relational, highly scalable, SQL-compliant database management system. PostgreSQL was developed at the University of California at the Berkeley Computer Science Department. This article will help you install PostgreSQL 12 on a CentOS / RHEL 7/6 system. CentOS’s default repositories contain postgresql packages, so we can install them seamlessly […]

Oracle MySQL 5.6 and 5.7 stands out as the most mature version with the highest performance in MySQL’s history. Also the third release after Oracle’s acquisition. In this article, we will install and configure Oracle MySQL 5.6 and 5.7 on Linux and Red Hat Enterprise Linux 6,7 and 7. If you want to run the […]