Oracle Backup and Recovery Question

13. What is a backup set?
 
  • Backup set is a logical grouping of backup files that are created when you issue an RMAN backup command.
  • It is RMAN's name for a collection of files associated with a backup. A backup set is composed of one or more backup pieces.
 
Your Name Your Email-ID
Your Answer
14. Can you take online backups if the database is running in the NOARCHIVELOG mode?
  No
 
Your Name Your Email-ID
Your Answer
15. Which is more efficient – incremental backups using RMAN or incremental export?
  RMAN incremental backup is more efficient than the incremental export.
 
Your Name Your Email-ID
Your Answer
16. What is the difference between hot backup and cold backup?
 
  • Hot backup is taken when database is still online while cold backup is taken when database is offline.
  • Database needs to be in the archive log mode for the hot backup but there is no such requirement for the cold backup.
 
Your Name Your Email-ID
Your Answer
123456789 Page 4 of 9