Oracle Backup Recovery Interview QuestionsPosted by Kendba Admin on Apr 14, 2011 in Sample Chapters | Comments Off
Oracle DBA Interview Questions Answers during technical interview – A Sample Chapter
Oracle Backup and Recovery Interview Questions and Answers during telephonic technical interviews
A sample chapter of the book Oracle DBA Interview Questions – topics discussed in this chapter test “Oracle Backup and Recovery without RMAN”.
Here are some interview questions and answers on Oracle Backup and Recovery. All of these interview questions and answers in real-time Oracle DBA interview questions and answers. Be careful with Oracle DBA interviews, as well as very strange SQL issues can be discussed during the interview. As a Oracle DBA candidate you can’t eliminate the real time scenario based backup and recovery interview questions during Oracle DBA interviews.
Some strange interview questions are really very simple, but we found strange because you are not familiar with these types of questions and answers. Most of cases candidate failed due to not preparing proper interview questions and answers.
After all Oracle DBA interview questions and answers are sampling our outstanding book “Oracle DBA interview questions and answers.” These questions are only examples from chapter of primary book. Total more than 80 questions and answers are covering in our “Oracle DBA Interview Questions And Answers” book.
Q-1: One of my control file corrupted and I am unable start database, How can I perform recovery?
Q-2: What is incremental checkpoint?
Q-3: Does incremental checkpoint recorded in Alert.log? How to disable it?
We can enable disable recording incremental checkpoint in alert.log .We can enable/disable recording using parameter log_checkpoints_to_alert=true/false.
Q-4: I am working as Oracle DBA in 24/7 running large production database. Size of database is around 800 GB. We take hot backup every day night. But one day at around 4:00 PM, by mistake one table is dropped by application user. Table is very useful. How to recover that dropped table?
Q-5: In continuation of above scenario, No. Recyclebin doesn’t enable in my database then how to I recover my table in above scenario?
Q-6: In continuation of above scenario, why I should need to perform recovery in UAT or test database server? Can I restore backup in production database server?
Q-7: What is the meaning of LGWR SYNC and LGWR ASYNC in log archive destination parameter for standby configuration?
Q-8: How can I know my require table is available in export dump file or not?
Q-9: Archive log are being generated around 20 GB in my production large database. But one day almost double archives were generated. What is the reason behind this? How can I check it?
Q-10: How do you recover from the loss of datafile if the DB is running in ARCHIVELOG mode?
Q-11: What is a Complete Recovery?
Q-12: Why we should need to open database using RESETLOGS after finishing incomplete recovery?
Q-13: Why export backup called as logical backup?
Q-14: Have you faced any recovery scenario? Explain us how you resolved it?
2 months back, a potential table was dropped by an application developer on our large 24/7 running production database. Immediately he informed us. We have standby database for our production database. We checked that archives didn’t apply to standby database up to dropped timing. We stopped archive applying on standby immediately and open database read only. Took export of dropped table and imported in production database. After finishing appropriate checking of table, again we started archive applying in standby database for refreshing.
Q-15: Which command I should need to execute to take backup of database which is running on NOARCHIVELOG mode?
Shutdown immediate. Because without shutdown, we can’t perform online backup of database, which running on NOARCHIVELOG mode. We should need to take cold backup of database.
This is the sample Oracle Backup and Recovery interview questions answers of topic “Backup and Recovery” of the book Oracle DBA Interview Questions. Kendba provides unique career making services for Oracle DBA from start online Oracle Training, Oracle interview questions books, fresher Oracle jobs assistance services.