Category: BACKUP & RECOVERY
For BACKUP & RECOVERY articles under category MySql.
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 […]
101 Total Views
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 […]
204 Total Views, 2 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 […]
289 Total Views
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 […]
328 Total Views
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 […]
280 Total Views
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) […]
574 Total Views, 1 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 […]
211 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 […]
222 Total Views
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 […]
350 Total Views, 2 Views Today
Full Database Refresh Using EXPDP-IMPDP Datapump command
Step by Step guide for Full Database 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. Here we are performing a full database refresh activity using Datapump: PARAMETERS SOURCE […]
770 Total Views, 7 Views Today
Recent Comments