ORACLE

We will install Oracle RAC 11g in this article. First, We check cluster services before starting Oracle installation. We do this in both nodes. (with …

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

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 …

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 …

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-676c5bf134bc9837414874/] [crayon-676c5bf134bce867630881/] …

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

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