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

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-686125f2ce7f8917301323/] [crayon-686125f2ce7fd855089401/] …

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

Check Data Guard Recovery Mode You can find database_mode, recovery mode and protection mode of your Data Guard as follows. [crayon-686125f2d1743356241487/] 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-686125f2d196e043769564/] or [crayon-686125f2d1973655162695/]

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 …

Conversion operations in datetime data types often cause poor performance but they are always the ones that are overlooked. We will examine the Cast and …