« Technical Interview & Viva Questions : KyaPoocha.com home page
« How to implement the multiple control files for an existing database?
What is a Rollback segment entry? »



What is meant by Redo Log file mirroring ? How it can be achieved?


Process of having a copy of redo log files is called mirroring.
This can be achieved by creating group of log files together, so that LGWR will automatically writes them to all the members of the current on-line redo log group. If any one group fails then database automatically switch over to next group.



Explore posts in the same categories: SQL Interview Questions


BOOKMARK THIS : del.icio.us | Digg it | Furl | reddit |

Related Questions :

  • What is On-line Redo Log?
    • The On-line Redo Log is a set of tow or more on-line redo files that record all committed changes made...
  • What is On-line Redo Log?
    • The On-line Redo Log is a set of tow or more on-line redo files that record all committed changes made...
  • What is redo log buffer?
    • Changes made to the records are written to the on-line redo log files. So that they can be used in...
  • What are database files, control files and log files. How many of these files should a database have at least? Why?
    • Database Files The database files hold the actual data and are typically the largest in size. Depending on their sizes,...
  • How to access an external javascript file that is stored externally and not embedded?
    • This can be achieved by using the following tag between head tags or between body tags. where abc.js is the external...
  • What is the use of Control File ?
    • When an instance of an ORACLE database is started, its control file is used to identify the database and redo...
  • What is Log Switch ?
    • The point at which ORACLE ends writing to one online redo log file and begins writing to another is called...
  • What is Log Switch ?
    • The point at which ORACLE ends writing to one online redo log file and begins writing to another is called...
  • What is cold backup and hot backup (in case of Oracle)?
    • Cold Backup: It is copying the three sets of files (database files, redo logs, and control file) when the instance...
  • Explain the Memory Structures of the Oracle database ?
    • Oracle creates and uses memeory sructures to complete several jobs. For example, memory is used to store program code being...

    Comments are closed.