Backup and Restore MySQL Database
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…
Read MoreMYSQL DB SWITCHOVER
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 instructions. Step…
Read MoreCRS-6706: Oracle Clusterware Release patch level (‘35319490) does not match Software patch level (‘xxxxxxxxx’). Oracle Clusterware cannot be started
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.…
Read MoreHow To Open the Standby Database When the Primary Is Lost
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…
Read MoreSteps for modifying the scan name configuration in oracle RAC.
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…
Read MoreDifferent ways to get the Explain Plan for a SQL ID
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 execution…
Read MoreORACLE GOLDEN GATE INSTALLATION IN 19c DATABASE
Environment Details Server Name : primegg.localdomain OS Version : Oracle Linux Server release 7 Database Version : 19.0.0.0 GoldenGate Version : 19.1.0.0.4 for oracle Oracle Home : /u01/app/oracle/product/19.0.0/dbhome_1 GoldenGate…
Read MoreHow to Resolve Gaps in Data Guard Apply Using Incremental RMAN Backup
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> select…
Read MoreBacking Up a Block Volume in OCI
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 application interruption…
Read MoreQuery to check the generation of all redo during the time period
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, sum(db_block_changes_delta) from dba_hist_seg_stat dhss, dba_hist_seg_stat_obj dhsso, dba_hist_snapshot dhs where…
Read More