With the help of this article, we will discuss basic MS SQL Server Database backup and restore, how to create a maintenance plan and strategies of restoring in SQL server. Back-up Types We can take mainly four types of backup in SQL server database, namely – Full Differential Transaction Log Copy Only Configuring Maintenance Plan […]
This article can guide you to alter the DBID for Oracle databases whenever we are in need of it. Here we will use DBNEWID utility to change the same. Below are the steps to follow. Steps to Change the DBID for Oracle Database Before starting the process of changing the DBID please ensure you have
Problem Description While restoring from an RMAN backup it’s failing with the following error. RMAN-06100: no channel to restore a backup or copy of datafile Example : – Connect target / RMAN> restore database; RMAN-03002: failure of restore command at 01/23/2022 12:29:17 RMAN-06026: some targets not found – aborting restore RMAN-06100: no channel to restore
This article will cover step by step Oracle 19C installation on Linux / Red Hat Enterprise Linux Server release 7.9. Before starting of the process you need to download the oracle 19.3 binary OTN: Oracle Database 19c (19.3) Software (64-bit) Oracle 19C Installation Prerequisites There are two options for completion of basic prerequisites. Automatic Setup Manual Setup
It’s very important to possess a homogenous backup of a database so that in case of any unforeseen issues we can recover the data from the backup and run the system. Backups are also essential to safeguard ourselves before upgrading a MySQL database. MySQL offers different types of backup methods from that you can choose the
MySQL Backup & Restore | How to Take Backup & Restore a MySQL Database Read More »
MySQL is an open-source most popular database nowadays. It comes with a variety of built-in replication features, which helps us to maintain ‘n’ no of copies of your database. MySQL replication is a process that allows data to be replicated from one server to the other in real-time. It is mainly used as a disaster
MySQL Master-Slave Replication | How To Set Up Master-Slave Replication in MySQL Read More »
From this article you will know how to upgrade MySQL 5.7 to 8.0.21 in Linux. Please go through the recommendation once before starting the actual database upgrade. If your MySQL installation contains a large amount of data that might take a long time to convert after an in-place upgrade, it may be useful to create
How to Upgrade MySQL 5.7 to 8.0.21 | MySQL Version Upgrade from 5.7 to 8.0.21 Read More »
The error “ora-00980 synonym translation is no longer valid” received for a materialized view in one database. Through this article we will try to resolve the issue. Reason | Cause There can be two reasons either the user doesn’t have the required privilege or the object it’s referring to doesn’t exist. In our case, we
ORA-00980: Synonym Translation Is No Longer Valid Read More »
From this article you will know how to upgrade MySQL 5.6 to 5.7 in Linux. Please go through the recommendation once before starting the actual database upgrade. If your MySQL installation contains a large amount of data that might take a long time to convert after an in-place upgrade, it may be useful to create
How to Upgrade MySQL 5.6 to 5.7 in Linux | MySQL Version Upgrade in Linux Read More »
MySQL is the most popular open-source RDBMS now a days. In our guide, we will come to know how to install MySQL 5.7 on a Linux server. Software / Binary Download To download MySQL binary please visit it’s official site. If you are unable to find the desired version click on archive section as described. Select
