Introduction: In this article, we are here to know different ways to generate the backup in the MySQL database server. It is essential to make regular backups of all data in case of loss. Why we [...]

INTRODUCTION: This doc will guide you through the process of performing a MySQL replication switchover, ensuring a smooth transition without any data loss. Let’s dive into the step-by-step [...]

Problem: After patching an Oracle 19.8 GRID_HOME on Oracle Restart setup with 19.20 RU patch [35319490], I was not able to start up Oracle Restart HAS due to mentioned error. Cause: This issue [...]

In this case how to open your standby database in read/write mode when you don’t have any access (Lost) on Primary database. NOTE: Currently both Primary and Standby database are in sync. [...]

INTRODUCTION What is scan name for Oracle database? Single Client Access Name (SCAN) is a feature used in Oracle Real Application Clusters environments that provides a single name for clients to [...]

1.To Display the execution plan of the last SQL statement executed by the current session  SET LINESIZE 150  SET PAGESIZE 2000  SELECT * FROM table (DBMS_XPLAN.DISPLAY_CURSOR);  2.To display the [...]

Environment Details Server Name                         : primegg.localdomain OS Version                           : Oracle Linux Server release 7 Database Version                 : 19.0.0.0 [...]

Step-1: Check the SCN of Standby ( Data guard ) database and Find the lowest SCN from the following Queries. SQL> SELECT CURRENT_SCN FROM V$DATABASE; CURRENT_SCN -------------- 1165261 SQL> [...]

Description: The backups feature of the Oracle Cloud Infrastructure Block Volume service lets you make a crash-consistent backup, which is a point in time snapshot of a boot volume without [...]

Description: This query used to check the generation of all redo during the time period. Script: select to_char(begin_interval_time,'YYYY_MM_DD HH24:MI') snap_time, dhsso.object_name, [...]