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-6742a33380e52907356475/] [crayon-6742a33380e57946919371/] …

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

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

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 …

With the new feature that introduced with Oracle 18c, it is now possible to stop the running query in a session without terminating session. You …