What are the different types of backup’s available and also explain the difference between them?

@ : Home > > Interview Room

There are 2 types of backup’s

1. COLD backup(User managed & RMAN)
2. HOT backup(User managed & RMAN)

  • Hot backup is taken when the database is still online and database should be in ARCHIVE LOG MODE.
  • Cold backup is taken when the database is in offline mode.
  • Hot backup is inconsistent backup where as cold backup is consistent backup.
Alert me