Oracle Backup and Recovery Question

25. What do you understand by database backup?
  Database is used to store the data, which is the most crucial part of a business. It is important to keep the data safe; and therefore, backup provides a way to safeguard data against any loss. There are mainly three types of backup, which are given as follows:
  • Full backup or normal backup – Refers to the backup of all the datafiles, control files, and SPFILEs.
  • Incremental backup – Refers to the backup of files and folders that have been modified or created after the previous backup. After this backup, the attribute is again reset.
  • Differential backup – Refers to the backup of files and folders that have been modified or created after a previous full or incremental backup. The difference here is that the attributes are not reset. Therefore, every time it backup those files whose attributes have not been reset or changed.
 
Your Name Your Email-ID
Your Answer
26. Where should you place archive log files in the same disk where database exists or in another disk?
 
  • Archive log files should not be saved in the same disk as datafiles to ensure recovery in case of media failure.
  • They should be kept on separate mount points or disk.
 
Your Name Your Email-ID
Your Answer
27. What does RMAN backup consist of?
 
  • RMAN backup consists of a backup of all or part of a database.
  • This result from issuing an RMAN backup command.
  • A backup consists of one or more backup sets.
 
Your Name Your Email-ID
Your Answer
28. Can we take incremental backup without taking the fill backup?
  No, full backup should be taken before the incremental backup.
 
Your Name Your Email-ID
Your Answer
123456789 Page 7 of 9