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-68eb4c3d9f96a988995287/] [crayon-68eb4c3d9f96e051167736/] …

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

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

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 …