Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux

We will install  couchbase Server on ubuntu 16.04 in this article. Please visit the link below for minimum system requirements. Link : https://docs.couchbase.com/server/current/install/plan-for-production.html WARNING: Make sure …

In this article, we will install apache cassandra on Centos 7 in a Standalone structure. Now let’s start installing our Cassandra NoSQL database on Centos …

What is real time apply in dataguard? If media recovery is started with the following command after installing Data Guard in versions prior to Oracle …

This article contains information about oracle string functions such as length, substr, concat, trim in Oracle database management system. What is Oracle string function? Oracle …

In Oracle databases, when the downgrade operation or “migrate schema” operation is done through adrci, when using the adrci, ORA-48318 error is received when the …

We will check data guard status in SQL Plus in this article in many ways. Check 1: Check for LAG from V$DATAGUARD_STATS View. [crayon-676aec1011e5c186049304/] [crayon-676aec1011e61451948694/] …

You can find all standby databases for a primary database in data guard by using one of the queries below. [crayon-676aec1012516623007630/] or [crayon-676aec101251b215824330/] Standby -> …

Check Data Guard Recovery Mode You can find database_mode, recovery mode and protection mode of your Data Guard as follows. [crayon-676aec1012820036297318/] Data Guard Recovery Modes …

This article contains scripts about checking Standby redo logs. You can use the below queries to check standby redo logs in Oracle. [crayon-676aec10129f7228495157/] or [crayon-676aec10129fb022958814/]

This article contains information about revoke command usage in PostgreSQL. You may want to revoke permissions of users. In this case, you can use the …