Oracle DBA 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.
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.
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.
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.
What are channels?
RMAN process uses channel to communicate with I/O devices.
You can control the type of I/O device, parallelism, number of files and size of files by allocating channels.
100+ Common Puzzles asked in Interviews with Answers More
100+ TNPSC General Studies Question Paper with Answers More
100+ TNPSC Indian Economy Mock Test More
100+ World Economy Objective Type Questions and Answers More
100+ Economics Quiz Questions and Answers Pdf More
Sentence Completion Exercises with Answers More
Computer General Knowledge Objective Questions and Answers More
Top 50+ Advanced Java JDBC Interview Questions 2019-2020 More
100+ Missing Number Reasoning Questions for SSC & Bank Exams More
JDBC Interview Questions for Freshers or Experienced Pdf More