Home / DBA Interview Questions / REDOLOG FILES & CONTROL FILES INTERVIEW QUESTIONS

REDOLOG FILES & CONTROL FILES INTERVIEW QUESTIONS

REDOLOG FILES & CONTROL FILES INTERVIEW QUESTIONS

REDOLOG FILES & CONTROL FILES INTERVIEW QUESTIONS

  1. Why to multiplex redolog files?

    1. To avoid any data loss
  2. What is log switch?

    1. LGWR switching between two redolog groups
    2. 3.If we have multiple members in a single group, how LGWR will write into them?

    1. It will write paralley if ASYNC I/O is enabled at OS level. Otherwise, it will write insequential order

  3. Can we have different sizes for members in the same group?

    1. Not possible

  4. Can we create different groups with different sizes?

    1. Yes. But it is not recommended as checkpoint occurence will change and it will not be consistent

  5. What is the use of FAST_START_MTTR_TARGET parameter?

    1. It is used to specify at what frequency checkpoint should occur in order to make data permanent

  6. What is the min size that can be given during redolog file creation?

    1. 10MB

  7. How to resize the redolog files?

    1. Not possible. If we want, we can create new group with more size and drop existing group

  8. Where to check the status of redolog group? What it mean when we see INVALID status?

    1. We can check from v$log view and INVALID means redolog file or group is corrupted

  9. Where we can check controlfile location?
    1. Using CONTROL_FILES parameter

  10. What is archive log mode? Why it is required?
    1. Archive log mode is a modein which database stores all the changes occured in the form of archives. It is used to recover the database when we have old backup

  11. What is the default location of archives in 10g?

    1. Flash recovery area

  12. If archive destination is full, how you will react?

    1. We will first see for possibility of taking backup, if not we will move some archives to other mount point or in worst case we will delete them. But when we delete them, immediately we need to take full database back

ORACLE INSTALLATION INTERVIEW QUESTIONS

Read More:
ORACLE DATAPUMP
ORACLE EXPORT & IMPORT
about ORACLE UTILITIES ( SQL * Loader )
DON’T MISS OUT!
Subscribe To Newsletter
Be the first to get latest updates and exclusive content straight to your email inbox.
Stay Updated
Give it a try, you can unsubscribe anytime.

Check Also

ORACLE BACKUP and RECOVERY INTERVIEW QUESTIONS

BACKUP & RECOVERY INTERVIEW QUESTIONS 1.What is the difference between cold and hot backup? a.COLD …

Leave a Reply

Your email address will not be published. Required fields are marked *

DON’T MISS OUT!
Subscribe To Newsletter
Be the first to get latest updates and exclusive content straight to your email inbox.
Stay Updated
Give it a try, you can unsubscribe anytime.
close-link
GET OUR LATEST CONTENT IN YOUR INBOX

SUBSCRIBE 
Your information will never be shared
close-link
Enquiry
Submit
close-link
Sign-up for exclusive content. Be the first to hear about DBA Centre Blogs.
Subscribe