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.