ORACLE

This article contains information about oracle date functions such as sysdate, last_day, add_months, extract. Date Functions in Oracle Oracle has several functions to operate on date and time data. ADD_MONTHS …

This article contains information about oracle numeric/math functions and their usage. Numeric/Math Functions Oracle has several functions for processing numerical data. ABS Function in Oracle Returns the absolute value of …

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 12c, Media Recovery starts as …

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 has several functions for manipulating …

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 job named “SYS”.”DRA_REEVALUATE_OPEN_FAILURES” runs. 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-5f9a1fb23117e534924467/] [crayon-5f9a1fb231184901855102/] Check 2: It is also …

You can find all standby databases for a primary database in data guard by using one of the queries below. [crayon-5f9a1fb231946047775987/] or [crayon-5f9a1fb23194b777770344/] Standby -> Returns the unique name of …

Check Data Guard Recovery Mode You can find database_mode, recovery mode and protection mode of your Data Guard as follows. [crayon-5f9a1fb231add816695306/] Data Guard Recovery Modes IDLE Shows that Recovery is …

This article contains scripts about checking Standby redo logs. You can use the below queries to check standby redo logs in Oracle. [crayon-5f9a1fb231cab158130594/] or [crayon-5f9a1fb231cb0119890552/]

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 TEST database first. If you …