Oracle Backup and Recovery Interview Questions

1. What is instance recovery?
 
  • Instance recovery is used in Real Application cluster (RAC) environment only.
  • It occurs in an open database when one instance detects that another instance has crashed.
 
Your Name Your Email-ID
Your Answer
2. What is complete recovery?
 
  • Complete recovery uses redo data or incremental backups combined with a backup of a database, datafile or tablespace to update it to the most current point in time.
  • Oracle applies all the redo changes contained in the archived and online logs to the backup.
  • During a complete recovery, all the changes made to the restored file since the time of the backup are redone.
 
Your Name Your Email-ID
Your Answer
3. What is full backup?
 
  • A full backup is a backup of all the datafiles, control files and SPFILE.
  • A full backup can be made with RMAN or the operating system commands while the database is open or closed.
  • As a rule, you must perform full backup, if your database is not running in the archiving log mode.
 
Your Name Your Email-ID
Your Answer
4. What is a recovery catalog?
 
  • Recovery catalog is an inventory of the backup taken by RMAN for the database.
  • It is used to restore a physical backup, reconstruct it, and make it available to the Oracle server.
 
Your Name Your Email-ID
Your Answer
123456789 Page 1 of 9