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 …
Read More »ORA-48318: ADR Relation [HM_FINDING] of version=5 cannot be supported
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 …
Read More »How To Check Data Guard Status
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-660647967af3c916380260/] [crayon-660647967af44475579656/] …
Read More »How To Find All Standby Databases for a Primary Database in Data Guard
You can find all standby databases for a primary database in data guard by using one of the queries below. [crayon-660647967b996135425478/] or [crayon-660647967b9a1069013026/] Standby -> …
Read More »Oracle Data Guard Recovery Mode
Check Data Guard Recovery Mode You can find database_mode, recovery mode and protection mode of your Data Guard as follows. [crayon-660647967c05b672351075/] Data Guard Recovery Modes …
Read More »How To Check Standby Redo Logs
This article contains scripts about checking Standby redo logs. You can use the below queries to check standby redo logs in Oracle. [crayon-660647967c3c5509490486/] or [crayon-660647967c3ce461918409/]
Read More »Revoke Permission in PostgreSQL
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 …
Read More »Cast and Convert Performance in SQL Server
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 …
Read More »Streaming Backup with PostgreSQL Barman
What is Barman? Barman is an open source backup / restore management tool in PostgreSQL. What can you do with Barman? You can create backups …
Read More »Upgrade PostgreSQL 11 to 12
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 …
Read More »