Friday , June 23 2017
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 )

Comments

comments

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 *