Oracle DBA Backup and Recovery Interview Questions - 1
Question: 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.
Question: 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.
Question: 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.
Question: 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.
Question: 5
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.
7000+ Subject Verb Agreement Exercises for Class 6, 7, 8, 9, 10 More
7000+ Tenses MCQ Questions for Class 6, 7, 8, 9, 10 More
7000+ Tenses English Grammar Exercises with Answers Pdf More
7000+ Simple Compound Words Quiz with Answers More
7000+ Compound Words Worksheet with Answers for Grade 10 More
Top 100+ Problems on Numbers Aptitude Questions and Answers More
1000+ Physics Questions for SSC CGL Tier 1, Tier 2 Exam Pdf More
Top 250+ C++ Constructor and Destructor Programming Interview Questions More
General English Prepositions Questions and Answers More
Polytechnic TRB Chemistry Model Question Paper with Answer Keys More