Category: BACKUP & RECOVERY
For BACKUP & RECOVERY articles under category MySql.
How to Rename Database and DBID using DBNEWID in Oracle
Rename Database and DBID using DBNEWID in Oracle In this article, we are going to demonstrate rename of the database along with DBID using utility DBNEWID in Oracle. The question comes in mind why we require to rename DB? Whenever we do clone a database to a target (clone DB) server from the source (production […]
122 Total Views, 6 Views Today
RMAN Full Database Backup Scripts in Oracle
RMAN Full Database Backup Scripts in Oracle. In this article, we are going to prepare a script for RMAN full database backup which includes backup of datafiles, control files, spfile along with archives. This RMAN full database script will create a backup in a specified location (local directory) on the database server. Generally, we do […]
332 Total Views, 2 Views Today
Multiplexing of Control Files Using RMAN, SPFILE & PFILE in Oracle
Multiplexing of Control Files Using RMAN, SPFILE & PFILE in Oracle Here we are going to demonstrate multiplexing of Control Files in Oracle using available options SPFILE, PFILE & RMAN. Before moving ahead first we will have a basic understanding of Control Files in Oracle. Control File is a physical file on OS level and […]
850 Total Views, 18 Views Today
Mysql Logical Backup using mysqlsh – Import
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 […]
550 Total Views, 5 Views Today
Mysql Logical Backup using mysqlsh – Export
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 […]
1,023 Total Views, 2 Views Today
Mysql Logical Backup using myloader – Import
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 […]
568 Total Views, 1 Views Today
Mysql Logical Backup using mydumper – Export
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) […]
796 Total Views, 2 Views Today
Mysql Logical Backup using mysqlpump – Import
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 […]
400 Total Views
Mysql Logical Backup using mysqlpump – Export
Mysql Logical Backup using mysqlpump – Export In this article, we are going to demonstrate Mysql Logical Backup using mysqlpump – Export. There are several ways to backup MySQL data. Those are: – 1) Physical Backup 2) Logical Backup Physical […]
410 Total Views, 2 Views Today
Table Refresh Using EXPDP-IMPDP Datapump Command
Step by Step guide for Table Refresh using DataPump Utility Oracle Data Pump is a high-speed data movement utility provided by Oracle (10g onwards). It’s an extension to the old EXP and IMP utility with improved performance and enhanced security features. Requirement of Table refresh: Table refresh is a common task that is quite often […]
693 Total Views, 2 Views Today
Recent Comments