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 …
Read More »Onur ARDAHANLI
How To Install Oracle RAC 11g
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 …
Read More »What is Real Time Apply in Dataguard
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 …
Read More »How To Check Data Guard Status
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-672174a364350119954324/] [crayon-672174a364354850890228/] …
Read More »How To Find All Standby Databases for a Primary Database in Data Guard
You can find all standby databases for a primary database in data guard by using one of the queries below. [crayon-672174a364dee922709196/] or [crayon-672174a364df3979762419/] Standby -> …
Read More »Oracle Data Guard Recovery Mode
Check Data Guard Recovery Mode You can find database_mode, recovery mode and protection mode of your Data Guard as follows. [crayon-672174a3652d1291669242/] Data Guard Recovery Modes …
Read More »How To Check Standby Redo Logs
This article contains scripts about checking Standby redo logs. You can use the below queries to check standby redo logs in Oracle. [crayon-672174a365589849153217/] or [crayon-672174a36558d293885723/]
Read More »How To Check Whether ARCHIVE Logs are transferred to Standby Database
Whether the ARCHIVE Logs are transferred to Standby can be seen from the ALERT LOGs as follows. [crayon-672174a365785468708176/] After the archives are created, sometimes writing …
Read More »How To Check and Change Redo Log Switch Frequency
If you want to learn What the Redo Log is, you should read the article named “Oracle Redo Log And Archive Log”. I will tell …
Read More »What is Oracle Data Guard redo apply
What is Redo Apply? Redo Apply performs the task of creating a block-by-block copy of the Primary database. The operations are as follows; The RFS …
Read More »