ORACLE

Far SYNC is a feature introduced with 12c. It is the dummy instance that sends the Redos from the Primary Database to other Standby Databases in the Data Guard configuration. …

Oracle Authentication Methods EXTERNAL AUTHENTICATION In this mode of authentication, the user need not required to supply his password for the database login. By default the value for the parameter …

Reporting users who query the “Active Data Guard” may want that the data be synchronized with Production. Others may not care whether LAG has occurred for a few seconds. Minor …

What is Oracle Active Data Guard? Oracle Active Data Guard is a Physical Standby Option available with Enterprise Edition. Thanks to Active Data Guard, we do not leave Data Guard …

We will configure linux for oracle database in this article. We will edit the host file. We will do this in both nodes. (with root user) Configure /etc/hosts for Oracle …

We will install Oracle grid infrastructure 11g on linux in this article. We are starting the Grid Infrastructure installation. We do this only on one node. (with grid user) Step1:Before …

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 oracle user) [crayon-600bfef02eb8f535142217/] Oracle RAC …

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 …