0 Comments

Drop MySql Replication Slave Configuration 0 (0)

Drop MySql Replication Slave Configuration In a previous blog, we had created File Based Master Slave Replication Click here to read more. In this post, we will remove the same master slave configuration. Below are detailed steps: Login to mysql slave instance and use command show slave status \G to get the current configuration. Run […]

 210 Total Views,  1 Views Today

0 Comments

Mysql Logical Backup using mysqlsh – Import 0 (0)

Mysql Logical Backup using mysqlsh – Import This blog post is a continuation of the previous blog post Mysql Logical Backup using mysqlsh – Export Click here to read more. In the previous blog, we saw How to perform the export of the Database and Table using mysqlsh. Now in this post, we will see How to perform an import of […]

 289 Total Views

0 Comments

Step by Step Drop Database using DBCA in Oracle 0 (0)

Step by Step Drop Database using DBCA in Oracle In this article, we are going to demonstrate Step by Step DROP database using DBCA (GUI) in Oracle. Generally, we do drop the database when application testing completed or not require anymore to business. We can drop the database using the below methods: 1. Manual (Command […]

 329 Total Views,  2 Views Today

0 Comments

Mysql Logical Backup using mysqlsh – Export 0 (0)

Mysql Logical Backup using mysqlsh – Export In this article, we are going to demonstrate MySQL Logical Backup using mysqlsh – Export. There are several ways to backup MySQL data. Those are: –                   1) Physical Backup                   2) Logical Backup Physical Backup:It […]

 328 Total Views

0 Comments

Mysql Logical Backup using myloader – Import 0 (0)

Mysql Logical Backup using myloader – Import This blog post is a continuation of the previous blog post Mysql Logical Backup using mydumper – Export Click here to read more. In the previous blog, we saw How to perform the export of the Database and Table using mydumper. Now in this post, we will see […]

 280 Total Views

0 Comments

Mysql Logical Backup using mydumper – Export 0 (0)

Mysql Logical Backup using mydumper – Export In this article, we are going to demonstrate Mysql Logical Backup using mydumper – Export.  There are several ways to take the backup of MySQL data. Those are: –                   1) Physical Backup                   2) […]

 574 Total Views,  1 Views Today

2 Comments

Step by Step How to increase SGA size in Oracle 4.3 (3)

Step by Step How to increase SGA size in Oracle I was facing a memory issue in my environment after validating the AWR  and ADDM reports and came to the conclusion that SGA is undersized. Below are both options to increase SGA_MAX_SIZE and SGA_TARGET size using pfile & spfile. in our environment, it’s running using […]

 1,199 Total Views,  9 Views Today

0 Comments

Mysql Logical Backup using mysqlpump – Import 0 (0)

Mysql Logical Backup using mysqlpump – Import This blog post is a continuation of the previous blog post Mysql Logical Backup using mysqlpump – Export, Click here to read more. mysql utility is used to import mysqlpump dump files so import commands are the same like we used in mysqldump. In the previous blog, we […]

 211 Total Views

2 Comments

Step By Step Apply Combo Patch on Primary & Standby (DATAGUARD) Database in Oracle 5 (3)

Combo Patch Apply on Primary & Standby Database in Oracle In this article, we are going to demonstrate step by step apply combo patches on Oracle Primary & Standby (DATAGUARD) which released in January 2021, combo patch contains PSU (31985579) and  OJVM (32119956) patches. Below is the database, system,  patch id, etc. details. COMPONENTS PRIMARY […]

 993 Total Views,  3 Views Today

0 Comments

How to Check PGA information in Oracle 0 (0)

How to Check PGA full information in Oracle.   A Program Global Area (PGA) is a memory region that contains data and control information for a server process. It is nonshared memory created by Oracle Database when a server process is started. Access to the PGA is exclusive to the server process. There is one PGA for […]

 142 Total Views