What is hot backup and logical backup?

Asked 7 years ago
Viewed 789 times

0 Answer


0

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.

answered 6 years ago by Arti Mishra
  1. Thanks for the explanation. - Anonymous User 5 years ago

Your Answer