---
title: "What is hot backup and logical backup?"  
description: "What is hot backup and logical backup?"  
author: "Jivika Rai"  
published: 2017-11-18  
canonical: https://answers.mindstick.com/qa/30929/what-is-hot-backup-and-logical-backup  
category: "technology"  
tags: ["oracle", "oracle database", "hot backup", "logical backup"]  
reading_time: 1 minute  

---

# What is hot backup and logical backup?

What is hot [backup](https://www.mindstick.com/interview/1205/what-is-the-command-to-take-backup-and-restore-for-sharepoint-site) and logical backup?

## Answers

### Answer by Arti Mishra

**Hot Backup :** \

Hot backup is those type of backup where **you can take the Backup while Database (eg. Oracle) is running state.** In a hot backup, the database **remains open all times** and **available for users.** When you copied any files of the database, after that any save changes occur on a database then changes files are copied during backup must be saved too.\
**Logical Backup :** Logical backups are those types of backups in which the **export utility (for eg Exp) uses SQL to read data from the database** and then **export it into a binary file** at the operating system levels. You can also import the data backup into a database using the import utility (Imp). The Oracle Export Utility can create a file that contains many types of objects in a particular schema. \


---

Original Source: https://answers.mindstick.com/qa/30929/what-is-hot-backup-and-logical-backup

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.