RMAN INTERVIEW QUESTIONS AND ANSWERS IN ORACLE 11G PDF

A 10 Control file is very important file for the database operation. Loosing a single control file will make the database unstable and will lead to interruption in service. So we will always try to put control file in a safe and stable place. Similarly online logs are equally important and loosing them can also cause database to crash, incomplete recovery and possible data loss. CASE 1: Usually the flash recovery area and the main database disks are located in such a way that the probability of both going down at the same time is very slim.

Author:Kazibei Shaktishicage
Country:Guatemala
Language:English (Spanish)
Genre:Relationship
Published (Last):26 May 2018
Pages:77
PDF File Size:14.8 Mb
ePub File Size:17.44 Mb
ISBN:227-8-59752-361-1
Downloads:5392
Price:Free* [*Free Regsitration Required]
Uploader:Yozshum



Question 9. Answer : Control file is very important file for the database operation. Loosing a single control file will make the database unstable and will lead to interruption in service. So we will always try to put control file in a safe and stable place. Similarly online logs are equally important and loosing them can also cause database to crash, incomplete recovery and possible data loss.

CASE 1: Usually the flash recovery area and the main database disks are located in such a way that the probability of both going down at the same time is very slim. It will surely help you in quick and complete recovery. CASE 2: If your flash recovery area is NOT as reliable as the main database storage, the chance of failure in the flash recovery area is greater compared to the main database disks. If the flash recovery area fails, then you lose one of the control files and the online redo log.

You will be able to start database easily by removing that control file from the control file parameter in the initialization parameter file copying online log from the secondary Non-FRA location and restarting it but you will have an interruption of production service, which is very undesirable.

Scenario B: Besides FRA, we have multiplexed Control files to only one other separate location, so risk of loosing control file and and fear of not able to do complete recovery is more.

Complete recovery of database is of primary importance to you than the database interruption. Here we can go and put the control file in FRA. Question

ELEMENTI DI ELETTRONICA TURCHETTI CONTI PDF

Oracle Database RMAN Interview Questions

When RMAN is initiated, it will start reading datafile headers for used block information. What is the reason? It means two backups on same database are trying to take controlfile backup and one of the backup is placed in queue until first one completes What is your backup strategy? Daily we will take full RMAN backup for all prod databases and will take structural export backup.

LEGO 8038 PDF

ORACLE DATABASE RMAN INTERVIEW QUESTIONS

It is an Oracle Database client which is used for the backup and recovery tasks on our databases and it can also automate the administration of our backup strategies. It is true that every interview is different as per the different job profiles. What are the main features of RMAN? Answer: Rman provides us access to various kinds of backup, recovery techniques, and many other features also. Few of them listed below. Compression Unused block: It is one the features of the RMAN, which give provision to skip blocks of the data that have never been used.

ETIKA NOVINARSTVA PDF

RMAN (Recovery Manager) Interview Questions & Answers

As per technologies changes, we should also upgrade our self. I have selected some very important Questions and Answers as per my experiences and I have some more questions which I will be including here soon. What is RMAN? Why to use RMAN? RMAN gives you access to several backup and recovery techniques and features not available with user-managed backup and recovery. Additionally, you can store this metadata in a recovery catalog.

Related Articles