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 MoreControlling visibility of databases and server level setting by Contained Database
Controlling visibility of databases and server level setting by Contained Database Introduction: Contained Database is a new feature of SQL Server 2012. A contained database is a database that is…
Read MoreHow to install POSTGRESQL and PGADMIN on linux 7 (REDHAT,CENTOS,ORACLE LINUX)
INTRODUCTION: This doc will guide you through the process of installing Postgresql14, Pgadmin4 and also Creating users, databases, schemas VERSION: PostgreSQL14 PGAdmin-4 Verify Platform compatibility using below link https://www.enterprisedb.com/resources/platform-compatibility…
Read MoreBACKUP USING SQL SERVER AGENT
In this blog post, we will explore the process of scheduling and taking a backup of a SQL Server database using the SQL Server Agent method. Firstly, log in to…
Read MoreBACKUP USING MAINTENANCE PLAN
In this blog post, we will explore the process of scheduling and taking a backup of a SQL Server database using the SQL maintenance plan method. Firstly, log in to…
Read MoreSmart Flash Log Write-Back in oracle exadata
Smart Flash Log Write-Back Let us go through what is Smart Flash Log Write-Back in oracle exadata. On High Capacity Oracle Exadata Storage Servers, all redo log entries must be…
Read MoreLPX-00202: could not open opmn.xml
Recently we faced the below issue in fsclone. I have given the solution for it to resolve it. Issue: cat FSCloneApplyAppsTier_12210307.log ERROR: RC-50410: Fatal: OUI Registration failed with an Abnormal…
Read MoreSETUPAWS CERTIFICATE TO SEND E-MAIL
SETUPAWS CERTIFICATE TO SEND E-MAIL Download the certificates from the link provided by Amazon. Click on PEM Copy the text. Create five certificate file using notepad with extension .crt. Move…
Read MoreEnabling Database management and Operation insights in OCI console
Enabling Database management and Operation insights in OCI console Enabling Database Management: Navigate to the Observability & Management. In the Observability & Management, under Database Management section select the…
Read More