How to Detect Oracle Data Guard Gap In Your Archivelog Validate SEQUENCE

dataguard fix

29 November 2019   0 Comment

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 […]

Read More

Oracle Big Data Appliance

oracle-big-data-appliance-hadoop

28 November 2019   0 Comment

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 […]

Read More

Oracle RAC scan ip check “comp scan cluvfy”

Oracle cluster check

27 November 2019   0 Comment

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 […]

Read More

Oracle Block Corruption Fix

oracle-block-corruption

26 November 2019   0 Comment

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, […]

Read More

How to Installation PostgreSQL 12 on Redhat and Centos 6,7 Linux

redhat-postgresql

25 November 2019   0 Comment

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 […]

Read More

MySQL 5.6 & 5.7 Installation on Redhat and Centos 6,7 Linux

Mysql Oracle

  0 Comment

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 […]

Read More