0 Comments

How to Rename Database and DBID using DBNEWID in Oracle 0 (0)

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

0 Comments

RMAN Full Database Backup Scripts in Oracle 5 (1)

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

0 Comments

Multiplexing of Control Files Using RMAN, SPFILE & PFILE in Oracle 5 (2)

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

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 […]

 550 Total Views,  5 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 […]

 1,023 Total Views,  2 Views Today

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 […]

 568 Total Views,  1 Views Today

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) […]

 796 Total Views,  2 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 […]

 400 Total Views

0 Comments

Mysql Logical Backup using mysqlpump – Export 0 (0)

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

0 Comments

Table Refresh Using EXPDP-IMPDP Datapump Command 0 (0)

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