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.
DI Pie Chart Questions and Answers for Bank Exams More
100+ Area Aptitude Questions and Answers Pdf More
100+ Data Interpretation Pie Chart Questions and Answers More
True Discount Questions and Answers for Bank Exams More
100+ HCF and LCM Questions and Answers for SSC Exams More
1000+ Sentence Correction Verbal Ability Questions & Answers More
Oracle Core DBA Interview Questions Answers Pdf More
Top 1000+ Computer Fundamentals Questions and answers More
Indian Freedom Struggle Questions and Answers Pdf More
Panchayati Raj Multiple Choice Questions and Answers More