Category: ORACLE

Oracle String Functions

This article contains information about oracle string functions such as length, substr, concat, trim in Oracle database management system. What

In Oracle databases, when the downgrade operation or “migrate schema” operation is done through adrci, when using the adrci, ORA-48318

We will check data guard status in SQL Plus in this article in many ways. Check 1: Check for LAG

You can find all standby databases for a primary database in data guard by using one of the queries below.

Check Data Guard Recovery Mode You can find database_mode, recovery mode and protection mode of your Data Guard as follows.

This article contains scripts about checking Standby redo logs. You can use the below queries to check standby redo logs

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

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

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

With the new feature that introduced with Oracle 18c, it is now possible to stop the running query in a