The Oracle DBA's

## ############ORACLE DBA INTERVIEW QUESTIONS (L2)##################### How Will you create RAC DB from Standalone DB. How you create DR DB from scratch. How will you proceed to migrate your database from FS to ASM. What is Voting Disk, why its required? what is the minimum and maximum number of voting disk that you can have for voting disk. What processes are required in RAC? What does LNS,RFS process do? What is load balancing and its type? How will you perform refresh on RAC Database. What is  raw disk and ASM . How do you approach to stop and start services in RAC env. Why do we need public, private and Virtual IP's? What is ACFS? How do you perform switchover and failover? How to make DB in sync with standby database if its not in sync. what could be the causes? In case of performance issue, how you approach to resolve it. How will you record the information of your current session? How can you use the information collected in trace file from your session? Why you do Inde...

Explain Logical structure of the database. Explain Physical structure of the database. What is difference between hot and cold backup. what are your day to day activity. what steps and checks will you take if application team informs you that they are getting slowness? Explain what do you understand by blocking and locking. what can cause the archive log gap issue in standby database and how do you intend to solve it? what are the different parameters required for oracle standby database? what is the enhanced feature in 12c? what is startup sequence for oracle rac? how to create grid database? how to restore database? explain in details. what are the deamon processes in rac? overview of cluster configuration. how to check long running queries?  how to take archive log backup? what is difference between L0 backup and database full backup? explain backup policy in RMAN. why OCR and voting disks are required? How to convert physical standby da...

####################ORACLE DBA INTERVIEW QUESTIONS (L2)##################### which backup strategy would you choose to have less MTTR for your database? what steps will you perform to recover your database running on asm instance to bring it in consistence and open mode describe it from scratch, think of it as you have lost all of your data plus database software? what does recover database command does at back-end? what can cause a stored pl/sql procedure to go in invalid state? what type of table partition you know? what are the different type of redundancy of disk in rac/asm management? what is the difference between view and materialized view? what are the possible ways to bring you objects (pl/sql or function) back in valid state from invalid state.? is it a problem to have an object in invalid state in your database.? suddenly your database backup is taking time much higher than usual, what checks will you perform in order to identify the issue.? how t...