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

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

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

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 …

What is Barman? Barman is an open source backup / restore management tool in PostgreSQL. What can you do with Barman? You can create backups …

In this article, we will upgrade PostgreSQL 11 to 12. If you want to upgrade PostgreSQL 10 to 11 you should read the article “Upgrade …

You can read this document to access the tables in the MSSQL database using the DBLINK architecture from the Oracle database. Please test in the …

When you create backups with rman in Oracle 12.2 databases, an “RMAN-10038: database session for channel d1 terminated unexpectedly” error occurs. You see the error …

You can run rman in debug mode to get more detailed information about Rman operations. In this way, we get more detailed information about a …