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.
SAP SD Interview Questions and Answers More
Top 1000+ Bank Exams Question Papers with Answers Pdf More
1000+ SBI Computer Awareness Study Material More
Top 1000+ Preposition Questions for SSC Exams More
Preposition Quiz Questions and Answers for Bank Exams More
Letter Series Questions with Answers for Bank Exams More
100+ Statement and Assumption Questions for RRB NTPC More
TNPSC Group 1, 2, 2a, 4, VAO History Study Materials in Tamil & English Pdf More
List of World Famous Newspapers and Magazines Pdf More
Computer Awareness Questions for BCA/MCA Entrance More