Resizing redo logs and standby Redologs in Dataguard
IN PRIMARY DATABASE :- ------------------------------------- Moving on to the standby database:- ------------------------------------- Scripts used in…
Read MoreRAC
Command to Check Archivelog Size
Oracle databases maintain a detailed history of all changes made to the database through archived…
Read MoreSplit Brain Syndrome in RAC
Where two or more instances attempt to control a cluster database. Each node in this…
Read MoreVoting Disk in Oracle RAC
Voting disks manage information about node membership. Each voting disk must be accessible by all…
Read MoreOracle Local Registry (OLR) in RAC
Oracle Clusterware includes three components: voting disks, Oracle Cluster Registry (OCR), and Oracle Local Registry…
Read MoreOracle Single Client Access Name (SCAN)
Single Client Access Name (SCAN) is a feature used in Oracle Real Application Clusters environments…
Read MorePrerequisite check “CheckActiveFilesAndExecutables” failed.
While trying to rollback the conflicting patch 18893947 applying patch 21967332 Following executables are active…
Read MoreOracle Clusterware Startup Sequence
What is Oracle Clusterware – RAC ? Oracle Clusterware enables servers to communicate with each…
Read MoreManual creation of SQL Profiles in Oracle Database
SQL Profiles are a powerful tool to improve performance of SQL queries in your Oracle…
Read MoreHow To Run SQL Tuning Advisor
When we run SQL tuning advisor against a SQL statement or sql_id, it provides tuning…
Read More