1. Home
  2. Engineering
  3. CS/IT Engineering
  4. Database
  5. Oracle DBA Interview Questions
  6. What is the difference between cold backup and hot backup?

What is the difference between cold backup and hot backup?

devquora
devquora

Posted On: Feb 22, 2018

 

    1 Answer Written

  • devquora
    Answered by Anil Saini

    Few difference between cold backup and hot backup are

    Cold backup

      • To perform this backup it is needed that no activity should be running on the system.
      • It is also known as an offline backup.
      • In case of cold backup database files are copied exactly like they are made.
      • It is quite easy to take this backup and recovery process is also simple.

    Hot backup

      • Hot backup can be performed even when the database is running.
      • It is also known as online backup.
      • In case of hot backup database files are copied but there can be certain changes in the database at the time of the copy.
      • During the time of the backup you can easily use your system and can recover the database anytime.

Related Questions

Please Login or Register to leave a response.

Subscribe Our NewsLetter

Never Miss an Articles from us.

Recent Articles
Featured Categories

Related Questions

Oracle DBA Interview Questions

What do you understand by the Oracle?

Oracle is a database company that stores the data. Oracle stores the data in a very definite way so that client can regain it in a multi-user condition...

Oracle DBA Interview Questions

What do you mean by Oracle Database?

Oracle has the main theme of storing, creating and managing the database...

Oracle DBA Interview Questions

What do you mean by Oracle DBA and what is its role?

DBA stands for the Database administrator. DBA has the proper rights that can add or remove new users...