O'Reilly logo

OCA: Oracle 10g™ Administration I: Study Guide by Matthew Weishan, Joseph C. Johnson, Bob Bryla, Chip Dawes

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

10.7. Answers to Review Questions

  1. A. Loss of an entire redo log file group can result in loss of committed transactions that may not yet have been written to the database files. Losing all members of a redo log file group except for one does not affect database operation and does not result in data lost. A message is placed in the alert log file. The failure of LGWR or ARC0 causes an instance failure, but you do not lose any committed transaction data.

  2. C. The LogMiner tool helps you see which transactions have occurred in the database along with the DML to reverse the changes, but it does not minimize the MTBF or reduce the possibility of committed transaction loss.

  3. C. In ARCHIVELOG mode, recovery of the database is possible up to the last COMMIT ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required