1) Briefly describe what is redo log files? Redo Log Files record all changes made to data and provide a recovery mechanism from a system or media failure. Redo log files are organized into groups. An Oracle database requires at least two groups. Each redo log within a group is called a member. 2) Briefly describe how redo log works? Redo logs are used in a cyclic fashion. When a redo log file is full, LGWR will move to the next log group. This is called a log switch Checkpoint operation also occurs Information is written to the control file 3) Briefly describe how you can obtain redo log group and member information? Information about group and members can be obtained by querying the data dictionary. V$LOG V$LOGFILE 4) Briefly describe why you need to archived redo log files? Filed online redo log files can be archived. Two advantages exist to archiving redo log: Recovery: A database backup, together with online and archived redo log files can guarantee recovery of all committed transaction.
You've reached the end of your free preview.
Want to read both pages?
- Winter '16
- k teng